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 120: nvl(ahl_pp_materials_pvt.get_issued_qty(msik.organization_id, asml.inventory_item_id, asml.workorder_operation_id), 0) issued_quantity,

116: SELECT ASML.scheduled_material_id,AWOS.workorder_id,AWOS.job_number,AWOS.job_status_code,AWOS.job_status_meaning,ASML.operation_sequence, MSIK.concatenated_segments ,
117: MSIK.description, MSIK.primary_uom_code,MSIK.primary_unit_of_measure,
118: WIRO.REQUIRED_QUANTITY , WIRO.DATE_REQUIRED,
119: asml.scheduled_quantity ,asml.scheduled_date ,
120: nvl(ahl_pp_materials_pvt.get_issued_qty(msik.organization_id, asml.inventory_item_id, asml.workorder_operation_id), 0) issued_quantity,
121: asml.inventory_item_id,
122: ASML.organization_id,
123: AWOS.wip_entity_id,
124: AWOS.visit_id,

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

185: SELECT ASML.scheduled_material_id,AWOS.workorder_id,AWOS.job_number,AWOS.job_status_code,AWOS.job_status_meaning,ASML.operation_sequence, MSIK.concatenated_segments ,
186: MSIK.description, MSIK.primary_uom_code,MSIK.primary_unit_of_measure,
187: WIRO.REQUIRED_QUANTITY , WIRO.DATE_REQUIRED,
188: asml.scheduled_quantity ,asml.scheduled_date ,
189: nvl(ahl_pp_materials_pvt.get_issued_qty(msik.organization_id, asml.inventory_item_id, asml.workorder_operation_id), 0) issued_quantity,
190: asml.inventory_item_id,
191: ASML.organization_id,
192: AWOS.wip_entity_id,
193: 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: SELECT AWOS.workorder_id,AWOS.job_number,AWOS.job_status_code,AWOS.job_status_meaning,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 622: nvl(ahl_pp_materials_pvt.get_issued_qty(msik.organization_id, asml.inventory_item_id, asml.workorder_operation_id), 0) issued_quantity,

618: SELECT * FROM(SELECT AWOS.workorder_id,AWOS.job_number,AWOS.job_status_code,AWOS.job_status_meaning,ASML.operation_sequence, MSIK.concatenated_segments ,
619: MSIK.description, MSIK.primary_uom_code,MSIK.primary_unit_of_measure,
620: WIRO.REQUIRED_QUANTITY , WIRO.DATE_REQUIRED,
621: asml.scheduled_quantity ,asml.scheduled_date ,
622: nvl(ahl_pp_materials_pvt.get_issued_qty(msik.organization_id, asml.inventory_item_id, asml.workorder_operation_id), 0) issued_quantity,
623: asml.inventory_item_id,
624: ASML.organization_id,
625: ASML.scheduled_material_id,
626: AWOS.wip_entity_id,

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

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

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

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

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

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

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

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

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

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

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

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