Wednesday, May 22, 2019
Wednesday, May 15, 2019
Few XML Tags for RTF Development
<?for-each:G_INVENTORY_ITEM_ID?><?sort:ITEM_CODE;'ascending';data-type='text'?>
<?for-each:G_PO_LINE_NUM?><?sort:PO_LINE_NUM;'ascending';data-type='number'?>
<?if:INVOICE_ID!=''?> <?end if?>
<?for-each:G_PO_LINE_NUM?><?sort:PO_LINE_NUM;'ascending';data-type='number'?>
<?if:INVOICE_ID!=''?> <?end if?>
Monday, May 13, 2019
Example of $FLEX$ Syntax Used In Value Set
Example of $FLEX$ Syntax Used In Value Set ($flex$ in oracle apps)
Segment Name Country_Segment
Segment Name State_Segment
Segment Name District_Segment
In this example, Country_ID is the hidden ID column and Country_Name is the value column of the Country_Value_Set value set. The Model segment uses the hidden ID column of the previous value set, Country_Value_Set, to compare against its WHERE clause. The end user never sees the hidden ID value for this example.
Example of using “:$FLEX$.Value_Set_Name” to set up value sets where one segment depends on a prior segment that itself depends on a prior segment. Suppose you have a three-segment flexfield where the first segment is Country, the second segment is State, and the third segment is District. You could limit your third segment's values to only include Districts that are available for the Address specified in the first two segments. Your three value sets might be defined as follows:
Value Set Name Country_Value_Set
Validation Table Country_Table
Value Column Country_NAME
Description Column Country_DESCRIPTION
Hidden ID Column Country_ID
SQL Where Clause (none)
Value Set Name State_Value_Set
Validation Table State_Table
Value Column State_Name
Description Column State_DESCRIPTION
Hidden ID Column State_ID
SQL Where Clause WHERE Country_ID = :$FLEX$.Country_Value_Set
Value Set Name District_Value_Set
Validation Table District_Table
Value Column District_NAME
Description Column District_DESCRIPTION
Hidden ID Column District_ID
SQL Where Clause WHERE Country_ID = :$FLEX$. Country_Value_Set
AND Country_ID = :$FLEX$.State_Value_Set
"Example of $FLEX$ Syntax Used in Oracle Apps ($flex$ in oracle apps) "
Sunday, May 12, 2019
Subscribe to:
Posts (Atom)
SQL Query to find Customer, Customer Account and Customer Sites Information
/****************************************************************************** *PURPOSE: Query to Customer, Customer Account and Customer...
-
/* Supplier Detail Query */ SELECT pov.vendor_name ,pov.vendor_name_alt ,pov.segment1 vendor_number ,pov.vendor_type_looku...
-
/* Open Blanket Agreement Query*/ SELECT pha.segment1 "BLANKET AGREEMENT NUMBER" ,pha.revision_num ,pha.creation_dat...