DBA Data[Home] [Help]

APPS.OE_OEOL_SCH dependencies on HZ_LOCATIONS

Line 1456: FROM HZ_LOCATIONS LOC,

1452: BEGIN
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