APPS.OE_ORDER_CACHE dependencies on HZ_CUST_ACCT_SITES_ALL

Line 761: ,HZ_CUST_ACCT_SITES_ALL ADDR

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'
765: AND INV.ADDRESS_ID = ADDR.CUST_ACCT_SITE_ID

Line 798: , HZ_CUST_ACCT_SITES_ALL ADDR

794:
795: SELECT /*MOAC_SQL_CHANGES*/ SHIP.ORGANIZATION_ID
796: INTO g_sold_to_rec.ship_to_org_id
797: FROM OE_SHIP_TO_ORGS_V SHIP
798: , HZ_CUST_ACCT_SITES_ALL ADDR
799: WHERE ADDR.CUST_ACCOUNT_ID = p_key
800: AND ADDR.SHIP_TO_FLAG = 'P'
801: AND ADDR.STATUS = 'A'
802: AND SHIP.ADDRESS_ID = ADDR.CUST_ACCT_SITE_ID

Line 835: ,HZ_CUST_ACCT_SITES_ALL ADDR

831:
832: SELECT /*MOAC_SQL_CHANGES*/ DEL.ORGANIZATION_ID
833: INTO g_sold_to_rec.deliver_to_org_id
834: FROM OE_DELIVER_TO_ORGS_V DEL
835: ,HZ_CUST_ACCT_SITES_ALL ADDR
836: WHERE ADDR.CUST_ACCOUNT_ID = p_key
837: AND ADDR.SHIP_TO_FLAG = 'P'
838: AND ADDR.STATUS = 'A'
839: AND DEL.ADDRESS_ID = ADDR.CUST_ACCT_SITE_ID