[Home] [Help]
709: -- Bug 4516067, to improve performance, query the base table directly
710: --, wip_osp_jobs_val_v wojv
711: , wip_entities we -- Added for Bug#4516067
712: , wip_discrete_jobs wdj -- Added for Bug#4516067
713: , wms_license_plate_numbers wlpn -- Bug 3836623
714: , (SELECT cost_group_id, rcv_transaction_id
715: FROM mtl_material_transactions mmt1
716: WHERE mmt1.rcv_transaction_id = p_transaction_id
717: AND nvl(mmt1.logical_transaction, -999) <> 1) mmt -- Modified for bug# 5515979
895: -- Bug 4516067, to improve performance, query the base table directly
896: --, wip_osp_jobs_val_v wojv
897: , wip_entities we
898: , wip_discrete_jobs wdj
899: , wms_license_plate_numbers wlpn -- Bug 3836623
900: , (SELECT cost_group_id, rcv_transaction_id
901: FROM mtl_material_transactions mmt1
902: WHERE mmt1.rcv_transaction_id = p_transaction_id
903: AND nvl(mmt1.logical_transaction, -999) <> 1) mmt -- Modified for bug# 5515979
1066: -- Bug 4516067, to improve performance, query the base table directly
1067: --, wip_osp_jobs_val_v wojv
1068: , wip_entities we
1069: , wip_discrete_jobs wdj
1070: , wms_license_plate_numbers wlpn -- Bug 3836623
1071: WHERE mtln.product_transaction_id(+) = rt.transaction_id
1072: AND mtln.product_code(+) = 'RCV'
1073: AND pol.po_line_id(+) = rt.po_line_id
1074: AND pha.po_header_id(+) = rt.po_header_id
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
1511: , wdd1.locator_id
1512: FROM wsh_delivery_details wdd1
1513: , wsh_delivery_details wdd2
1514: , wsh_delivery_assignments_v wda
1515: , wms_license_plate_numbers wlpn
1516: WHERE wdd1.delivery_detail_id = wda.delivery_detail_id
1517: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id
1518: AND wlpn.lpn_id(+) = wdd2.lpn_id
1519: AND wdd2.delivery_detail_id = p_transaction_id;
1536: , wdd1.locator_id
1537: FROM wsh_delivery_details wdd1
1538: , wsh_delivery_assignments_v wda
1539: , wsh_new_deliveries wnd
1540: , wms_license_plate_numbers wlpn
1541: , wsh_delivery_details wdd2
1542: WHERE wda.delivery_id = wnd.delivery_id
1543: AND wdd1.delivery_detail_id = wda.delivery_detail_id
1544: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id
2419: -- Here in this case the delivery_detail_id is being passed.
2420: -- Delivery detail ID passed means that we just have to print serial label for the one
2421: -- delivery detail id and
2422: -- not all the delivery detail id's in the delivery.
2423: -- The cost group will be derived from the table wms_license_plate_numbers for the LPN
2424: -- stamped on the Delivery_detail_id.
2425: OPEN wdd_material_cur;
2426: FETCH wdd_material_cur INTO l_inventory_item_id
2427: , l_organization_id
2584: ELSIF p_label_type_info.business_flow_code IN (21) THEN
2585: -- Ship Confirm
2586: -- The delivery_id has being passed. Delivery ID passed means that all the delivery details ID have
2587: -- to be derived for the delivery ID. There will be one record per serial number in the wsh_delivery_details.
2588: -- The cost group will be derived from the table wms_license_plate_numbers for the LPN stamped on the Delivery_detail_id.
2589:
2590: OPEN wda_material_cur;
2591: FETCH wda_material_cur INTO l_inventory_item_id
2592: , l_organization_id