APPS.AHL_VWP_VISITS_PVT dependencies on MTL_SYSTEM_ITEMS

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

Line 1433: -- Changed cursor to not use ahl_mtl_items_ou_v and replaced with mtl_system_items_kfv

1429: CURSOR c_visit_number IS
1430: SELECT MAX(visit_number) FROM Ahl_Visits_B;
1431:
1432: -- Fix for ADS bug# 4357001.
1433: -- Changed cursor to not use ahl_mtl_items_ou_v and replaced with mtl_system_items_kfv
1434: -- and added OU stripping so that Master Org does not belong to the current user's OU.
1435: CURSOR c_unit_det (p_unit_name IN VARCHAR2) IS
1436: /* SELECT uc.name ,
1437: csis.serial_number ,

Line 1459: FROM mtl_system_items_kfv mtl,

1455: csis.instance_id,
1456: mtl.inventory_item_id ,
1457: --mtl.inventory_org_id
1458: csis.inv_master_organization_id
1459: FROM mtl_system_items_kfv mtl,
1460: ahl_unit_config_headers uc,
1461: csi_item_instances csis
1462: WHERE uc.name = p_unit_name
1463: AND uc.csi_item_instance_id=csis.instance_id

Line 1482: FROM mtl_system_items mtl,

1478: csis.serial_number ,
1479: csis.instance_id,
1480: mtl.inventory_item_id ,
1481: csis.inv_master_organization_id
1482: FROM mtl_system_items mtl,
1483: ahl_unit_config_headers uc,
1484: csi_item_instances csis
1485: WHERE uc.name = p_unit_name
1486: AND uc.csi_item_instance_id=csis.instance_id