APPS.AR_AME_CMWF_API dependencies on RA_CUSTOMER_TRX

Line 1643: ra_customer_trx rct

1639: bill_to_cust.account_number,
1640: rct.trx_number
1641: FROM hz_cust_accounts bill_to_cust,
1642: hz_parties party,
1643: ra_customer_trx rct
1644: WHERE rct.customer_trx_id = p_customer_trx_id
1645: AND rct.bill_to_customer_id = bill_to_cust.cust_account_id
1646: AND bill_to_cust.party_id = party.party_id ;
1647:

Line 1653: ra_customer_trx rct

1649: SELECT substrb(party.party_name,1,50),
1650: ship_to_cust.account_number
1651: FROM hz_cust_accounts ship_to_cust,
1652: hz_parties party,
1653: ra_customer_trx rct
1654: WHERE rct.customer_trx_id = p_customer_trx_id
1655: AND rct.ship_to_customer_id = ship_to_cust.cust_account_id
1656: AND ship_to_cust.party_id = party.party_id;
1657:

Line 1938: FROM ra_customer_trx

1934: l_currency_code wf_item_attribute_values.text_value%TYPE;
1935:
1936: CURSOR c (p_cust_trx_id NUMBER) IS
1937: SELECT invoicing_rule_id
1938: FROM ra_customer_trx
1939: WHERE customer_trx_id = p_cust_trx_id;
1940:
1941: BEGIN
1942:

Line 5411: FROM ra_customer_trx

5407:
5408: BEGIN
5409:
5410: SELECT trx_number INTO l_credit_memo_number
5411: FROM ra_customer_trx
5412: WHERE customer_trx_id = l_credit_memo_id;
5413:
5414: wf_engine.SetItemAttrText(p_item_type,
5415: p_item_key,

Line 5531: FROM ra_customer_trx

5527: SELECT COUNT(*)
5528: FROM ra_terms_lines
5529: WHERE term_id =
5530: (SELECT term_id
5531: FROM ra_customer_trx
5532: WHERE customer_trx_id = p_cust_trx_id);
5533:
5534: CURSOR c2 (p_cust_trx_id NUMBER) IS
5535: SELECT invoicing_rule_id

Line 5536: FROM ra_customer_trx

5532: WHERE customer_trx_id = p_cust_trx_id);
5533:
5534: CURSOR c2 (p_cust_trx_id NUMBER) IS
5535: SELECT invoicing_rule_id
5536: FROM ra_customer_trx
5537: WHERE customer_trx_id = p_cust_trx_id;
5538:
5539: BEGIN
5540:

Line 5690: -- the invoice. It loooks ra_customer_trx to find the information.

5686: END CheckCreditMethods;
5687:
5688:
5689: -- This procedure is called to find the primary salesrep associated with
5690: -- the invoice. It loooks ra_customer_trx to find the information.
5691: -- Once we find the salesrep, we need to determine if salesperson is the one
5692: -- initiating the credit memo request. If so then he need not be notified
5693: -- again. Otherwise, we will notify him/her to make him/her aware of this
5694: -- credit memo.

Line 5712: FROM ra_customer_trx_all rcta, ra_salesreps_all rsa

5708: l_display_name wf_users.display_name%TYPE;
5709:
5710: CURSOR c (p_id IN NUMBER) IS
5711: SELECT rsa.person_id
5712: FROM ra_customer_trx_all rcta, ra_salesreps_all rsa
5713: WHERE rcta.primary_salesrep_id = rsa.salesrep_id
5714: AND rcta.customer_trx_id = p_id;
5715:
5716: BEGIN

Line 5859: -- credit memo. It looks at the row in ra_customer_trx given the credit

5855: END check_first_approver;
5856:
5857:
5858: -- This subroutine determines if the credit memo created is an on account
5859: -- credit memo. It looks at the row in ra_customer_trx given the credit
5860: -- memo customer trx id. In that row if the previous customer trx id is
5861: -- empty implying that this memo was not applied against any invoice then
5862: -- we conclude that the credit memo created is an on account credit memo.
5863: --

Line 5883: FROM ra_customer_trx

5879: -- it is a on account credit memo
5880:
5881: CURSOR c (p_credit_memo_id VARCHAR2) IS
5882: SELECT customer_trx_id
5883: FROM ra_customer_trx
5884: WHERE customer_trx_id = p_credit_memo_id
5885: AND previous_customer_trx_id IS NULL;
5886:
5887: BEGIN