APPS.OE_OEOL_SCH dependencies on HZ_PARTY_SITES

Line 1457: HZ_PARTY_SITES PARTY,

1453: /* MOAC_SQL_CHANGE */
1454: SELECT LOC.LOCATION_ID
1455: INTO l_deliver_to_location_id
1456: FROM HZ_LOCATIONS LOC,
1457: HZ_PARTY_SITES PARTY,
1458: HZ_CUST_ACCT_SITES ACCT,
1459: HZ_CUST_SITE_USES_ALL CUST
1460: WHERE CUST.SITE_USE_ID=L_LINE_REC.SHIP_TO_ORG_ID
1461: AND CUST.SITE_USE_CODE='SHIP_TO'