[Home] [Help]
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
937: AND BR.BILLABLE_ITEM_ID is not null
1051: MAT.quantity,
1052: MSIV.primary_uom_code uom_code
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
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'
1080: -- AND MAT.inventory_item_id is not null
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
1533: AND BR.BILLABLE_ITEM_ID is not null
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
1639: AND AWOP.WORKORDER_OPERATION_ID = MAT.WORKORDER_OPERATION_ID
1656: MSIV.primary_uom_code uom_code
1657: FROM AHL_WORKORDER_MTL_TXNS MAT,
1658: AHL_WORKORDERS AWOS,
1659: MTL_SYSTEM_ITEMS_B MSIV,
1660: AHL_VISITS_B V,
1661: AHL_VISIT_TASKS_B VT,
1662: AHL_WORKORDER_OPERATIONS_V AWOP
1663: WHERE AWOP.WORKORDER_ID = AWOS.WORKORDER_ID
1664: AND AWOP.WORKORDER_OPERATION_ID = MAT.WORKORDER_OPERATION_ID