[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
614: wlc.parent_lpn_id
615: --lpn status project end
616:
617: FROM
618: wms_lpn_contents wlc,
619: wms_license_plate_numbers lpn,
620: wms_license_plate_numbers lpn3,
621: mtl_parameters mp,
622: cst_cost_groups ccg,
680: -- INVCONV end
681: --lpn status project start
682: wlc.parent_lpn_id
683: --lpn status project end
684: FROM wms_lpn_contents wlc,
685: wms_license_plate_numbers lpn,
686: mtl_parameters mp,
687: wms_license_plate_numbers lpn3,
688: cst_cost_groups ccg,
769: nvl(wlc.cost_group_id, 0) cost_group_id,
770: wlc.source_name source_name,
771: sum(wlc.secondary_quantity) secondary_quantity
772: FROM
773: wms_lpn_contents wlc
774:
775: WHERE
776: wlc.parent_lpn_id = p_parent_lpn_id
777:
887: --lpn status project start
888: wlc.parent_lpn_id
889: --lpn status project end
890:
891: FROM wms_lpn_contents wlc,
892: wms_license_plate_numbers lpn,
893: mtl_parameters mp,
894: wms_license_plate_numbers lpn3,
895: cst_cost_groups ccg,
974: , NVL(msiv.tracking_quantity_ind, 'P')
975: , nvl(wlc.secondary_quantity, 0)
976: , msiv.secondary_uom_code
977: -- INVCONV end
978: FROM WMS_LPN_CONTENTS wlc
979: , WMS_LICENSE_PLATE_NUMBERS lpn
980: , mtl_system_items_vl msiv -- Modified for Bug # 5472330
981: , mtl_parameters mp
982: , wms_license_plate_numbers lpn3