DBA Data[Home] [Help]

APPS.AHL_VWP_VISITS_PVT dependencies on BOM_DEPARTMENTS

Line 1192: BOM_DEPARTMENTS BDPT, MTL_SYSTEM_ITEMS_B_KFV MTSB,

1188: PA.NAME PROJECT_TEMPLATE_NAME ,
1189: AVTS.UNIT_SCHEDULE_ID, AVTS.ASSO_PRIMARY_VISIT_ID
1190: FROM AHL_VISITS_VL AVTS, AHL_SIMULATION_PLANS_VL ASPV,
1191: CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS HROU,
1192: BOM_DEPARTMENTS BDPT, MTL_SYSTEM_ITEMS_B_KFV MTSB,
1193: FND_LOOKUP_VALUES_VL FLVT, FND_LOOKUP_VALUES_VL FLVT1,
1194: FND_LOOKUP_VALUES_VL FLVT2, FND_LOOKUP_VALUES_VL FLVT3,
1195: PA_PROJECTS_ALL PA, AHL_UNIT_CONFIG_HEADERS UC, CS_INCIDENTS_ALL_B CSAB
1196: WHERE AVTS.ITEM_INSTANCE_ID = UC.CSI_ITEM_INSTANCE_ID(+)

Line 1243: BOM_DEPARTMENTS BDPT, MTL_SYSTEM_ITEMS_B_KFV MTSB,

1239: AVTS.INV_LOCATOR_ID -- Added by sowsubra
1240: FROM AHL_VISITS_B AVTS,AHL_VISITS_TL AVTSTL,
1241: AHL_SIMULATION_PLANS_B ASPV,AHL_SIMULATION_PLANS_TL ASPVTL,
1242: CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS_TL HROU,
1243: BOM_DEPARTMENTS BDPT, MTL_SYSTEM_ITEMS_B_KFV MTSB,
1244: FND_LOOKUP_VALUES FLVT, FND_LOOKUP_VALUES FLVT1,
1245: FND_LOOKUP_VALUES FLVT2, FND_LOOKUP_VALUES FLVT3,
1246: -- SKPATHAK :: Bug #8983097 :: 20-OCT-2009
1247: --PA_PROJECTS_ALL PA,