DBA Data[Home] [Help]

APPS.AHL_VWP_PRICE_PVT dependencies on AHL_RT_OPER_MATERIALS

Line 1054: FROM AHL_RT_OPER_MATERIALS MAT,

1050: MAT.inventory_item_id,
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'

Line 1078: AHL_RT_OPER_MATERIALS MAT

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
1081: AND MSIV.organization_id = V.organization_id
1082: AND V.visit_id = VT.visit_id