[Home] [Help]
722: -- Bug 4516067, to improve performance, query the base table directly
723: --, wip_osp_jobs_val_v wojv
724: , wip_entities we -- Added for Bug#4516067
725: , wip_discrete_jobs wdj -- Added for Bug#4516067
726: , wms_license_plate_numbers wlpn -- Bug 3836623
727: , (SELECT cost_group_id, rcv_transaction_id
728: FROM mtl_material_transactions mmt1
729: WHERE mmt1.rcv_transaction_id = p_transaction_id
730: AND nvl(mmt1.logical_transaction, -999) <> 1) mmt -- Modified for bug# 5515979
920: -- Bug 4516067, to improve performance, query the base table directly
921: --, wip_osp_jobs_val_v wojv
922: , wip_entities we
923: , wip_discrete_jobs wdj
924: , wms_license_plate_numbers wlpn -- Bug 3836623
925: , (SELECT cost_group_id, rcv_transaction_id
926: FROM mtl_material_transactions mmt1
927: WHERE mmt1.rcv_transaction_id = p_transaction_id
928: AND nvl(mmt1.logical_transaction, -999) <> 1) mmt -- Modified for bug# 5515979
1103: -- Bug 4516067, to improve performance, query the base table directly
1104: --, wip_osp_jobs_val_v wojv
1105: , wip_entities we
1106: , wip_discrete_jobs wdj
1107: , wms_license_plate_numbers wlpn -- Bug 3836623
1108: WHERE mtln.product_transaction_id(+) = rt.transaction_id
1109: AND mtln.product_code(+) = 'RCV'
1110: AND pol.po_line_id(+) = rt.po_line_id
1111: AND pha.po_header_id(+) = rt.po_header_id
1513: , wlc.inventory_item_id
1514: , wlc.revision
1515: , wlc.lot_number
1516: , SUM(wlc.quantity)
1517: FROM wms_lpn_contents wlc, WMS_LICENSE_PLATE_NUMBERS wlpn
1518: WHERE wlpn.OUTERMOST_LPN_ID = p_transaction_id
1519: and wlc.parent_lpn_id = wlpn.lpn_id
1520: GROUP BY wlc.organization_id
1521: , wlc.inventory_item_id
1555: , wdd1.locator_id
1556: FROM wsh_delivery_details wdd1
1557: , wsh_delivery_details wdd2
1558: , wsh_delivery_assignments_v wda
1559: , wms_license_plate_numbers wlpn
1560: WHERE wdd1.delivery_detail_id = wda.delivery_detail_id
1561: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id
1562: AND wlpn.lpn_id(+) = wdd2.lpn_id
1563: AND wdd2.delivery_detail_id = p_transaction_id;
1580: , wdd1.locator_id
1581: FROM wsh_delivery_details wdd1
1582: , wsh_delivery_assignments_v wda
1583: , wsh_new_deliveries wnd
1584: , wms_license_plate_numbers wlpn
1585: , wsh_delivery_details wdd2
1586: WHERE wda.delivery_id = wnd.delivery_id
1587: AND wdd1.delivery_detail_id = wda.delivery_detail_id
1588: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id
2552: -- Here in this case the delivery_detail_id is being passed.
2553: -- Delivery detail ID passed means that we just have to print serial label for the one
2554: -- delivery detail id and
2555: -- not all the delivery detail id's in the delivery.
2556: -- The cost group will be derived from the table wms_license_plate_numbers for the LPN
2557: -- stamped on the Delivery_detail_id.
2558: OPEN wdd_material_cur;
2559: FETCH wdd_material_cur INTO l_inventory_item_id
2560: , l_organization_id
2729: ELSIF p_label_type_info.business_flow_code IN (21) THEN
2730: -- Ship Confirm
2731: -- The delivery_id has being passed. Delivery ID passed means that all the delivery details ID have
2732: -- to be derived for the delivery ID. There will be one record per serial number in the wsh_delivery_details.
2733: -- The cost group will be derived from the table wms_license_plate_numbers for the LPN stamped on the Delivery_detail_id.
2734:
2735: OPEN wda_material_cur;
2736: FETCH wda_material_cur INTO l_inventory_item_id
2737: , l_organization_id