APPS.ARP_CMREQ_WF dependencies on RA_CUSTOMER_TRX

Line 825: ra_customer_trx rct

821: p_bill_to_customer_name, p_bill_to_customer_number,
822: p_trx_number
823: from hz_cust_accounts bill_to_cust,
824: hz_parties party,
825: ra_customer_trx rct
826: where rct.customer_trx_id = p_customer_trx_id
827: and rct.bill_to_customer_id = bill_to_cust.cust_account_id
828: and bill_to_cust.party_id = party.party_id ;
829:

Line 852: ra_customer_trx rct

848: into p_ship_to_customer_name,
849: p_ship_to_customer_number
850: from hz_cust_accounts ship_to_cust,
851: hz_parties party,
852: ra_customer_trx rct
853: where rct.customer_trx_id = p_customer_trx_id
854: and rct.ship_to_customer_id = ship_to_cust.cust_account_id
855: and ship_to_cust.party_id = party.party_id;
856:

Line 1229: FROM ra_customer_trx

1225: /* Bug 991922 : check if message body needs to say rule is required */
1226:
1227: SELECT invoicing_rule_id
1228: INTO l_invoicing_rule_id
1229: FROM ra_customer_trx
1230: WHERE customer_trx_id = l_customer_trx_id;
1231:
1232: if l_invoicing_rule_id is not NULL then
1233:

Line 4528: ra.customer_trx_id,

4524: l_xla_ev_rec arp_xla_events.xla_events_type;
4525:
4526: Cursor ra_event_rows (p_customer_trx_id in number) IS
4527: SELECT ra.receivable_application_id,
4528: ra.customer_trx_id,
4529: ct.trx_number
4530: from ar_receivable_applications ra, ra_customer_trx ct
4531: where ra.posting_control_id=-3
4532: and ra.application_type = 'CM'

Line 4530: from ar_receivable_applications ra, ra_customer_trx ct

4526: Cursor ra_event_rows (p_customer_trx_id in number) IS
4527: SELECT ra.receivable_application_id,
4528: ra.customer_trx_id,
4529: ct.trx_number
4530: from ar_receivable_applications ra, ra_customer_trx ct
4531: where ra.posting_control_id=-3
4532: and ra.application_type = 'CM'
4533: and ra.customer_trx_id=p_customer_trx_id
4534: and ra.event_id is null

Line 4533: and ra.customer_trx_id=p_customer_trx_id

4529: ct.trx_number
4530: from ar_receivable_applications ra, ra_customer_trx ct
4531: where ra.posting_control_id=-3
4532: and ra.application_type = 'CM'
4533: and ra.customer_trx_id=p_customer_trx_id
4534: and ra.event_id is null
4535: and ra.customer_trx_id = ct.customer_trx_id;
4536: --End bug 11775249
4537:

Line 4535: and ra.customer_trx_id = ct.customer_trx_id;

4531: where ra.posting_control_id=-3
4532: and ra.application_type = 'CM'
4533: and ra.customer_trx_id=p_customer_trx_id
4534: and ra.event_id is null
4535: and ra.customer_trx_id = ct.customer_trx_id;
4536: --End bug 11775249
4537:
4538: BEGIN
4539: SetOrgContext (p_item_key);

Line 4679: from ra_customer_trx

4675:
4676: begin
4677: select trx_number
4678: into l_credit_memo_number
4679: from ra_customer_trx
4680: where customer_trx_id = l_credit_memo_id;
4681:
4682: WF_ENGINE.SetItemAttrText(p_item_type,
4683: p_item_key,

Line 4814: WHERE term_id = (SELECT term_id FROM ra_customer_trx

4810: 'INVALID_RULE_MESG');
4811:
4812: SELECT COUNT(*) INTO l_count
4813: FROM ra_terms_lines
4814: WHERE term_id = (SELECT term_id FROM ra_customer_trx
4815: WHERE customer_trx_id = l_customer_trx_id);
4816:
4817:
4818: -- the l_count will always be >= 1, and the credit installment_rule is

Line 4835: FROM ra_customer_trx

4831: end if;
4832: end if;
4833:
4834: SELECT invoicing_rule_id INTO l_invoicing_rule_id
4835: FROM ra_customer_trx
4836: WHERE customer_trx_id = l_customer_trx_id;
4837:
4838: if l_invoicing_rule_id is not NULL then
4839: