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 4090: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt

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

Line 4100: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt

4096: GROUP BY mol.inspection_status,mmtt.operation_plan_id,mmtt.transaction_temp_id, mol.lpn_id, mol.inventory_item_id;
4097:
4098: CURSOR lpn_details IS
4099: SELECT mol.inspection_status,mmtt.operation_plan_id,mmtt.transaction_temp_id
4100: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt
4101: WHERE mol.line_id = mmtt.move_order_line_id(+)
4102: AND mol.lpn_id = p_lpn_id
4103: AND mol.organization_id = p_organization_id
4104: AND mol.line_status <> 5 -- bug 4179991

Line 4112: FROM mtl_txn_request_lines mol, mtl_material_transactions_temp mmtt

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

Line 4134: FROM mtl_material_transactions_temp mmtt , mtl_txn_request_lines mol

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

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

4376:
4377: print_debug('Closed the open cursors',l_module_name,9);
4378: l_progress:=140;
4379:
4380: /*Incase none of the records are fetched from MTL_txn_request_lines for an inventory LPN
4381: returning with flag as FULL LOAD */
4382:
4383: IF p_lpn_id IS NOT NULL AND l_inspection_status=-1 THEN
4384: