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.WMS_ATF_RUNTIME_PUB_APIS dependencies on WMS_TASK_DISPATCH_GEN

Line 4088: SUM(NVL(mmtt.primary_quantity, wms_task_dispatch_gen.get_primary_quantity(mol.inventory_item_id,mol.organization_id,(mol.quantity - Nvl(mol.quantity_delivered,0)),mol.uom_code))) quantity,

4084: l_locator_id WMS_LICENSE_PLATE_NUMBERS.LOCATOR_ID%TYPE;
4085:
4086: CURSOR mol_details IS
4087: SELECT mol.inspection_status,
4088: SUM(NVL(mmtt.primary_quantity, wms_task_dispatch_gen.get_primary_quantity(mol.inventory_item_id,mol.organization_id,(mol.quantity - Nvl(mol.quantity_delivered,0)),mol.uom_code))) quantity,
4089: mmtt.operation_plan_id,mmtt.transaction_temp_id,mol.lpn_id,mol.inventory_item_id
4090: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt
4091: WHERE mol.line_id = mmtt.move_order_line_id(+)
4092: AND mol.line_id = p_move_order_line_id

Line 4110: wms_task_dispatch_gen.get_primary_quantity(mol.inventory_item_id,mol.organization_id,(mol.quantity - Nvl(mol.quantity_delivered, 0)),mol.uom_code))) quantity,

4106:
4107: CURSOR lpnitem_details IS
4108: SELECT mol.inspection_status,
4109: SUM(NVL(mmtt.primary_quantity,
4110: wms_task_dispatch_gen.get_primary_quantity(mol.inventory_item_id,mol.organization_id,(mol.quantity - Nvl(mol.quantity_delivered, 0)),mol.uom_code))) quantity,
4111: mol.lpn_id,mmtt.operation_plan_id,mmtt.transaction_temp_id,mol.lot_number,mol.revision
4112: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt
4113: WHERE mol.lpn_id = p_lpn_id
4114: AND mol.inventory_item_id = p_inventory_item_id

Line 4133: NVL(mmtt.primary_quantity, wms_task_dispatch_gen.get_primary_quantity(mol.inventory_item_id,mol.organization_id,(mol.quantity - Nvl(mol.quantity_delivered,0)),mol.uom_code)) quantity

4129: ORDER BY wopi.operation_sequence DESC;
4130:
4131: CURSOR c_doc_detail IS
4132: SELECT mol.inspection_status,mmtt.operation_plan_id,mmtt.transaction_source_type_id,
4133: NVL(mmtt.primary_quantity, wms_task_dispatch_gen.get_primary_quantity(mol.inventory_item_id,mol.organization_id,(mol.quantity - Nvl(mol.quantity_delivered,0)),mol.uom_code)) quantity
4134: FROM mtl_material_transactions_temp mmtt , mtl_txn_request_lines mol
4135: WHERE mmtt.transaction_temp_id = p_source_task_id
4136: AND mol.line_status <> 5 -- bug 4179991
4137: AND mmtt.move_order_line_id = mol.line_id;