[Home] [Help]
901: , nvl(p_cost_group_id, wlc.cost_group_id) cost_group_id
902: , ccg.cost_group cost_group
903: , milkfv.subinventory_code subinventory_code
904: , milkfv.inventory_location_id locator_id
905: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id, milkfv.organization_id) locator
906: , sum(nvl(l_secondary_transaction_qty,wlc.secondary_quantity)) secondary_quantity -- invconv fabdi
907: , wlc.secondary_uom_code secondary_uom -- invconv fabdi
908: FROM wms_lpn_contents wlc
909: , wms_license_plate_numbers plpn
944: , nvl(p_cost_group_id, wlc.cost_group_id)
945: , ccg.cost_group
946: , milkfv.subinventory_code
947: , milkfv.inventory_location_id
948: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id, milkfv.organization_id)
949: , wlc.secondary_uom_code -- invconv fabdi
950:
951: /*Fix for the bug 3693953. Added the following Query to this cursor*/
952: UNION ALL
959: , nvl(p_cost_group_id, mmtt.cost_group_id) cost_group_id
960: , ccg.cost_group cost_group
961: , milkfv.subinventory_code subinventory_code
962: , milkfv.inventory_location_id locator_id
963: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id, milkfv.organization_id) locator
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
996: , nvl(p_cost_group_id, mmtt.cost_group_id)
997: , ccg.cost_group
998: , milkfv.subinventory_code
999: , milkfv.inventory_location_id
1000: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id, milkfv.organization_id)
1001: , mmtt.secondary_uom_code; -- invconv fabdi
1002:
1003: /*End of fix for 3693953*/
1004:
1019: , mmtt.cost_group_id cost_group_id
1020: , ccg.cost_group cost_group
1021: , milkfv.subinventory_code subinventory_code
1022: , milkfv.inventory_location_id locator_id
1023: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id, milkfv.organization_id) locator
1024: , l_secondary_transaction_qty secondary_quantity -- invconv fabdi
1025: , l_secondary_uom_code secondary_uom -- invconv fabdi
1026: FROM wms_packaging_hist wpc
1027: , mtl_material_transactions_temp mmtt
1064: , mmtt.cost_group_id
1065: , ccg.cost_group
1066: , milkfv.subinventory_code
1067: , milkfv.inventory_location_id
1068: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id, milkfv.organization_id);
1069:
1070:
1071: -- Cursor to retrieve all the LPNs (including parent and outermostLPN)
1072: -- associated with a shipment_header for ASN business-flow. iSP requirements.
1299: , NVL(p_cost_group_id, mcce.cost_group_id) cost_group_id
1300: , ccg.cost_group cost_group
1301: , milkfv.subinventory_code subinventory_code
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
1320: , NVL(p_cost_group_id, mcce.cost_group_id)
1321: , ccg.cost_group
1322: , milkfv.subinventory_code
1323: , milkfv.inventory_location_id
1324: , inv_project.get_locsegs(milkfv.inventory_location_id, milkfv.organization_id)
1325: , mcce.count_uom_current; /* Added for the bug # 5215799 */
1326:
1327: --Bug 4891916. Added the cursor to fetch records from mcce
1328: --at the time of cycle count entry for a particular entry