[Home] [Help]
425: /********************************************************************************
426: * The formation of cursor is different when the LPN Context is Packing Context.
427: * 1) If the LPN Context is Packing then the tables MTL_MATERIAL_TRANSACTIONS_TEMP
428: * and MTL_TRANSACTION_LOTS_TEMPare used to get the required information.
429: * 2) For all other types of LPN Context WMS_LPN_CONTENTS is used.
430: * Bug #4191414 - Modifications to showing the contents for packing context LPNs
431: * The cursor is split in to two select statements
432: * 1. The first SQL fetches the content information for not lot controlled items
433: * by fetching the data from MMTT
690: wlc.parent_lpn_id
691: --lpn status project end
692:
693: FROM
694: wms_lpn_contents wlc,
695: wms_license_plate_numbers lpn,
696: wms_license_plate_numbers lpn3,
697: mtl_parameters mp,
698: cst_cost_groups ccg,
756: -- INVCONV end
757: --lpn status project start
758: wlc.parent_lpn_id
759: --lpn status project end
760: FROM wms_lpn_contents wlc,
761: wms_license_plate_numbers lpn,
762: mtl_parameters mp,
763: wms_license_plate_numbers lpn3,
764: cst_cost_groups ccg,
845: nvl(wlc.cost_group_id, 0) cost_group_id,
846: wlc.source_name source_name,
847: sum(wlc.secondary_quantity) secondary_quantity
848: FROM
849: wms_lpn_contents wlc
850:
851: WHERE
852: wlc.parent_lpn_id = p_parent_lpn_id
853:
963: --lpn status project start
964: wlc.parent_lpn_id
965: --lpn status project end
966:
967: FROM wms_lpn_contents wlc,
968: wms_license_plate_numbers lpn,
969: mtl_parameters mp,
970: wms_license_plate_numbers lpn3,
971: cst_cost_groups ccg,
1050: , NVL(msiv.tracking_quantity_ind, 'P')
1051: , nvl(wlc.secondary_quantity, 0)
1052: , msiv.secondary_uom_code
1053: -- INVCONV end
1054: FROM WMS_LPN_CONTENTS wlc
1055: , WMS_LICENSE_PLATE_NUMBERS lpn
1056: , mtl_system_items_vl msiv -- Modified for Bug # 5472330
1057: , mtl_parameters mp
1058: , wms_license_plate_numbers lpn3