[Home] [Help]
357: , RTI.WIP_OPERATION_SEQ_NUM
358: , rti.DEPARTMENT_CODE
359: , rti.BOM_RESOURCE_ID
360: FROM rcv_transactions_interface rti
361: , wms_lpn_contents wlc
362: , po_lines_all pol
363: , po_headers_all pha
364: , rcv_shipment_headers rsh
365: , po_line_locations_all pll
439: , RTI.WIP_OPERATION_SEQ_NUM
440: , rti.DEPARTMENT_CODE
441: , rti.BOM_RESOURCE_ID
442: FROM rcv_transactions_interface rti
443: , wms_lpn_contents wlc
444: , po_lines_all pol
445: , po_headers_all pha
446: , rcv_shipment_headers rsh
447: , po_line_locations_all pll
1280:
1281:
1282: -- Bug Fix for bug 2251686
1283: -- If content lpn_id in MMTT is populated, we have to get the
1284: -- material info from WMS_LPN_CONTENTS
1285: -- New Union to this table has been added
1286: CURSOR mmtt_material_cur IS
1287: SELECT mmtt.inventory_item_id inventory_item_id
1288: , mmtt.organization_id organization_id
1320: , mmtt.locator_id
1321: , mmtt.transfer_to_location
1322: , wlc.secondary_uom_code -- added for invconv
1323: , wlc.secondary_quantity -- added for invconv
1324: FROM wms_lpn_contents wlc, mtl_material_transactions_temp mmtt
1325: WHERE mmtt.transaction_temp_id = p_transaction_id
1326: AND mmtt.content_lpn_id IS NOT NULL
1327: AND mmtt.content_lpn_id = wlc.parent_lpn_id;
1328:
1416: , mmtt.locator_id
1417: , mmtt.transfer_to_location
1418: , wlc.secondary_quantity -- added for invconv
1419: , wlc.secondary_uom_code -- added for invconv
1420: FROM wms_lpn_contents wlc, mtl_material_transactions_temp mmtt
1421: WHERE mmtt.transaction_temp_id = p_transaction_id
1422: AND mmtt.content_lpn_id = wlc.parent_lpn_id
1423: UNION ALL
1424: -- This part of the cursor is for 2 cases. Items unpacked from an LPN and packed into another LPN AND
1437: , mmtt.locator_id
1438: , mmtt.transfer_to_location
1439: , wlc.secondary_quantity -- added for invconv
1440: , wlc.secondary_uom_code -- added for invconv
1441: FROM wms_lpn_contents wlc, mtl_material_transactions_temp mmtt
1442: WHERE mmtt.transaction_temp_id = p_transaction_id
1443: AND mmtt.transfer_lpn_id = wlc.parent_lpn_id
1444: UNION ALL
1445: -- This part of the cursor is for all cases except loose items being packed into an existing/new LPN.
1457: , mmtt.locator_id
1458: , mmtt.transfer_to_location
1459: , wlc.secondary_quantity -- added for invconv
1460: , wlc.secondary_uom_code -- added for invconv
1461: FROM wms_lpn_contents wlc, mtl_material_transactions_temp mmtt
1462: WHERE mmtt.transaction_temp_id = p_transaction_id
1463: AND mmtt.lpn_id = wlc.parent_lpn_id;
1464:
1465: -- Packaging/Cartonization Cursors
1469: , wlc.inventory_item_id
1470: , wlc.revision
1471: , wlc.lot_number
1472: , SUM(wlc.quantity)
1473: FROM wms_lpn_contents wlc, WMS_LICENSE_PLATE_NUMBERS wlpn
1474: WHERE wlpn.OUTERMOST_LPN_ID = p_transaction_id
1475: and wlc.parent_lpn_id = wlpn.lpn_id
1476: GROUP BY wlc.organization_id
1477: , wlc.inventory_item_id
2251: AND (l_is_wms_org = TRUE)
2252: ) THEN
2253: --l_receipt_number := inv_rcv_common_apis.g_rcv_global_var.receipt_num;
2254: -- Receipt and Inspection, WMS org, obtaining the lot information
2255: -- from the wms_lpn_contents and the rest information from the
2256: -- rti record
2257: OPEN rti_material_lpn_cur;
2258: FETCH rti_material_lpn_cur INTO l_inventory_item_id
2259: , l_organization_id
2307: ELSIF ((p_label_type_info.business_flow_code IN (2))
2308: AND (l_is_wms_org = TRUE)
2309: ) THEN
2310: -- Receipt and Inspection, WMS org, obtaining the lot information
2311: -- from the wms_lpn_contents and the rest information from the rti record
2312: --l_receipt_number := inv_rcv_common_apis.g_rcv_global_var.receipt_num;
2313: OPEN rti_material_lpn_inspec_cur;
2314: FETCH rti_material_lpn_inspec_cur INTO l_inventory_item_id
2315: , l_organization_id