eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_AME_CMWF_API dependencies on RA_CUSTOMER_TRX

Line 1684: ra_customer_trx rct

1680: bill_to_cust.account_number,
1681: rct.trx_number
1682: FROM hz_cust_accounts bill_to_cust,
1683: hz_parties party,
1684: ra_customer_trx rct
1685: WHERE rct.customer_trx_id = p_customer_trx_id
1686: AND rct.bill_to_customer_id = bill_to_cust.cust_account_id
1687: AND bill_to_cust.party_id = party.party_id ;
1688:

Line 1694: ra_customer_trx rct

1690: SELECT substrb(party.party_name,1,50),
1691: ship_to_cust.account_number
1692: FROM hz_cust_accounts ship_to_cust,
1693: hz_parties party,
1694: ra_customer_trx rct
1695: WHERE rct.customer_trx_id = p_customer_trx_id
1696: AND rct.ship_to_customer_id = ship_to_cust.cust_account_id
1697: AND ship_to_cust.party_id = party.party_id;
1698:

Line 1979: FROM ra_customer_trx

1975: l_currency_code wf_item_attribute_values.text_value%TYPE;
1976:
1977: CURSOR c (p_cust_trx_id NUMBER) IS
1978: SELECT invoicing_rule_id
1979: FROM ra_customer_trx
1980: WHERE customer_trx_id = p_cust_trx_id;
1981:
1982: BEGIN
1983:

Line 5375: ra.customer_trx_id,

5371: l_xla_ev_rec arp_xla_events.xla_events_type;
5372:
5373: Cursor ra_event_rows (p_customer_trx_id in number) IS
5374: SELECT ra.receivable_application_id,
5375: ra.customer_trx_id,
5376: ct.trx_number
5377: from ar_receivable_applications ra, ra_customer_trx ct
5378: where ra.posting_control_id=-3
5379: and ra.application_type = 'CM'

Line 5377: from ar_receivable_applications ra, ra_customer_trx ct

5373: Cursor ra_event_rows (p_customer_trx_id in number) IS
5374: SELECT ra.receivable_application_id,
5375: ra.customer_trx_id,
5376: ct.trx_number
5377: from ar_receivable_applications ra, ra_customer_trx ct
5378: where ra.posting_control_id=-3
5379: and ra.application_type = 'CM'
5380: and ra.customer_trx_id=p_customer_trx_id
5381: and ra.event_id is null

Line 5380: and ra.customer_trx_id=p_customer_trx_id

5376: ct.trx_number
5377: from ar_receivable_applications ra, ra_customer_trx ct
5378: where ra.posting_control_id=-3
5379: and ra.application_type = 'CM'
5380: and ra.customer_trx_id=p_customer_trx_id
5381: and ra.event_id is null
5382: and ra.customer_trx_id = ct.customer_trx_id;
5383: --End bug 11775249
5384:

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

5378: where ra.posting_control_id=-3
5379: and ra.application_type = 'CM'
5380: and ra.customer_trx_id=p_customer_trx_id
5381: and ra.event_id is null
5382: and ra.customer_trx_id = ct.customer_trx_id;
5383: --End bug 11775249
5384:
5385: BEGIN
5386:

Line 5540: FROM ra_customer_trx

5536:
5537: BEGIN
5538:
5539: SELECT trx_number INTO l_credit_memo_number
5540: FROM ra_customer_trx
5541: WHERE customer_trx_id = l_credit_memo_id;
5542:
5543: wf_engine.SetItemAttrText(p_item_type,
5544: p_item_key,

Line 5660: FROM ra_customer_trx

5656: SELECT COUNT(*)
5657: FROM ra_terms_lines
5658: WHERE term_id =
5659: (SELECT term_id
5660: FROM ra_customer_trx
5661: WHERE customer_trx_id = p_cust_trx_id);
5662:
5663: CURSOR c2 (p_cust_trx_id NUMBER) IS
5664: SELECT invoicing_rule_id

Line 5665: FROM ra_customer_trx

5661: WHERE customer_trx_id = p_cust_trx_id);
5662:
5663: CURSOR c2 (p_cust_trx_id NUMBER) IS
5664: SELECT invoicing_rule_id
5665: FROM ra_customer_trx
5666: WHERE customer_trx_id = p_cust_trx_id;
5667:
5668: BEGIN
5669:

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

5815: END CheckCreditMethods;
5816:
5817:
5818: -- This procedure is called to find the primary salesrep associated with
5819: -- the invoice. It loooks ra_customer_trx to find the information.
5820: -- Once we find the salesrep, we need to determine if salesperson is the one
5821: -- initiating the credit memo request. If so then he need not be notified
5822: -- again. Otherwise, we will notify him/her to make him/her aware of this
5823: -- credit memo.

Line 5841: FROM ra_customer_trx_all rcta, ra_salesreps_all rsa

5837: l_display_name wf_users.display_name%TYPE;
5838:
5839: CURSOR c (p_id IN NUMBER) IS
5840: SELECT rsa.person_id
5841: FROM ra_customer_trx_all rcta, ra_salesreps_all rsa
5842: WHERE rcta.primary_salesrep_id = rsa.salesrep_id
5843: AND rcta.customer_trx_id = p_id;
5844:
5845: BEGIN

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

5984: END check_first_approver;
5985:
5986:
5987: -- This subroutine determines if the credit memo created is an on account
5988: -- credit memo. It looks at the row in ra_customer_trx given the credit
5989: -- memo customer trx id. In that row if the previous customer trx id is
5990: -- empty implying that this memo was not applied against any invoice then
5991: -- we conclude that the credit memo created is an on account credit memo.
5992: --

Line 6012: FROM ra_customer_trx

6008: -- it is a on account credit memo
6009:
6010: CURSOR c (p_credit_memo_id VARCHAR2) IS
6011: SELECT customer_trx_id
6012: FROM ra_customer_trx
6013: WHERE customer_trx_id = p_credit_memo_id
6014: AND previous_customer_trx_id IS NULL;
6015:
6016: BEGIN