[Home] [Help]
4871: NVL(msi.SECONDARY_DEFAULT_IND,''),
4872: NVL(msi.TRACKING_QUANTITY_IND,'P'),
4873: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
4874: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
4875: -- bug 5172851, wms_lpn_contents_v is replaced with
4876: -- wms_lpn_contents for performance reason
4877: FROM mtl_system_items_vl msi, wms_lpn_contents wlc /* Bug 5581528 */
4878: WHERE msi.concatenated_segments LIKE (p_item)
4879: AND msi.inventory_item_id = wlc.inventory_item_id
4926: NVL(msi.TRACKING_QUANTITY_IND,'P'),
4927: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
4928: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
4929: FROM mtl_system_items_vl msi, /* Bug 5581528 */
4930: -- bug 5172851, wms_lpn_contents_v is replaced with
4931: -- wms_lpn_contents for performance reason
4932: wms_lpn_contents wlc,
4933: mtl_cross_references mcr
4934: WHERE msi.inventory_item_id = wlc.inventory_item_id
4949: OPEN x_revs FOR
4950: SELECT DISTINCT wlc.revision
4951: , mir.effectivity_date
4952: , NVL(mir.description, '')
4953: FROM mtl_item_revisions mir, wms_lpn_contents_v wlc
4954: WHERE wlc.organization_id = p_organization_id
4955: AND wlc.inventory_item_id = TO_NUMBER(p_inventory_item_id)
4956: AND NVL(wlc.parent_lpn_id, '0') = NVL(TO_NUMBER(p_lpn_id), NVL(wlc.parent_lpn_id, '0'))
4957: AND mir.organization_id = wlc.organization_id
5422: OPEN x_revs FOR
5423: SELECT DISTINCT wlc.revision
5424: , mir.effectivity_date
5425: , NVL(mir.description, '')
5426: FROM mtl_item_revisions mir, wms_lpn_contents_v wlc
5427: WHERE wlc.organization_id = p_organization_id
5428: AND wlc.inventory_item_id = TO_NUMBER(p_inventory_item_id)
5429: AND NVL(wlc.parent_lpn_id, '0') = NVL(TO_NUMBER(p_lpn_id), NVL(wlc.parent_lpn_id, '0'))
5430: AND wlc.source_name IN ('RETURN TO VENDOR', 'RETURN TO CUSTOMER', 'RETURN TO RECEIVING')