eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_VWP_PRICE_PVT dependencies on AHL_VISIT_TASKS_B

Line 934: AHL_VISIT_TASKS_B VT,

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
938: AND AR.visit_task_id = c_visit_task_id

Line 1056: AHL_VISIT_TASKS_B VT,

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
1060: AND V.visit_id = VT.visit_id

Line 1077: AHL_VISIT_TASKS_B VT,

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

Line 1530: AHL_VISIT_TASKS_B VT,

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
1534: AND AR.visit_task_id = c_visit_task_id

Line 1636: AHL_VISIT_TASKS_B VT,

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
1640: AND MAT.inventory_item_id = MSIV.inventory_item_id

Line 1661: AHL_VISIT_TASKS_B VT,

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
1665: AND MAT.inventory_item_id = MSIV.inventory_item_id