eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_UI_ITEM_LOVS dependencies on WMS_LPN_CONTENTS

Line 3497: FROM mtl_system_items_vl msi, wms_lpn_contents wlc /* Bug 5581528 */

3493: NVL(msi.SECONDARY_DEFAULT_IND,''),
3494: NVL(msi.TRACKING_QUANTITY_IND,'P'),
3495: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
3496: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
3497: FROM mtl_system_items_vl msi, wms_lpn_contents wlc /* Bug 5581528 */
3498: WHERE wlc.organization_id = p_org_id
3499: AND wlc.parent_lpn_id = TO_NUMBER(p_lpn_id)
3500: AND msi.inventory_item_id = wlc.inventory_item_id
3501: AND msi.organization_id = wlc.organization_id

Line 3551: wms_lpn_contents wlc,

3547: NVL(msi.TRACKING_QUANTITY_IND,'P'),
3548: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
3549: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
3550: FROM mtl_system_items_vl msi, /* Bug 5581528 */
3551: wms_lpn_contents wlc,
3552: mtl_cross_references mcr
3553: WHERE wlc.organization_id = p_org_id
3554: AND wlc.parent_lpn_id = TO_NUMBER(p_lpn_id)
3555: AND msi.inventory_item_id = wlc.inventory_item_id

Line 3934: FROM mtl_item_uoms_view miuv, wms_lpn_contents wlc

3930: p_Inventory_Item_Id)) uom_code_comp
3931: , miuv.unit_of_measure
3932: , miuv.description
3933: , miuv.uom_class
3934: FROM mtl_item_uoms_view miuv, wms_lpn_contents wlc
3935: WHERE wlc.organization_id = p_organization_id
3936: AND wlc.inventory_item_id = p_inventory_item_id
3937: AND NVL(wlc.parent_lpn_id, 0) = NVL(p_lpn_id, NVL(wlc.parent_lpn_id, 0))
3938: AND miuv.organization_id = wlc.organization_id

Line 4875: -- bug 5172851, wms_lpn_contents_v is replaced with

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

Line 4876: -- wms_lpn_contents for performance reason

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
4880: AND msi.organization_id = p_org_id

Line 4877: FROM mtl_system_items_vl msi, wms_lpn_contents wlc /* Bug 5581528 */

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
4880: AND msi.organization_id = p_org_id
4881: AND wlc.parent_lpn_id = p_lpn_id

Line 4930: -- bug 5172851, wms_lpn_contents_v is replaced with

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

Line 4931: -- wms_lpn_contents for performance reason

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
4935: AND msi.organization_id = p_org_id

Line 4932: wms_lpn_contents wlc,

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
4935: AND msi.organization_id = p_org_id
4936: AND wlc.parent_lpn_id = p_lpn_id

Line 4953: FROM mtl_item_revisions mir, wms_lpn_contents_v wlc

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

Line 5241: FROM mtl_system_items_vl msi, wms_lpn_contents wlpnc /* Bug 5581528 */

5237: NVL(msi.SECONDARY_DEFAULT_IND,''),
5238: NVL(msi.TRACKING_QUANTITY_IND,'P'),
5239: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
5240: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
5241: FROM mtl_system_items_vl msi, wms_lpn_contents wlpnc /* Bug 5581528 */
5242: WHERE wlpnc.parent_lpn_id = p_lpn_id
5243: AND wlpnc.source_name IN ('RETURN TO VENDOR', 'RETURN TO CUSTOMER', 'RETURN TO RECEIVING')
5244: AND wlpnc.organization_id = p_org_id
5245: AND msi.organization_id = wlpnc.organization_id

Line 5347: wms_lpn_contents wlpnc,

5343: NVL(msi.TRACKING_QUANTITY_IND,'P'),
5344: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
5345: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
5346: FROM mtl_system_items_vl msi, /* Bug 5581528 */
5347: wms_lpn_contents wlpnc,
5348: mtl_cross_references mcr
5349: WHERE wlpnc.parent_lpn_id = p_lpn_id
5350: AND wlpnc.source_name IN ('RETURN TO VENDOR', 'RETURN TO CUSTOMER', 'RETURN TO RECEIVING')
5351: AND wlpnc.organization_id = p_org_id

Line 5426: FROM mtl_item_revisions mir, wms_lpn_contents_v wlc

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')

Line 5734: l_sql_stmt1 := l_sql_stmt1 || ' FROM mtl_system_items_vl msik, mtl_onhand_quantities_detail moqd ,WMS_LICENSE_PLATE_NUMBERS WLPN ,WMS_LPN_CONTENTS WLC'

5730: l_sql_stmt_xref := l_sql_stmt_xref || ' AND moqd.locator_id = ' || p_locator_id;
5731: END IF;
5732: END IF;
5733: ELSE
5734: l_sql_stmt1 := l_sql_stmt1 || ' FROM mtl_system_items_vl msik, mtl_onhand_quantities_detail moqd ,WMS_LICENSE_PLATE_NUMBERS WLPN ,WMS_LPN_CONTENTS WLC'
5735: || ' WHERE WLPN.LICENSE_PLATE_NUMBER = ''' || p_lpn || ''''
5736: || ' AND WLC.PARENT_LPN_ID = WLPN.LPN_ID '
5737: || ' AND MSIK.INVENTORY_ITEM_ID = WLC.INVENTORY_ITEM_ID '
5738: || ' AND msik.concatenated_segments LIKE (''' || p_concatenated_segments || ''')'

Line 5745: || 'mtl_cross_references mcr, mtl_onhand_quantities_detail moqd ,WMS_LICENSE_PLATE_NUMBERS WLPN ,WMS_LPN_CONTENTS WLC'

5741: || ' AND moqd.organization_id = msik.organization_id'
5742: || ' AND moqd.inventory_item_id = msik.inventory_item_id';
5743:
5744: l_sql_stmt_xref := l_sql_stmt_xref || ' FROM mtl_system_items_vl msik,'
5745: || 'mtl_cross_references mcr, mtl_onhand_quantities_detail moqd ,WMS_LICENSE_PLATE_NUMBERS WLPN ,WMS_LPN_CONTENTS WLC'
5746: || ' WHERE WLPN.LICENSE_PLATE_NUMBER = ''' || p_lpn || ''''
5747: || ' AND WLC.PARENT_LPN_ID = WLPN.LPN_ID '
5748: || ' AND MSIK.INVENTORY_ITEM_ID = WLC.INVENTORY_ITEM_ID '
5749: || ' AND msik.organization_id = ' || p_organization_id