[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
'SELECT ''ENTRY'' LOOKUP_CODE,
amount_due_original_trx FII_AR_TRAN_AMT,
ar_creation_date FII_AR_TRAN_DATE,
user_id USER_ID,
:CUST_TRX_ID FII_AR_CUST_TRX_ID,
NULL FII_AR_CASH_RECEIPT_ID
FROM fii_ar_transactions_f
WHERE customer_trx_id = :CUST_TRX_ID and
filter_date <= TRUNC(sysdate) and
class = :TRAN_CLASS
UNION ALL
SELECT ''RECEIPT'' LOOKUP_CODE,
amount_applied_trx FII_AR_TRAN_AMT,
ar_creation_date FII_AR_TRAN_DATE,
user_id USER_ID,
:CUST_TRX_ID FII_AR_CUST_TRX_ID,
CASH_RECEIPT_ID FII_AR_CASH_RECEIPT_ID
FROM fii_ar_receipts_f
WHERE applied_customer_trx_id = :CUST_TRX_ID and
filter_date <= TRUNC(sysdate) and
application_type = ''CASH''
UNION ALL
SELECT ''CREDIT'' LOOKUP_CODE,
amount_applied_trx FII_AR_TRAN_AMT,
ar_creation_date FII_AR_TRAN_DATE,
user_id USER_ID,
:CUST_TRX_ID FII_AR_CUST_TRX_ID,
NULL FII_AR_CASH_RECEIPT_ID
FROM fii_ar_receipts_f
WHERE '||l_trx_id_join||'
filter_date <= TRUNC(sysdate) and
application_type = ''CM''
UNION ALL
SELECT ''DISC'' LOOKUP_CODE,
earned_discount_amount_trx FII_AR_TRAN_AMT,
ar_creation_date FII_AR_TRAN_DATE,
user_id USER_ID,
:CUST_TRX_ID FII_AR_CUST_TRX_ID,
NULL FII_AR_CASH_RECEIPT_ID
FROM fii_ar_receipts_f
WHERE applied_customer_trx_id = :CUST_TRX_ID and
earned_discount_amount_trx is not null and
filter_date <= TRUNC(sysdate) and
application_type = ''CASH''
UNION ALL
SELECT ''ASSIGN'' LOOKUP_CODE,
amount_trx FII_AR_TRAN_AMT,
ar_creation_date FII_AR_TRAN_DATE,
user_id USER_ID,
:CUST_TRX_ID FII_AR_CUST_TRX_ID,
NULL FII_AR_CASH_RECEIPT_ID
FROM fii_ar_adjustments_f
WHERE customer_trx_id = :CUST_TRX_ID and
filter_date <= TRUNC(sysdate) and
adj_class = ''BR''
UNION ALL
';
SELECT lookup.meaning FII_AR_ACTION,
inline.FII_AR_TRAN_AMT FII_AR_TRAN_AMT,
inline.FII_AR_TRAN_DATE FII_AR_TRAN_DATE,
users.user_name FII_AR_USER,
'||l_app_rec_drill||' FII_AR_TRAN_AMT_DRILL
FROM (
'||l_trx_sql||'
SELECT ''ADJ'' LOOKUP_CODE,
amount_trx FII_AR_TRAN_AMT,
ar_creation_date FII_AR_TRAN_DATE,
user_id USER_ID,
:CUST_TRX_ID FII_AR_CUST_TRX_ID,
NULL FII_AR_CASH_RECEIPT_ID
FROM fii_ar_adjustments_f
WHERE customer_trx_id = :CUST_TRX_ID and
filter_date <= TRUNC(sysdate) and
NVL(adj_class,''XX'') <> ''BR''
) inline,
fnd_user users,
fnd_lookup_values lookup
WHERE inline.user_id = users.user_id
and lookup.lookup_type = ''FII_AR_TRX_ACTIONS''
and lookup.lookup_code = inline.lookup_code
and lookup.language = userenv(''LANG'')
&ORDER_BY_CLAUSE';