[Home] [Help]
736: , nvl(p_cost_group_id, wlc.cost_group_id) cost_group_id
737: , ccg.cost_group cost_group
738: , milkfv.subinventory_code subinventory_code
739: , milkfv.inventory_location_id locator_id
740: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id, milkfv.organization_id) locator
741: , sum(nvl(l_secondary_transaction_qty,wlc.secondary_quantity)) secondary_quantity -- invconv fabdi
742: , wlc.secondary_uom_code secondary_uom -- invconv fabdi
743: FROM wms_lpn_contents wlc
744: , wms_license_plate_numbers plpn
775: , nvl(p_cost_group_id, wlc.cost_group_id)
776: , ccg.cost_group
777: , milkfv.subinventory_code
778: , milkfv.inventory_location_id
779: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id, milkfv.organization_id)
780: , wlc.secondary_uom_code -- invconv fabdi
781:
782: /*Fix for the bug 3693953. Added the following Query to this cursor*/
783: UNION ALL
790: , nvl(p_cost_group_id, mmtt.cost_group_id) cost_group_id
791: , ccg.cost_group cost_group
792: , milkfv.subinventory_code subinventory_code
793: , milkfv.inventory_location_id locator_id
794: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id, milkfv.organization_id) locator
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
823: , nvl(p_cost_group_id, mmtt.cost_group_id)
824: , ccg.cost_group
825: , milkfv.subinventory_code
826: , milkfv.inventory_location_id
827: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id, milkfv.organization_id)
828: , mmtt.secondary_uom_code; -- invconv fabdi
829:
830: /*End of fix for 3693953*/
831:
845: , mmtt.cost_group_id cost_group_id
846: , ccg.cost_group cost_group
847: , milkfv.subinventory_code subinventory_code
848: , milkfv.inventory_location_id locator_id
849: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id, milkfv.organization_id) locator
850: , l_secondary_transaction_qty secondary_quantity -- invconv fabdi
851: , l_secondary_uom_code secondary_uom -- invconv fabdi
852: FROM wms_packaging_hist wpc
853: , mtl_material_transactions_temp mmtt
890: , mmtt.cost_group_id
891: , ccg.cost_group
892: , milkfv.subinventory_code
893: , milkfv.inventory_location_id
894: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id, milkfv.organization_id);
895:
896:
897: -- Cursor to retrieve all the LPNs (including parent and outermostLPN)
898: -- associated with a shipment_header for ASN business-flow. iSP requirements.
1072: , NVL(p_cost_group_id, mcce.cost_group_id) cost_group_id
1073: , ccg.cost_group cost_group
1074: , milkfv.subinventory_code subinventory_code
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
1093: , NVL(p_cost_group_id, mcce.cost_group_id)
1094: , ccg.cost_group
1095: , milkfv.subinventory_code
1096: , milkfv.inventory_location_id
1097: , inv_project.get_locsegs(milkfv.inventory_location_id, milkfv.organization_id)
1098: , mcce.count_uom_current; /* Added for the bug # 5215799 */
1099:
1100: --Bug 4891916. Added the cursor to fetch records from mcce
1101: --at the time of cycle count entry for a particular entry