DBA Data[Home] [Help]

APPS.AR_REVENUE_MANAGEMENT_PVT dependencies on AR_TRX_HEADER_GT

Line 1862: ar_trx_header_gt thg,

1858: sysdate,
1859: l_user_id,
1860: thg.org_id
1861: FROM ar_trx_lines_gt tlg,
1862: ar_trx_header_gt thg,
1863: ra_cust_trx_types ctt,
1864: ar_trx_contingencies_gt tcg,
1865: ar_deferral_reasons dr
1866: WHERE tlg.request_id = p_request_id

Line 2099: FROM ar_trx_header_gt thg,

2095: sysdate,
2096: l_user_id,
2097: sysdate,
2098: thg.org_id
2099: FROM ar_trx_header_gt thg,
2100: ar_trx_lines_gt tlg,
2101: ar_trx_contingencies_gt tcg,
2102: ar_line_conts lrc
2103: WHERE tlg.request_id = p_request_id

Line 2159: FROM ar_trx_header_gt thg,

2155: sysdate,
2156: l_user_id,
2157: sysdate,
2158: thg.org_id
2159: FROM ar_trx_header_gt thg,
2160: ar_trx_lines_gt tlg,
2161: ar_line_conts lrc
2162: WHERE tlg.request_id = p_request_id
2163: AND tlg.customer_trx_id = thg.customer_trx_id

Line 2413: ar_trx_header_gt hgt,

2409: cgt.trx_contingency_id,
2410: arp_standard.fnd_message('AR_RVMG_INVALID_CONTINGENCY'),
2411: cgt.contingency_id
2412: FROM ar_trx_lines_gt lgt,
2413: ar_trx_header_gt hgt,
2414: ar_trx_contingencies_gt cgt
2415: WHERE lgt.trx_header_id = hgt.trx_header_id
2416: AND cgt.trx_line_id = lgt.trx_line_id
2417: AND NOT EXISTS

Line 2454: ar_trx_header_gt hgt,

2450: cgt.trx_contingency_id,
2451: arp_standard.fnd_message('AR_RVMG_NO_EXP_DATE'),
2452: cgt.contingency_id
2453: FROM ar_trx_lines_gt lgt,
2454: ar_trx_header_gt hgt,
2455: ar_trx_contingencies_gt cgt,
2456: ar_deferral_reasons dr
2457: WHERE lgt.trx_header_id = hgt.trx_header_id
2458: AND cgt.trx_line_id = lgt.trx_line_id

Line 5794: delete from ar_trx_header_gt;

5790: /* Bug fix 5351734
5791: Delete the data in the global temporary tables */
5792: delete from ar_rdr_parameters_gt;
5793: delete from ar_trx_errors_gt;
5794: delete from ar_trx_header_gt;
5795: delete from ar_trx_lines_gt;
5796: delete from ar_reviewed_lines_gt;
5797: delete from fun_rule_bulk_result_gt;
5798: delete from ar_trx_contingencies_gt;