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 4048: 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,

4044: l_locator_id WMS_LICENSE_PLATE_NUMBERS.LOCATOR_ID%TYPE;
4045:
4046: CURSOR mol_details IS
4047: SELECT mol.inspection_status,
4048: 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,
4049: mmtt.operation_plan_id,mmtt.transaction_temp_id,mol.lpn_id,mol.inventory_item_id
4050: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt
4051: WHERE mol.line_id = mmtt.move_order_line_id(+)
4052: AND mol.line_id = p_move_order_line_id

Line 4070: 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,

4066:
4067: CURSOR lpnitem_details IS
4068: SELECT mol.inspection_status,
4069: SUM(NVL(mmtt.primary_quantity,
4070: 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,
4071: mol.lpn_id,mmtt.operation_plan_id,mmtt.transaction_temp_id,mol.lot_number,mol.revision
4072: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt
4073: WHERE mol.lpn_id = p_lpn_id
4074: AND mol.inventory_item_id = p_inventory_item_id

Line 4093: 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: ORDER BY wopi.operation_sequence DESC;
4090:
4091: CURSOR c_doc_detail IS
4092: SELECT mol.inspection_status,mmtt.operation_plan_id,
4093: 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
4094: FROM mtl_material_transactions_temp mmtt , mtl_txn_request_lines mol
4095: WHERE mmtt.transaction_temp_id = p_source_task_id
4096: AND mol.line_status <> 5 -- bug 4179991
4097: AND mmtt.move_order_line_id = mol.line_id;