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 MTL_ONHAND_QUANTITIES_DETAIL

Line 253: l_sql_stmt := l_sql_stmt1 || ' from mtl_system_items_vl msik, mtl_onhand_quantities_detail moqd WHERE msik.organization_id = ' || p_organization_id || ' AND moqd.subinventory_code = ''' || p_subinventory_code /* Bug 5581528 */

249:
250: BEGIN
251: l_where_clause := p_where_clause;
252: IF (p_locator_id IS NOT NULL ) THEN
253: l_sql_stmt := l_sql_stmt1 || ' from mtl_system_items_vl msik, mtl_onhand_quantities_detail moqd WHERE msik.organization_id = ' || p_organization_id || ' AND moqd.subinventory_code = ''' || p_subinventory_code /* Bug 5581528 */
254: || ''' AND moqd.locator_id = ' || p_locator_id ||
255: ' AND msik.concatenated_segments like :l_conc_seg ' || ' AND msik.organization_id = moqd.organization_id AND msik.inventory_item_id = moqd.inventory_item_id ' || l_where_clause;
256:
257: l_sql_stmt := l_sql_stmt || ' UNION ' || l_sql_stmt_xref ||

Line 267: l_sql_stmt := l_sql_stmt1 || ' from mtl_system_items_vl msik, mtl_onhand_quantities_detail moqd WHERE msik.organization_id = ' || p_organization_id || ' AND moqd.subinventory_code = ''' || p_subinventory_code /* Bug 5581528 */

263: , ''%'' ), ' || g_gtin_code_length || ' , ' || '''00000000000000'''||')' ||
264: ' AND (mcr.organization_id = msik.organization_id OR mcr.org_independent_flag = ' || '''Y''' || ')' || l_where_clause;
265:
266: ELSE
267: l_sql_stmt := l_sql_stmt1 || ' from mtl_system_items_vl msik, mtl_onhand_quantities_detail moqd WHERE msik.organization_id = ' || p_organization_id || ' AND moqd.subinventory_code = ''' || p_subinventory_code /* Bug 5581528 */
268: || ''' AND msik.concatenated_segments like :l_conc_seg ' || ' AND msik.organization_id = moqd.organization_id AND msik.inventory_item_id = moqd.inventory_item_id ' || l_where_clause;
269:
270: l_sql_stmt := l_sql_stmt || ' UNION ' || l_sql_stmt_xref ||
271: ' FROM mtl_system_items_vl msik, mtl_cross_references mcr ' || /* Bug 5581528 */

Line 595: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd

591: AND a.inventory_item_id = p_inventory_item_id
592: AND a.implementation_date is not null --BUG 7204523 Added to restrict the revisions that are not yet implemented.
593: AND a.revision LIKE (p_revision)
594: AND (p_planning_org_id IS NULL
595: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd
596: WHERE moqd.revision = a.revision
597: AND moqd.organization_id = a.organization_id
598: AND moqd.inventory_item_id = a.inventory_item_id
599: AND moqd.planning_organization_id = p_planning_org_id

Line 602: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd

598: AND moqd.inventory_item_id = a.inventory_item_id
599: AND moqd.planning_organization_id = p_planning_org_id
600: AND moqd.planning_tp_type = p_planning_tp_type))
601: AND (p_owning_org_id IS NULL
602: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd
603: WHERE moqd.revision = a.revision
604: AND moqd.organization_id = a.organization_id
605: AND moqd.inventory_item_id = a.inventory_item_id
606: AND moqd.owning_organization_id = p_owning_org_id

Line 1875: l_sql_stmt1 := l_sql_stmt1 || ' FROM mtl_system_items_vl msik, mtl_onhand_quantities_detail moqd'

1871: BEGIN
1872:
1873: l_cross_ref := lpad(Rtrim(p_concatenated_segments, '%'), g_gtin_code_length, '00000000000000');
1874:
1875: l_sql_stmt1 := l_sql_stmt1 || ' FROM mtl_system_items_vl msik, mtl_onhand_quantities_detail moqd'
1876: || ' WHERE msik.concatenated_segments LIKE (''' || p_concatenated_segments || ''')'
1877: || ' AND msik.organization_id = ' || p_organization_id
1878: || ' AND (msik.lot_status_enabled = ''Y'' OR msik.serial_status_enabled = ''Y'')';
1879:

Line 1881: || 'mtl_cross_references mcr, mtl_onhand_quantities_detail moqd'

1877: || ' AND msik.organization_id = ' || p_organization_id
1878: || ' AND (msik.lot_status_enabled = ''Y'' OR msik.serial_status_enabled = ''Y'')';
1879:
1880: l_sql_stmt_xref := l_sql_stmt_xref || ' FROM mtl_system_items_vl msik,'
1881: || 'mtl_cross_references mcr, mtl_onhand_quantities_detail moqd'
1882: || ' WHERE msik.organization_id = ' || p_organization_id
1883: || ' AND (msik.lot_status_enabled = ''Y'' OR msik.serial_status_enabled = ''Y'' )'
1884: || ' AND msik.inventory_item_id = mcr.inventory_item_id'
1885: || ' AND mcr.cross_reference_type = ''' || g_gtin_cross_ref_type || ''''

Line 3258: FROM mtl_onhand_quantities_detail moq, mtl_system_items_vl msi -- Bug 2687570, use MOQD instead of MOQ because consigned stock is not visible in MOQ

3254: NVL(msi.SECONDARY_DEFAULT_IND,''),
3255: NVL(msi.TRACKING_QUANTITY_IND,'P'),
3256: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
3257: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
3258: FROM mtl_onhand_quantities_detail moq, mtl_system_items_vl msi -- Bug 2687570, use MOQD instead of MOQ because consigned stock is not visible in MOQ
3259: WHERE moq.organization_id = p_org_id
3260: AND NVL(moq.subinventory_code, '@') = NVL(p_subinventory_code, NVL(moq.subinventory_code, '@'))
3261: AND NVL(moq.locator_id, -1) = NVL(p_locator_id, NVL(moq.locator_id, -1))
3262: AND moq.containerized_flag = 2

Line 3313: FROM mtl_onhand_quantities_detail moq, -- Bug 2687570, use MOQD instead of MOQ because consigned stock is not visible in MOQ

3309: NVL(msi.SECONDARY_DEFAULT_IND,''),
3310: NVL(msi.TRACKING_QUANTITY_IND,'P'),
3311: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
3312: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
3313: FROM mtl_onhand_quantities_detail moq, -- Bug 2687570, use MOQD instead of MOQ because consigned stock is not visible in MOQ
3314: mtl_system_items_vl msi, /* Bug 5581528 */
3315: mtl_cross_references mcr
3316: WHERE moq.organization_id = p_org_id
3317: AND NVL(moq.subinventory_code, '@') = NVL(p_subinventory_code, NVL(moq.subinventory_code, '@'))

Line 3374: FROM mtl_onhand_quantities_detail moq, mtl_system_items_vl msi /* Bug 5581528 */

3370: NVL(msi.SECONDARY_DEFAULT_IND,''),
3371: NVL(msi.TRACKING_QUANTITY_IND,'P'),
3372: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
3373: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
3374: FROM mtl_onhand_quantities_detail moq, mtl_system_items_vl msi /* Bug 5581528 */
3375: -- Bug 2687570, use MOQD instead of MOQ because consigned stock is not visible in MOQ
3376: WHERE moq.organization_id = p_org_id
3377: AND NVL(moq.subinventory_code, '@') = NVL(p_subinventory_code, NVL(moq.subinventory_code, '@'))
3378: AND NVL(moq.locator_id, -1) = NVL(p_locator_id, NVL(moq.locator_id, -1))

Line 3430: FROM mtl_onhand_quantities_detail moq, -- Bug 2687570, use MOQD instead of MOQ because consigned stock is not visible in MOQ

3426: NVL(msi.SECONDARY_DEFAULT_IND,''),
3427: NVL(msi.TRACKING_QUANTITY_IND,'P'),
3428: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
3429: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
3430: FROM mtl_onhand_quantities_detail moq, -- Bug 2687570, use MOQD instead of MOQ because consigned stock is not visible in MOQ
3431: mtl_system_items_vl msi, /* Bug 5581528 */
3432: mtl_cross_references mcr
3433: WHERE moq.organization_id = p_org_id
3434: AND NVL(moq.subinventory_code, '@') = NVL(p_subinventory_code, NVL(moq.subinventory_code, '@'))

Line 3726: FROM mtl_onhand_quantities_detail moq, mtl_system_items_vl msi -- Bug 2687570, use MOQD instead of MOQ because consigned stock is not visible in MOQ

3722: NVL(msi.SECONDARY_DEFAULT_IND,''),
3723: NVL(msi.TRACKING_QUANTITY_IND,'P'),
3724: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
3725: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
3726: FROM mtl_onhand_quantities_detail moq, mtl_system_items_vl msi -- Bug 2687570, use MOQD instead of MOQ because consigned stock is not visible in MOQ
3727: WHERE msi.organization_id = p_org_id
3728: AND NVL(serial_number_control_code, 1) IN (1, 2, 5, 6)
3729: AND msi.concatenated_segments LIKE (p_item)
3730: AND NVL(container_item_flag, 'N') = NVL(p_container_item_flag, NVL(container_item_flag, 'N'))

Line 3783: FROM mtl_onhand_quantities_detail moq, -- Bug 2687570, use MOQD instead of MOQ because consigned stock is not visible in MOQ

3779: NVL(msi.SECONDARY_DEFAULT_IND,''),
3780: NVL(msi.TRACKING_QUANTITY_IND,'P'),
3781: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
3782: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
3783: FROM mtl_onhand_quantities_detail moq, -- Bug 2687570, use MOQD instead of MOQ because consigned stock is not visible in MOQ
3784: mtl_system_items_vl msi, /* Bug 5581528 */
3785: mtl_cross_references mcr
3786: WHERE msi.organization_id = p_org_id
3787: AND NVL(serial_number_control_code, 1) IN (1, 2, 5, 6)

Line 4763: FROM mtl_onhand_quantities_detail moq, mtl_system_items_vl msi -- Bug 2687570, use MOQD instead of MOQ because consigned stock is not visible in MOQ

4759: NVL(msi.SECONDARY_DEFAULT_IND,''),
4760: NVL(msi.TRACKING_QUANTITY_IND,'P'),
4761: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
4762: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
4763: FROM mtl_onhand_quantities_detail moq, mtl_system_items_vl msi -- Bug 2687570, use MOQD instead of MOQ because consigned stock is not visible in MOQ
4764: WHERE moq.containerized_flag = 2
4765: AND moq.organization_id = p_org_id
4766: AND moq.inventory_item_id = msi.inventory_item_id
4767: AND msi.concatenated_segments LIKE (p_item)

Line 4815: FROM mtl_onhand_quantities_detail moq, -- Bug 2687570, use MOQD instead of MOQ because consigned stock is not visible in MOQ

4811: NVL(msi.SECONDARY_DEFAULT_IND,''),
4812: NVL(msi.TRACKING_QUANTITY_IND,'P'),
4813: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
4814: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
4815: FROM mtl_onhand_quantities_detail moq, -- Bug 2687570, use MOQD instead of MOQ because consigned stock is not visible in MOQ
4816: mtl_system_items_vl msi, /* Bug 5581528 */
4817: mtl_cross_references mcr
4818: WHERE moq.containerized_flag = 2
4819: AND moq.organization_id = p_org_id

Line 5697: l_sql_stmt1 := l_sql_stmt1 || ' FROM mtl_system_items_vl msik, mtl_onhand_quantities_detail moqd'

5693:
5694:
5695: IF P_LPN IS NULL THEN
5696:
5697: l_sql_stmt1 := l_sql_stmt1 || ' FROM mtl_system_items_vl msik, mtl_onhand_quantities_detail moqd'
5698: || ' WHERE msik.concatenated_segments LIKE (''' || p_concatenated_segments || ''')'
5699:
5700: || ' AND msik.organization_id = ' || p_organization_id
5701: || ' AND (msik.serial_number_control_code in (1,6) OR msik.serial_status_enabled = ''Y'' )'

Line 5707: || 'mtl_cross_references mcr, mtl_onhand_quantities_detail moqd'

5703: || ' AND moqd.organization_id = msik.organization_id '
5704: || ' AND moqd.lpn_id is NULL ' ;
5705:
5706: l_sql_stmt_xref := l_sql_stmt_xref || ' FROM mtl_system_items_vl msik,'
5707: || 'mtl_cross_references mcr, mtl_onhand_quantities_detail moqd'
5708: || ' WHERE msik.organization_id = ' || p_organization_id
5709: || ' AND (msik.serial_number_control_code in (1,6) OR msik.serial_status_enabled = ''Y'' )'
5710: || ' AND msik.inventory_item_id = mcr.inventory_item_id'
5711: || ' AND mcr.cross_reference_type = ''' || g_gtin_cross_ref_type || ''''

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