APPS.ARP_CMREQ_WF dependencies on RA_CUSTOMER_TRX

Line 784: ra_customer_trx rct

780: p_bill_to_customer_name, p_bill_to_customer_number,
781: p_trx_number
782: from hz_cust_accounts bill_to_cust,
783: hz_parties party,
784: ra_customer_trx rct
785: where rct.customer_trx_id = p_customer_trx_id
786: and rct.bill_to_customer_id = bill_to_cust.cust_account_id
787: and bill_to_cust.party_id = party.party_id ;
788:

Line 811: ra_customer_trx rct

807: into p_ship_to_customer_name,
808: p_ship_to_customer_number
809: from hz_cust_accounts ship_to_cust,
810: hz_parties party,
811: ra_customer_trx rct
812: where rct.customer_trx_id = p_customer_trx_id
813: and rct.ship_to_customer_id = ship_to_cust.cust_account_id
814: and ship_to_cust.party_id = party.party_id;
815:

Line 1188: FROM ra_customer_trx

1184: /* Bug 991922 : check if message body needs to say rule is required */
1185:
1186: SELECT invoicing_rule_id
1187: INTO l_invoicing_rule_id
1188: FROM ra_customer_trx
1189: WHERE customer_trx_id = l_customer_trx_id;
1190:
1191: if l_invoicing_rule_id is not NULL then
1192:

Line 4543: from ra_customer_trx

4539:
4540: begin
4541: select trx_number
4542: into l_credit_memo_number
4543: from ra_customer_trx
4544: where customer_trx_id = l_credit_memo_id;
4545:
4546: WF_ENGINE.SetItemAttrText(p_item_type,
4547: p_item_key,

Line 4678: WHERE term_id = (SELECT term_id FROM ra_customer_trx

4674: 'INVALID_RULE_MESG');
4675:
4676: SELECT COUNT(*) INTO l_count
4677: FROM ra_terms_lines
4678: WHERE term_id = (SELECT term_id FROM ra_customer_trx
4679: WHERE customer_trx_id = l_customer_trx_id);
4680:
4681:
4682: -- the l_count will always be >= 1, and the credit installment_rule is

Line 4699: FROM ra_customer_trx

4695: end if;
4696: end if;
4697:
4698: SELECT invoicing_rule_id INTO l_invoicing_rule_id
4699: FROM ra_customer_trx
4700: WHERE customer_trx_id = l_customer_trx_id;
4701:
4702: if l_invoicing_rule_id is not NULL then
4703: