APPS.WMS_ATF_RUNTIME_PUB_APIS dependencies on MTL_TXN_REQUEST_LINES

Line 813: mtl_txn_request_lines mol,

809: CURSOR c_mmtt_data IS
810: SELECT mol.project_id, mol.task_id,mmtt.organization_id, mmtt.operation_plan_id, mmtt.lpn_id,
811: Nvl(wopb.crossdock_to_wip_flag, 'N') crossdock_to_wip_flag
812: FROM mtl_material_transactions_temp mmtt,
813: mtl_txn_request_lines mol,
814: wms_op_plans_b wopb
815: WHERE mmtt.move_order_line_id = mol.line_id
816: AND mmtt.operation_plan_id = wopb.operation_plan_id
817: AND mmtt.transaction_temp_id = p_source_task_id;

Line 1144: FROM mtl_txn_request_lines

1140: --}}
1141:
1142: SELECT COUNT(line_id)
1143: INTO l_mol_count
1144: FROM mtl_txn_request_lines
1145: WHERE lpn_id = l_mmtt_data_rec.lpn_id;
1146:
1147: IF (l_debug = 1) THEN
1148: print_debug('l_mol_count = '||l_mol_count, l_module_name , 4);

Line 4050: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt

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
4053: AND mol.organization_id = p_organization_id
4054: AND mol.organization_id = mmtt.organization_id(+)

Line 4060: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt

4056: GROUP BY mol.inspection_status,mmtt.operation_plan_id,mmtt.transaction_temp_id, mol.lpn_id, mol.inventory_item_id;
4057:
4058: CURSOR lpn_details IS
4059: SELECT mol.inspection_status,mmtt.operation_plan_id,mmtt.transaction_temp_id
4060: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt
4061: WHERE mol.line_id = mmtt.move_order_line_id(+)
4062: AND mol.lpn_id = p_lpn_id
4063: AND mol.organization_id = p_organization_id
4064: AND mol.line_status <> 5 -- bug 4179991

Line 4072: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt

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
4075: AND mol.line_id = mmtt.move_order_line_id(+)
4076: AND mol.organization_id = p_organization_id

Line 4094: FROM mtl_material_transactions_temp mmtt , mtl_txn_request_lines mol

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;
4098:

Line 4337: /*Incase none of the records are fetched from MTL_txn_request_lines for an inventory LPN

4333:
4334: print_debug('Closed the open cursors',l_module_name,9);
4335: l_progress:=140;
4336:
4337: /*Incase none of the records are fetched from MTL_txn_request_lines for an inventory LPN
4338: returning with flag as FULL LOAD */
4339:
4340: IF p_lpn_id IS NOT NULL AND l_inspection_status=-1 THEN
4341: