DBA Data[Home] [Help]

APPS.WSH_OTM_REF_DATA_GEN_PKG dependencies on FND_TERRITORIES

Line 1450: FND_TERRITORIES FNDTR,

1446: from HR_LOCATIONS_ALL HRL,
1447: HR_ALL_ORGANIZATION_UNITS ORG,
1448: --HR_ALL_ORGANIZATION_UNITS_TL ORGL,
1449: --FND_LANGUAGES FNDL,
1450: FND_TERRITORIES FNDTR,
1451: WSH_OTM_LOCATIONS_GTMP WLT, -- global temp table
1452: MTL_PARAMETERS MP,
1453: WSH_LOCATIONS WL
1454: WHERE WLT.LOCATION_ID = WL.WSH_LOCATION_ID

Line 1488: FND_TERRITORIES FNDTR,

1484: )
1485: ) LAST_UPDATE_DATE
1486: FROM HZ_LOCATIONS HZL,
1487: WSH_LOCATIONS WL,
1488: FND_TERRITORIES FNDTR,
1489: WSH_OTM_LOCATIONS_GTMP WLT,
1490: HZ_PARTIES HP,
1491: HZ_CUST_ACCOUNTS HCA
1492: WHERE HZL.LOCATION_ID = WL.SOURCE_LOCATION_ID

Line 1578: FND_TERRITORIES FNDTR,

1574: WCV.LAST_UPDATE_DATE WCV_LAST_UPD_DATE,
1575: HPS.LAST_UPDATE_DATE HPS_LAST_UPD_DATE,
1576: HP.LAST_UPDATE_DATE HP_LAST_UPD_DATE
1577: FROM HZ_LOCATIONS HZL,
1578: FND_TERRITORIES FNDTR,
1579: WSH_OTM_LOCATIONS_GTMP wlt,
1580: WSH_CARRIERS WCV,
1581: WSH_CARRIER_SITES WCS,
1582: HZ_PARTY_SITES HPS,