APPS.AR_UPG_PSA_DIST_PKG dependencies on AR_DISTRIBUTIONS_S

Line 99: ar_distributions_s.nextval -- LINE_ID

95: , FROM_ACCTD_AMOUNT_CR
96: , REF_MF_DIST_FLAG
97: , REF_DIST_CCID)
98: SELECT
99: ar_distributions_s.nextval -- LINE_ID
100: , ard.SOURCE_ID
101: , ard.SOURCE_TABLE
102: , ard.SOURCE_TYPE
103: , ard.CODE_COMBINATION_ID

Line 203: ar_distributions_s.nextval -- LINE_ID

199: , REF_MF_DIST_FLAG
200: , REF_DIST_CCID)
201: SELECT /*+ ordered rowid(adj) use_nl(psaadj,psatd,ctlgd,trx) INDEX(psaadj psa_mf_adj_dist_u1) INDEX(psatd psa_mf_trx_dist_u1)
202: INDEX(ctlgd ra_cust_trx_line_gl_dist_u1) */
203: ar_distributions_s.nextval -- LINE_ID
204: , psaadj.adjustment_id -- SOURCE_ID
205: , 'ADJ' -- SOURCE_TABLE
206: , CASE WHEN doub.side = 'D' THEN
207: DECODE(SIGN(psaadj.amount),

Line 411: ar_distributions_s.nextval -- LINE_ID

407: , FROM_ACCTD_AMOUNT_CR
408: , REF_MF_DIST_FLAG
409: , REF_DIST_CCID)
410: SELECT
411: ar_distributions_s.nextval -- LINE_ID
412: , ard.SOURCE_ID -- SOURCE_ID
413: , ard.source_table -- SOURCE_TABLE
414: , ard.SOURCE_TYPE -- SOURCE_TYPE
415: , DECODE(double.side,'CASH',

Line 581: ar_distributions_s.nextval -- LINE_ID

577: , REF_MF_DIST_FLAG
578: , REF_DIST_CCID)
579: SELECT /*+ ordered rowid(app) use_nl(a,psatd,ctlgd,trx,crh) INDEX(a psa_mf_rct_dist_u1) INDEX(psatd psa_mf_trx_dist_u1)
580: INDEX(ctlgd ra_cust_trx_line_gl_dist_u1) */
581: ar_distributions_s.nextval -- LINE_ID
582: , a.receivable_application_id --SOURCE_ID
583: , 'RA' -- SOURCE_TABLE
584: , b.source_type
585: , DECODE(doub.side,'D',

Line 1108: ar_distributions_s.nextval -- LINE_ID

1104: , FROM_ACCTD_AMOUNT_CR
1105: , REF_MF_DIST_FLAG
1106: , REF_DIST_CCID)
1107: SELECT /*+ ordered rowid(mcd) use_nl(psamcd,cr) INDEX(psamcd psa_mf_misc_dist_u1) */
1108: ar_distributions_s.nextval -- LINE_ID
1109: , crhard.source_id -- SOURCE_ID
1110: , 'CRH' -- SOURCE_TABLE
1111: , crhard.source_type -- SOURCE_TYPE
1112: , CASE WHEN doub.side = 'C' THEN