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_ORDER_CACHE dependencies on OE_INVOICE_TO_ORGS_V

Line 439: FROM OE_INVOICE_TO_ORGS_V

435: BEGIN
436:
437: SELECT ORGANIZATION_ID
438: INTO g_ship_to_rec.invoice_to_org_id
439: FROM OE_INVOICE_TO_ORGS_V
440: WHERE SITE_USE_ID = l_bill_to_site_use_id;
441:
442: EXCEPTION
443:

Line 566: FROM OE_INVOICE_TO_ORGS_V

562: , g_invoice_to_rec.status
563: , g_invoice_to_rec.address_status
564: , g_invoice_to_rec.start_date_active
565: , g_invoice_to_rec.end_date_active
566: FROM OE_INVOICE_TO_ORGS_V
567: WHERE ORGANIZATION_ID = p_key;
568:
569: -- Fetch payment term
570:

Line 679: FROM OE_INVOICE_TO_ORGS_V

675: IF l_bill_to_site_use_id IS NOT NULL THEN
676:
677: SELECT ORGANIZATION_ID
678: INTO g_deliver_to_rec.invoice_to_org_id
679: FROM OE_INVOICE_TO_ORGS_V
680: WHERE SITE_USE_ID = l_bill_to_site_use_id;
681:
682: END IF;
683:

Line 760: FROM OE_INVOICE_TO_ORGS_V INV

756: BEGIN
757:
758: SELECT /*MOAC_SQL_CHANGES*/ INV.ORGANIZATION_ID
759: INTO g_sold_to_rec.invoice_to_org_id
760: FROM OE_INVOICE_TO_ORGS_V INV
761: ,HZ_CUST_ACCT_SITES_ALL ADDR
762: WHERE ADDR.CUST_ACCOUNT_ID = p_key
763: AND ADDR.BILL_TO_FLAG = 'P'
764: AND ADDR.STATUS = 'A'