[Home] [Help]
742: , wlc.secondary_uom_code secondary_uom -- invconv fabdi
743: FROM wms_lpn_contents wlc
744: , wms_license_plate_numbers plpn
745: , cst_cost_groups ccg
746: , mtl_item_locations milkfv
747: -- Bug 4137707, Do not need to include this where clause,
748: -- This will be controlled when opening this cursor
749: --WHERE cartonization_flag = 0 -- non Cartonization Flow
750: WHERE --wlc.parent_lpn_id = p_lpn_id /* Modified for the bug # 4771610*/
795: , sum(nvl(l_secondary_transaction_qty,mmtt.secondary_transaction_quantity)) secondary_quantity -- invconv fabdi
796: , mmtt.secondary_uom_code secondary_uom -- invconv fabdi
797: FROM wms_license_plate_numbers plpn
798: , cst_cost_groups ccg
799: , mtl_item_locations milkfv
800: , mtl_material_transactions_temp mmtt
801: -- Bug 4137707, Do not need to include this where clause,
802: -- This will be controlled when opening this cursor
803: --WHERE cartonization_flag = 0 -- non Cartonization Flow
852: FROM wms_packaging_hist wpc
853: , mtl_material_transactions_temp mmtt
854: , mtl_system_items msi
855: , cst_cost_groups ccg
856: , mtl_item_locations milkfv
857: -- Bug 4137707, Do not need to include this where clause,
858: -- This will be controlled when opening this cursor
859: -- WHERE cartonization_flag = 1 --Cartonization Flow
860: WHERE wpc.rowid in (select rowid from wms_packaging_hist
1075: , milkfv.inventory_location_id locator_id
1076: , inv_project.get_locsegs(milkfv.inventory_location_id, milkfv.organization_id) LOCATOR
1077: , sum(nvl(l_secondary_transaction_qty,mcce.count_quantity_current)) secondary_quantity
1078: , mcce.count_uom_current secondary_uom
1079: FROM wms_license_plate_numbers plpn, cst_cost_groups ccg, mtl_item_locations milkfv,
1080: mtl_cycle_count_entries mcce
1081: WHERE cartonization_flag = 0 -- non Cartonization Flow
1082: AND plpn.lpn_id(+) = p_lpn_id
1083: AND milkfv.organization_id(+) = NVL(p_organization_id, plpn.organization_id)