[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
P.BASE_CURRENCY_CODE,
C.PRECISION,
C.MINIMUM_ACCOUNTABLE_UNIT,
C.DESCRIPTION
INTO BASE_CURR,PREC,MIN_AU,DESCR
FROM
AP_SYSTEM_PARAMETERS P,
FND_CURRENCIES_VL C
WHERE P.BASE_CURRENCY_CODE = C.CURRENCY_CODE;
SELECT
LY.MEANING,
LN.MEANING,
LA.DISPLAYED_FIELD,
LNEP.DISPLAYED_FIELD
INTO NLS_YES,NLS_NO,NLS_ALL,NLS_NONE_EP
FROM
FND_LOOKUPS LY,
FND_LOOKUPS LN,
AP_LOOKUP_CODES LA,
AP_LOOKUP_CODES LNEP
WHERE LY.LOOKUP_TYPE = 'YES_NO'
AND LY.LOOKUP_CODE = 'Y'
AND LN.LOOKUP_TYPE = 'YES_NO'
AND LN.LOOKUP_CODE = 'N'
AND LA.LOOKUP_TYPE = 'NLS REPORT PARAMETER'
AND LA.LOOKUP_CODE = 'ALL'
AND LNEP.LOOKUP_TYPE = 'NLS TRANSLATION'
AND LNEP.LOOKUP_CODE = 'NONE ELECTRONIC PAYMENT';
SELECT
ALC1.DISPLAYED_FIELD,
ALC2.DISPLAYED_FIELD,
ALC3.DISPLAYED_FIELD,
ALC4.DISPLAYED_FIELD,
ALC5.DISPLAYED_FIELD,
ALC6.DISPLAYED_FIELD
INTO NLS_AMOUNT_DIFFERENCE,NLS_CLEARED_BEFORE_ISSUED,NLS_VOIDED_AND_CLEARED,NLS_PAYMENT_NOT_CLEARED,NLS_CLEAR_DATE_NULL,NLS_CLEAR_AMOUNT_NULL
FROM
AP_LOOKUP_CODES ALC1,
AP_LOOKUP_CODES ALC2,
AP_LOOKUP_CODES ALC3,
AP_LOOKUP_CODES ALC4,
AP_LOOKUP_CODES ALC5,
AP_LOOKUP_CODES ALC6
WHERE ALC1.LOOKUP_TYPE = 'PAYMENT EXCEPTIONS'
AND ALC2.LOOKUP_TYPE = 'PAYMENT EXCEPTIONS'
AND ALC3.LOOKUP_TYPE = 'PAYMENT EXCEPTIONS'
AND ALC4.LOOKUP_TYPE = 'PAYMENT EXCEPTIONS'
AND ALC5.LOOKUP_TYPE = 'PAYMENT EXCEPTIONS'
AND ALC6.LOOKUP_TYPE = 'PAYMENT EXCEPTIONS'
AND ALC1.LOOKUP_CODE = 'AMOUNT DIFFERENCE'
AND ALC2.LOOKUP_CODE = 'CLEARED BEFORE ISSUED'
AND ALC3.LOOKUP_CODE = 'VOIDED AND CLEARED'
AND ALC4.LOOKUP_CODE = 'PAYMENT NOT CLEARED'
AND ALC5.LOOKUP_CODE = 'CLEAR DATE NULL'
AND ALC6.LOOKUP_CODE = 'CLEAR AMOUNT NULL';
SELECT
NAME,
CHART_OF_ACCOUNTS_ID
INTO L_NAME,L_CHART_OF_ACCOUNTS_ID
FROM
GL_SETS_OF_BOOKS
WHERE SET_OF_BOOKS_ID = L_SOB_ID;
SELECT
SUBSTR(NAME
,1
,25)
INTO L_CURRENCY_DESC
FROM
FND_CURRENCIES_VL
WHERE CURRENCY_CODE = C_CURRENCY_CODE;