Protected by Copyscape Web Copyright Protection Software

Pages

Search This Blog

Wednesday, June 26, 2013

Can we use $FLEX$ multiple times in a single Valueset?

Yes we can use :$FLEX$ multiple times in a single valuset.

Example.
=======

WHERE a.bank_account_id IN (SELECT b.bank_account_id
                              FROM CE_BANK_ACCT_USES_ALL b
                              WHERE b.org_id= :$FLEX$.XXST_OPERATING_UNIT1
AND (NVL(AP_USE_ENABLE_FLAG,'N' ) = 'Y' OR NVL(AR_USE_ENABLE_FLAG,'N' ) = 'Y' ))
AND   c.BANK_PARTY_ID = a.BANK_ID
AND  d.branch_party_id=a.bank_branch_id
and c.bank_name=:$FLEX%.XXST_BANK_NAME
and d.bank_branch_name=:$FLEX$.XXST_BANK_BRANCH_NAME

 Write above code in where condition box.

here XXST_OPERATING_UNIT1,
       XXST_BANK_NAME,
         XXST_BANK_BRANCH_NAME are previous valuesets which are already used for a concurrent program.

While creating valueset follow the standard rules like use XX in starting of name and use meaningful name as a valueset.

No comments:

Post a Comment