APPS.AHL_VWP_TASKS_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 530: MTL_SYSTEM_ITEMS_B_KFV MTSB,

526: FND_LOOKUP_VALUES LKUP2,
527: FND_LOOKUP_VALUES LKUP3,
528: FND_LOOKUP_VALUES LKUP4,
529: AHL_VWP_STAGES_VL ASTG,
530: MTL_SYSTEM_ITEMS_B_KFV MTSB,
531: AHL_ROUTES_B ARV,
532: AHL_WORKORDERS AWO
533: WHERE ATSK.INSTANCE_ID = CSIS.INSTANCE_ID (+)
534: AND ATSK.ORIGINATING_TASK_ID = ORIGTSK.VISIT_TASK_ID(+)

Line 627: MTL_SYSTEM_ITEMS_B_KFV MTSB,

623: BOM_DEPARTMENTS BDPT,
624: FND_LOOKUP_VALUES LKUP1,
625: FND_LOOKUP_VALUES LKUP2,
626: FND_LOOKUP_VALUES LKUP3,
627: MTL_SYSTEM_ITEMS_B_KFV MTSB,
628: AHL_WORKORDERS AWO
629: WHERE ATSK.INSTANCE_ID = CSIS.INSTANCE_ID (+)
630: AND ATSK.ORIGINATING_TASK_ID = ORIGTSK.VISIT_TASK_ID(+)
631: AND ATSK.SERVICE_REQUEST_ID = SR.INCIDENT_ID(+)

Line 714: MTL_SYSTEM_ITEMS_B_KFV MTSB,

710: BOM_DEPARTMENTS BDPT,
711: FND_LOOKUP_VALUES_VL LKUP1,
712: FND_LOOKUP_VALUES_VL LKUP2,
713: FND_LOOKUP_VALUES_VL LKUP3,
714: MTL_SYSTEM_ITEMS_B_KFV MTSB,
715: AHL_WORKORDERS AWO
716: WHERE ATSK.INSTANCE_ID = CSIS.INSTANCE_ID (+)
717: AND ATSK.ORIGINATING_TASK_ID = ORIGTSK.VISIT_TASK_ID(+)
718: AND ATSK.SERVICE_REQUEST_ID = SR.INCIDENT_ID(+)

Line 7328: FROM mtl_system_items_b mtl, csi_item_instances csi

7324: -- Added by rnahata for Issue 105
7325: -- To fetch if the instance is serial controlled/non-serial controlled.
7326: CURSOR c_check_inst_nonserial(c_instance_id IN NUMBER) IS
7327: SELECT 'X'
7328: FROM mtl_system_items_b mtl, csi_item_instances csi
7329: WHERE csi.instance_id = c_instance_id
7330: AND csi.inventory_item_id = mtl.inventory_item_id
7331: AND NVL(csi.inv_organization_id, csi.inv_master_organization_id) = mtl.organization_id
7332: AND mtl.serial_number_control_code = 1;