DBA Data[Home] [Help]

APPS.JE_IT_INVOICES_ABOVE_THRESHOLD dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 1110: ra_cust_trx_line_gl_dist_all rctd,

1106: g_creation_date,
1107: g_created_by
1108: FROM ra_customer_trx_all rct,
1109: ra_customer_trx_lines_all rctl,
1110: ra_cust_trx_line_gl_dist_all rctd,
1111: ra_cust_trx_types_all rctt,
1112: ar_receipt_methods arm,
1113: hz_cust_accounts hca,
1114: hz_parties hp,

Line 1244: ra_cust_trx_line_gl_dist_all rctd,

1240: g_creation_date,
1241: g_created_by
1242: FROM ra_customer_trx_all rct,
1243: ra_customer_trx_lines_all rctl,
1244: ra_cust_trx_line_gl_dist_all rctd,
1245: ra_cust_trx_types_all rctt,
1246: ar_receipt_methods arm,
1247: hz_cust_accounts hca,
1248: hz_parties hp,

Line 1433: FROM ra_cust_trx_line_gl_dist_all dist

1429: BEGIN
1430:
1431: UPDATE je_it_trx_lines_all trx_lines
1432: SET trx_lines.trx_gl_date = (SELECT gl_date
1433: FROM ra_cust_trx_line_gl_dist_all dist
1434: WHERE dist.customer_trx_id = trx_lines.trx_id
1435: AND dist.account_class = 'REC'
1436: AND dist.latest_rec_flag = 'Y')
1437: WHERE trx_lines.application_id = 222