[Home] [Help]
907: , wlc.secondary_uom_code secondary_uom -- invconv fabdi
908: FROM wms_lpn_contents wlc
909: , wms_license_plate_numbers plpn
910: , cst_cost_groups ccg
911: , mtl_item_locations milkfv
912: ,(SELECT distinct LPN_ID
913: FROM WMS_LICENSE_PLATE_NUMBERS PLPN
914: WHERE 1 = 1 START WITH LPN_ID = p_lpn_id CONNECT BY PARENT_LPN_ID = PRIOR LPN_ID ) lid -- Added for bug# 14493747
915: -- Bug 4137707, Do not need to include this where clause,
964: , sum(nvl(l_secondary_transaction_qty,mmtt.secondary_transaction_quantity)) secondary_quantity -- invconv fabdi
965: , mmtt.secondary_uom_code secondary_uom -- invconv fabdi
966: FROM wms_license_plate_numbers plpn
967: , cst_cost_groups ccg
968: , mtl_item_locations milkfv
969: , mtl_material_transactions_temp mmtt
970: -- Bug 4137707, Do not need to include this where clause,
971: -- This will be controlled when opening this cursor
972: --WHERE cartonization_flag = 0 -- non Cartonization Flow
1026: FROM wms_packaging_hist wpc
1027: , mtl_material_transactions_temp mmtt
1028: , mtl_system_items msi
1029: , cst_cost_groups ccg
1030: , mtl_item_locations milkfv
1031: -- Bug 4137707, Do not need to include this where clause,
1032: -- This will be controlled when opening this cursor
1033: -- WHERE cartonization_flag = 1 --Cartonization Flow
1034: WHERE wpc.rowid in ( select /*+ cardinality(1) */ id from ((select rowid id from wms_packaging_hist
1302: , milkfv.inventory_location_id locator_id
1303: , inv_project.get_locsegs(milkfv.inventory_location_id, milkfv.organization_id) LOCATOR
1304: , sum(nvl(l_secondary_transaction_qty,mcce.count_quantity_current)) secondary_quantity
1305: , mcce.count_uom_current secondary_uom
1306: FROM wms_license_plate_numbers plpn, cst_cost_groups ccg, mtl_item_locations milkfv,
1307: mtl_cycle_count_entries mcce
1308: WHERE cartonization_flag = 0 -- non Cartonization Flow
1309: AND plpn.lpn_id(+) = p_lpn_id
1310: AND milkfv.organization_id(+) = NVL(p_organization_id, plpn.organization_id)