DBA Data[Home] [Help]

APPS.AHL_VWP_PRICE_PVT dependencies on AHL_WORKORDER_MTL_TXNS

Line 1632: FROM AHL_WORKORDER_MTL_TXNS MAT,

1628: MAT.creation_date,
1629: SUM(NVL(MAT.quantity,0)) quantity,
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,

Line 1657: FROM AHL_WORKORDER_MTL_TXNS MAT,

1653: SELECT MAT.inventory_item_id,
1654: MAT.creation_date,
1655: SUM(NVL(MAT.quantity,0)) quantity,
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,