[Home] [Help]
5151: NVL(msi.SECONDARY_DEFAULT_IND,''),
5152: NVL(msi.TRACKING_QUANTITY_IND,'P'),
5153: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
5154: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
5155: -- bug 5172851, wms_lpn_contents_v is replaced with
5156: -- wms_lpn_contents for performance reason
5157: FROM mtl_system_items_vl msi, wms_lpn_contents wlc /* Bug 5581528 */
5158: WHERE msi.concatenated_segments LIKE (p_item||l_append)
5159: AND msi.inventory_item_id = wlc.inventory_item_id
5207: NVL(msi.TRACKING_QUANTITY_IND,'P'),
5208: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
5209: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
5210: FROM mtl_system_items_vl msi, /* Bug 5581528 */
5211: -- bug 5172851, wms_lpn_contents_v is replaced with
5212: -- wms_lpn_contents for performance reason
5213: wms_lpn_contents wlc,
5214: mtl_cross_references mcr
5215: WHERE msi.inventory_item_id = wlc.inventory_item_id
5230: OPEN x_revs FOR
5231: SELECT DISTINCT wlc.revision
5232: , mir.effectivity_date
5233: , NVL(mir.description, '')
5234: FROM mtl_item_revisions mir, wms_lpn_contents_v wlc
5235: WHERE wlc.organization_id = p_organization_id
5236: AND wlc.inventory_item_id = TO_NUMBER(p_inventory_item_id)
5237: AND NVL(wlc.parent_lpn_id, '0') = NVL(TO_NUMBER(p_lpn_id), NVL(wlc.parent_lpn_id, '0'))
5238: AND mir.organization_id = wlc.organization_id
5723: OPEN x_revs FOR
5724: SELECT DISTINCT wlc.revision
5725: , mir.effectivity_date
5726: , NVL(mir.description, '')
5727: FROM mtl_item_revisions mir, wms_lpn_contents_v wlc
5728: WHERE wlc.organization_id = p_organization_id
5729: AND wlc.inventory_item_id = TO_NUMBER(p_inventory_item_id)
5730: AND NVL(wlc.parent_lpn_id, '0') = NVL(TO_NUMBER(p_lpn_id), NVL(wlc.parent_lpn_id, '0'))
5731: AND wlc.source_name IN ('RETURN TO VENDOR', 'RETURN TO CUSTOMER', 'RETURN TO RECEIVING')