APPS.AHL_VWP_PRICE_PVT dependencies on MTL_SYSTEM_ITEMS_VL

Line 932: MTL_SYSTEM_ITEMS_VL MSIV,

928: AR.REQUIRED_START_DATE,
929: MSIV.concatenated_segments item_name,
930: MSIV.primary_uom_code uom_code
931: FROM AHL_PP_REQUIREMENT_V AR,
932: MTL_SYSTEM_ITEMS_VL MSIV,
933: AHL_VISITS_B V,
934: AHL_VISIT_TASKS_B VT,
935: BOM_RESOURCES BR
936: WHERE BR.resource_id=AR.resource_id

Line 1057: MTL_SYSTEM_ITEMS_VL MSIV

1053: -- MAT.uom_code
1054: FROM AHL_RT_OPER_MATERIALS MAT,
1055: AHL_VISITS_B V,
1056: AHL_VISIT_TASKS_B VT,
1057: MTL_SYSTEM_ITEMS_VL MSIV
1058: WHERE MAT.association_type_code='ROUTE'
1059: AND MSIV.organization_id = V.organization_id
1060: AND V.visit_id = VT.visit_id
1061: AND VT.visit_task_id = c_visit_task_id

Line 1075: FROM MTL_SYSTEM_ITEMS_VL MSIV,

1071: SELECT MAT.inventory_item_id,
1072: sum(NVL(MAT.quantity,0)) quantity,
1073: MSIV.primary_uom_code uom_code
1074: -- MAT.uom_code
1075: FROM MTL_SYSTEM_ITEMS_VL MSIV,
1076: AHL_VISITS_B V,
1077: AHL_VISIT_TASKS_B VT,
1078: AHL_RT_OPER_MATERIALS MAT
1079: WHERE MAT.association_type_code='OPERATION'

Line 1262: MTL_SYSTEM_ITEMS_VL MSIV,

1258: MSIV.concatenated_segments item_name,
1259: MSIV.primary_uom_code uom_code
1260: FROM AHL_RT_OPER_RESOURCES AR,
1261: BOM_RESOURCES BR,
1262: MTL_SYSTEM_ITEMS_VL MSIV,
1263: AHL_RESOURCE_MAPPINGS MAP
1264: WHERE AR.association_type_code='ROUTE'
1265: AND BR.resource_id=MAP.bom_resource_id
1266: AND AR.object_id=c_route_id

Line 1289: MTL_SYSTEM_ITEMS_VL MSIV,

1285: MSIV.concatenated_segments item_name,
1286: BR.BILLABLE_ITEM_ID
1287: FROM AHL_RT_OPER_RESOURCES AR,
1288: BOM_RESOURCES BR,
1289: MTL_SYSTEM_ITEMS_VL MSIV,
1290: AHL_RESOURCE_MAPPINGS MAP
1291: WHERE AR.association_type_code='OPERATION'
1292: AND BR.resource_id=MAP.bom_resource_id
1293: AND BR.organization_id=c_org_id

Line 1528: MTL_SYSTEM_ITEMS_VL MSIV,

1524: AR.TRANSACTION_DATE,
1525: MSIV.concatenated_segments item_name,
1526: MSIV.primary_uom_code uom_code
1527: FROM AHL_WIP_RESOURCE_TXNS_V AR,
1528: MTL_SYSTEM_ITEMS_VL MSIV,
1529: AHL_VISITS_B V,
1530: AHL_VISIT_TASKS_B VT,
1531: BOM_RESOURCES BR
1532: WHERE BR.resource_id=AR.resource_id

Line 1634: MTL_SYSTEM_ITEMS_VL MSIV,

1630: MSIV.primary_uom_code uom_code
1631: -- MAT.uom uom_code
1632: FROM AHL_WORKORDER_MTL_TXNS MAT,
1633: AHL_WORKORDERS_V AWOS,
1634: MTL_SYSTEM_ITEMS_VL MSIV,
1635: AHL_VISITS_B V,
1636: AHL_VISIT_TASKS_B VT,
1637: AHL_WORKORDER_OPERATIONS_V AWOP
1638: WHERE AWOP.WORKORDER_ID = AWOS.WORKORDER_ID