DBA Data[Home] [Help]

APPS.AR_REVENUE_MANAGEMENT_PVT dependencies on AR_TRX_HEADER_GT

Line 1966: ar_trx_header_gt thg,

1962: sysdate,
1963: l_user_id,
1964: thg.org_id
1965: FROM ar_trx_lines_gt tlg,
1966: ar_trx_header_gt thg,
1967: ra_cust_trx_types ctt,
1968: ar_trx_contingencies_gt tcg,
1969: ar_deferral_reasons dr,
1970: pa_implementations pa

Line 2213: FROM ar_trx_header_gt thg,

2209: sysdate,
2210: l_user_id,
2211: sysdate,
2212: thg.org_id
2213: FROM ar_trx_header_gt thg,
2214: ar_trx_lines_gt tlg,
2215: ar_trx_contingencies_gt tcg,
2216: ar_line_conts lrc
2217: WHERE tlg.request_id = p_request_id

Line 2273: FROM ar_trx_header_gt thg,

2269: sysdate,
2270: l_user_id,
2271: sysdate,
2272: thg.org_id
2273: FROM ar_trx_header_gt thg,
2274: ar_trx_lines_gt tlg,
2275: ar_line_conts lrc
2276: WHERE tlg.request_id = p_request_id
2277: AND tlg.customer_trx_id = thg.customer_trx_id

Line 2560: ar_trx_header_gt hgt,

2556: cgt.trx_contingency_id,
2557: arp_standard.fnd_message('AR_RVMG_INVALID_CONTINGENCY'),
2558: cgt.contingency_id
2559: FROM ar_trx_lines_gt lgt,
2560: ar_trx_header_gt hgt,
2561: ar_trx_contingencies_gt cgt
2562: WHERE lgt.trx_header_id = hgt.trx_header_id
2563: AND cgt.trx_line_id = lgt.trx_line_id
2564: AND NOT EXISTS

Line 2601: ar_trx_header_gt hgt,

2597: cgt.trx_contingency_id,
2598: arp_standard.fnd_message('AR_RVMG_NO_EXP_DATE'),
2599: cgt.contingency_id
2600: FROM ar_trx_lines_gt lgt,
2601: ar_trx_header_gt hgt,
2602: ar_trx_contingencies_gt cgt,
2603: ar_deferral_reasons dr
2604: WHERE lgt.trx_header_id = hgt.trx_header_id
2605: AND cgt.trx_line_id = lgt.trx_line_id

Line 5983: delete from ar_trx_header_gt;

5979: /* Bug fix 5351734
5980: Delete the data in the global temporary tables */
5981: delete from ar_rdr_parameters_gt;
5982: delete from ar_trx_errors_gt;
5983: delete from ar_trx_header_gt;
5984: delete from ar_trx_lines_gt;
5985: delete from ar_reviewed_lines_gt;
5986: delete from fun_rule_bulk_result_gt;
5987: delete from ar_trx_contingencies_gt;