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.OE_VALIDATE_HEADER dependencies on RA_CUSTOMER_TRX

Line 496: FROM ra_customer_trx

492: IF l_commitment_id IS NOT NULL THEN
493: BEGIN
494: SELECT invoice_currency_code
495: INTO l_commitment_curr_code
496: FROM ra_customer_trx
497: WHERE customer_trx_id = l_commitment_id;
498:
499: EXCEPTION WHEN NO_DATA_FOUND THEN
500: null;

Line 553: from ra_customer_trx ratrx

549: AND commitment_id is not null;
550:
551: Cursor cur_customer_relations (p_commitment_id IN NUMBER) is
552: select 'Y'
553: from ra_customer_trx ratrx
554: where ratrx.customer_trx_id = p_commitment_id
555: and ratrx.bill_to_customer_id = p_sold_to_org_id
556:
557: union all

Line 560: from ra_customer_trx ratrx

556:
557: union all
558:
559: select 'Y'
560: from ra_customer_trx ratrx
561: where ratrx.customer_trx_id = p_commitment_id
562: and exists (SELECT 1
563: FROM hz_cust_acct_relate_all hcar
564: WHERE hcar.cust_account_id = ratrx.bill_to_customer_id

Line 584: FROM ra_customer_trx ratrx

580: IF l_commitment_id IS NOT NULL THEN
581: BEGIN
582: /*SELECT MOAC_SQL_CHANGE 'Y'
583: INTO l_exists
584: FROM ra_customer_trx ratrx
585: WHERE ratrx.bill_to_customer_id
586: IN (SELECT p_sold_to_org_id
587: FROM sys.dual
588: UNION