DBA Data[Home] [Help]

APPS.AHL_VWP_VISITS_PVT dependencies on BOM_DEPARTMENTS

Line 1009: BOM_DEPARTMENTS BDPT, MTL_SYSTEM_ITEMS_B_KFV MTSB,

1005: PA.NAME PROJECT_TEMPLATE_NAME ,
1006: AVTS.UNIT_SCHEDULE_ID, AVTS.ASSO_PRIMARY_VISIT_ID
1007: FROM AHL_VISITS_VL AVTS, AHL_SIMULATION_PLANS_VL ASPV,
1008: CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS HROU,
1009: BOM_DEPARTMENTS BDPT, MTL_SYSTEM_ITEMS_B_KFV MTSB,
1010: FND_LOOKUP_VALUES_VL FLVT, FND_LOOKUP_VALUES_VL FLVT1,
1011: FND_LOOKUP_VALUES_VL FLVT2, FND_LOOKUP_VALUES_VL FLVT3,
1012: PA_PROJECTS_ALL PA, AHL_UNIT_CONFIG_HEADERS UC, CS_INCIDENTS_ALL_B CSAB
1013: WHERE AVTS.ITEM_INSTANCE_ID = UC.CSI_ITEM_INSTANCE_ID(+)

Line 1057: BOM_DEPARTMENTS BDPT, MTL_SYSTEM_ITEMS_B_KFV MTSB,

1053: AVTS.INV_LOCATOR_ID -- Added by sowsubra
1054: FROM AHL_VISITS_B AVTS,AHL_VISITS_TL AVTSTL,
1055: AHL_SIMULATION_PLANS_B ASPV,AHL_SIMULATION_PLANS_TL ASPVTL,
1056: CSI_ITEM_INSTANCES CSIS, HR_ALL_ORGANIZATION_UNITS_TL HROU,
1057: BOM_DEPARTMENTS BDPT, MTL_SYSTEM_ITEMS_B_KFV MTSB,
1058: FND_LOOKUP_VALUES FLVT, FND_LOOKUP_VALUES FLVT1,
1059: FND_LOOKUP_VALUES FLVT2, FND_LOOKUP_VALUES FLVT3,
1060: PA_PROJECTS_ALL PA,
1061: AHL_UNIT_CONFIG_HEADERS UC, CS_INCIDENTS_ALL_B CSAB