DBA Data[Home] [Help]

APPS.AR_TRX_BULK_PROCESS_DIST dependencies on AR_TRX_DIST_GT

Line 120: FROM ar_trx_dist_gt d,

116: decode(l.default_ussgl_transaction_code, null,
117: h.default_ussgl_transaction_code,
118: l.default_ussgl_transaction_code )
119: )
120: FROM ar_trx_dist_gt d,
121: ar_trx_header_gt h,
122: ar_trx_lines_gt l
123: WHERE d.trx_line_id = l.trx_line_id(+)
124: and d.trx_header_id = h.trx_header_id

Line 130: UPDATE ar_trx_dist_gt

126: ar_trx_errors_gt )
127: AND d.trx_dist_id = nvl(p_trx_dist_id, trx_dist_id)
128: AND d.process_flag = 'N';
129:
130: UPDATE ar_trx_dist_gt
131: SET process_flag = 'Y'
132: WHERE trx_dist_id = nvl(p_trx_dist_id, trx_dist_id)
133: AND process_flag = 'N'
134: AND trx_header_ID NOT IN