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_PRD_MRSHL_PVT dependencies on AHL_PP_MATERIALS_PVT

Line 128: nvl(ahl_pp_materials_pvt.get_issued_qty(msik.organization_id, asml.inventory_item_id, asml.workorder_operation_id), 0) issued_quantity,

124: ASML.operation_sequence, MSIK.concatenated_segments ,
125: MSIK.description, MSIK.primary_uom_code,MSIK.primary_unit_of_measure,
126: WIRO.REQUIRED_QUANTITY , WIRO.DATE_REQUIRED,
127: asml.scheduled_quantity ,asml.scheduled_date ,
128: nvl(ahl_pp_materials_pvt.get_issued_qty(msik.organization_id, asml.inventory_item_id, asml.workorder_operation_id), 0) issued_quantity,
129: asml.inventory_item_id,
130: ASML.organization_id,
131: AWOS.wip_entity_id,
132: AWOS.visit_id,

Line 208: nvl(ahl_pp_materials_pvt.get_issued_qty(msik.organization_id, asml.inventory_item_id, asml.workorder_operation_id), 0) issued_quantity,

204: ASML.operation_sequence, MSIK.concatenated_segments ,
205: MSIK.description, MSIK.primary_uom_code,MSIK.primary_unit_of_measure,
206: WIRO.REQUIRED_QUANTITY , WIRO.DATE_REQUIRED,
207: asml.scheduled_quantity ,asml.scheduled_date ,
208: nvl(ahl_pp_materials_pvt.get_issued_qty(msik.organization_id, asml.inventory_item_id, asml.workorder_operation_id), 0) issued_quantity,
209: asml.inventory_item_id,
210: ASML.organization_id,
211: AWOS.wip_entity_id,
212: AWOS.visit_id,

Line 556: nvl(ahl_pp_materials_pvt.get_issued_qty(msik.organization_id, asml.inventory_item_id, asml.workorder_operation_id), 0) issued_quantity,

552: ASML.operation_sequence, MSIK.concatenated_segments ,
553: MSIK.description, MSIK.primary_uom_code,MSIK.primary_unit_of_measure,
554: WIRO.REQUIRED_QUANTITY , WIRO.DATE_REQUIRED,
555: asml.scheduled_quantity ,asml.scheduled_date ,
556: nvl(ahl_pp_materials_pvt.get_issued_qty(msik.organization_id, asml.inventory_item_id, asml.workorder_operation_id), 0) issued_quantity,
557: asml.inventory_item_id,
558: ASML.organization_id,
559: ASML.scheduled_material_id,
560: AWOS.wip_entity_id,

Line 633: nvl(ahl_pp_materials_pvt.get_issued_qty(msik.organization_id, asml.inventory_item_id, asml.workorder_operation_id), 0) issued_quantity,

629: ASML.operation_sequence, MSIK.concatenated_segments ,
630: MSIK.description, MSIK.primary_uom_code,MSIK.primary_unit_of_measure,
631: WIRO.REQUIRED_QUANTITY , WIRO.DATE_REQUIRED,
632: asml.scheduled_quantity ,asml.scheduled_date ,
633: nvl(ahl_pp_materials_pvt.get_issued_qty(msik.organization_id, asml.inventory_item_id, asml.workorder_operation_id), 0) issued_quantity,
634: asml.inventory_item_id,
635: ASML.organization_id,
636: ASML.scheduled_material_id,
637: AWOS.wip_entity_id,

Line 1116: SELECT SUM( nvl(ahl_pp_materials_pvt.get_issued_qty(msik.organization_id, asml.inventory_item_id, asml.workorder_operation_id), 0)) issued_qty

1112: AND WO.visit_id = VTS.visit_id
1113: AND WO.visit_task_id = VTS.visit_task_id);
1114:
1115: CURSOR get_inst_issued_qty(p_visit_id NUMBER,p_item_instance_id NUMBER) IS
1116: SELECT SUM( nvl(ahl_pp_materials_pvt.get_issued_qty(msik.organization_id, asml.inventory_item_id, asml.workorder_operation_id), 0)) issued_qty
1117: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK
1118: WHERE AWOS.visit_task_id = ASML.visit_task_id
1119: and ASML.inventory_item_id = MSIK.inventory_item_id
1120: and ASML.organization_id = MSIK.organization_id

Line 1132: SELECT SUM( nvl(ahl_pp_materials_pvt.get_issued_qty(msik.organization_id, asml.inventory_item_id, asml.workorder_operation_id), 0)) issued_qty

1128: AND WO.visit_task_id = VTS.visit_task_id
1129: AND VTS.instance_id = p_item_instance_id);
1130:
1131: CURSOR get_cumm_inst_issued_qty(p_visit_id NUMBER,p_item_instance_id NUMBER)IS
1132: SELECT SUM( nvl(ahl_pp_materials_pvt.get_issued_qty(msik.organization_id, asml.inventory_item_id, asml.workorder_operation_id), 0)) issued_qty
1133: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK
1134: WHERE AWOS.visit_task_id = ASML.visit_task_id
1135: and ASML.inventory_item_id = MSIK.inventory_item_id
1136: and ASML.organization_id = MSIK.organization_id

Line 1164: SELECT SUM( nvl(ahl_pp_materials_pvt.get_issued_qty(msik.organization_id, asml.inventory_item_id, asml.workorder_operation_id), 0)) issued_qty

1160: AND TRUNC(NVL(ACTIVE_END_DATE, SYSDATE+1)) > TRUNC(SYSDATE)
1161: ));
1162:
1163: CURSOR get_visit_issued_qty(p_visit_id NUMBER) IS
1164: SELECT SUM( nvl(ahl_pp_materials_pvt.get_issued_qty(msik.organization_id, asml.inventory_item_id, asml.workorder_operation_id), 0)) issued_qty
1165: from ahl_workorders AWOS, ahl_schedule_materials ASML, WIP_REQUIREMENT_OPERATIONS WIRO, mtl_system_items_kfv MSIK
1166: WHERE AWOS.visit_task_id = ASML.visit_task_id
1167: and ASML.inventory_item_id = MSIK.inventory_item_id
1168: and ASML.organization_id = MSIK.organization_id

Line 1182: SUM( nvl(ahl_pp_materials_pvt.get_issued_qty(msik.organization_id, asml.inventory_item_id, asml.workorder_operation_id), 0)) issued_qty,

1178: CURSOR get_inst_avail_qty(p_visit_id NUMBER,p_item_instance_id NUMBER,
1179: p_subinventory_code VARCHAR2,
1180: p_locator_id NUMBER) IS
1181: SELECT SUM(WIRO.REQUIRED_QUANTITY) REQUIRED_QUANTITY,
1182: SUM( nvl(ahl_pp_materials_pvt.get_issued_qty(msik.organization_id, asml.inventory_item_id, asml.workorder_operation_id), 0)) issued_qty,
1183: SUM(GET_ONHAND_AVAILABLE(
1184: ASML.organization_id,
1185: ASML.inventory_item_id,
1186: p_subinventory_code,

Line 1207: SUM( nvl(ahl_pp_materials_pvt.get_issued_qty(msik.organization_id, asml.inventory_item_id, asml.workorder_operation_id), 0)) issued_qty,

1203: CURSOR get_cumm_inst_avail_qty(p_visit_id NUMBER,p_item_instance_id NUMBER,
1204: p_subinventory_code VARCHAR2,
1205: p_locator_id NUMBER)IS
1206: SELECT SUM(WIRO.REQUIRED_QUANTITY) REQUIRED_QUANTITY,
1207: SUM( nvl(ahl_pp_materials_pvt.get_issued_qty(msik.organization_id, asml.inventory_item_id, asml.workorder_operation_id), 0)) issued_qty,
1208: SUM(GET_ONHAND_AVAILABLE(
1209: ASML.organization_id,
1210: ASML.inventory_item_id,
1211: p_subinventory_code,

Line 1248: SUM( nvl(ahl_pp_materials_pvt.get_issued_qty(msik.organization_id, asml.inventory_item_id, asml.workorder_operation_id), 0)) issued_qty,

1244: CURSOR get_visit_avail_qty(p_visit_id NUMBER,
1245: p_subinventory_code VARCHAR2,
1246: p_locator_id NUMBER) IS
1247: SELECT SUM(WIRO.REQUIRED_QUANTITY) REQUIRED_QUANTITY,
1248: SUM( nvl(ahl_pp_materials_pvt.get_issued_qty(msik.organization_id, asml.inventory_item_id, asml.workorder_operation_id), 0)) issued_qty,
1249: SUM(GET_ONHAND_AVAILABLE(
1250: ASML.organization_id,
1251: ASML.inventory_item_id,
1252: p_subinventory_code,