DBA Data[Home] [Help]

APPS.WSH_OTM_REF_DATA_GEN_PKG dependencies on FND_TERRITORIES

Line 1411: FND_TERRITORIES FNDTR,

1407: from HR_LOCATIONS_ALL HRL,
1408: HR_ALL_ORGANIZATION_UNITS ORG,
1409: --HR_ALL_ORGANIZATION_UNITS_TL ORGL,
1410: --FND_LANGUAGES FNDL,
1411: FND_TERRITORIES FNDTR,
1412: WSH_OTM_LOCATIONS_GTMP WLT, -- global temp table
1413: MTL_PARAMETERS MP,
1414: WSH_LOCATIONS WL
1415: WHERE WLT.LOCATION_ID = WL.WSH_LOCATION_ID

Line 1449: FND_TERRITORIES FNDTR,

1445: )
1446: ) LAST_UPDATE_DATE
1447: FROM HZ_LOCATIONS HZL,
1448: WSH_LOCATIONS WL,
1449: FND_TERRITORIES FNDTR,
1450: WSH_OTM_LOCATIONS_GTMP WLT,
1451: HZ_PARTIES HP,
1452: HZ_CUST_ACCOUNTS HCA
1453: WHERE HZL.LOCATION_ID = WL.SOURCE_LOCATION_ID

Line 1539: FND_TERRITORIES FNDTR,

1535: WCV.LAST_UPDATE_DATE WCV_LAST_UPD_DATE,
1536: HPS.LAST_UPDATE_DATE HPS_LAST_UPD_DATE,
1537: HP.LAST_UPDATE_DATE HP_LAST_UPD_DATE
1538: FROM HZ_LOCATIONS HZL,
1539: FND_TERRITORIES FNDTR,
1540: WSH_OTM_LOCATIONS_GTMP wlt,
1541: WSH_CARRIERS WCV,
1542: WSH_CARRIER_SITES WCS,
1543: HZ_PARTY_SITES HPS,