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 277: 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 */

273: l_where_clause := p_where_clause;
274: l_append:=wms_deploy.get_item_suffix_for_lov(p_concatenated_segments);
275:
276: IF (p_locator_id IS NOT NULL ) THEN
277: 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 */
278: || ''' AND moqd.locator_id = ' || p_locator_id ||'
279: 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;
280:
281: l_sql_stmt := l_sql_stmt||' union all '||l_sql_stmt1 || ' from mtl_system_items_kfv msik, mtl_onhand_quantities_detail moqd

Line 281: l_sql_stmt := l_sql_stmt||' union all '||l_sql_stmt1 || ' from mtl_system_items_kfv msik, mtl_onhand_quantities_detail moqd

277: 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 */
278: || ''' AND moqd.locator_id = ' || p_locator_id ||'
279: 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;
280:
281: l_sql_stmt := l_sql_stmt||' union all '||l_sql_stmt1 || ' from mtl_system_items_kfv msik, mtl_onhand_quantities_detail moqd
282: WHERE msik.organization_id = ' || p_organization_id || ' AND moqd.subinventory_code = ''' || p_subinventory_code || '''
283: AND moqd.locator_id in (select inventory_location_id from mtl_item_locations mil where mil.organization_id = ' || p_organization_id ||'
284: AND mil.physical_location_id = ' || p_locator_id || '
285: and mil.subinventory_code = ''' ||p_subinventory_code||''')

Line 299: 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 */

295: , ''%'' ), ' || g_gtin_code_length || ' , ' || '''00000000000000'''||')' ||
296: ' AND (mcr.organization_id = msik.organization_id OR mcr.org_independent_flag = ' || '''Y''' || ')' || l_where_clause;
297:
298: ELSE
299: 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 */
300: || ''' 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;
301:
302: l_sql_stmt := l_sql_stmt || ' UNION ' || l_sql_stmt_xref ||
303: ' FROM mtl_system_items_vl msik, mtl_cross_references mcr ' || /* Bug 5581528 */

Line 644: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd

640: revisions for other transactions except misc issue/ receipt */
641: -- AND a.implementation_date is not null --BUG 7204523 Added to restrict the revisions that are not yet implemented.
642: AND a.revision LIKE (p_revision)
643: AND (p_planning_org_id IS NULL
644: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd
645: WHERE moqd.revision = a.revision
646: AND moqd.organization_id = a.organization_id
647: AND moqd.inventory_item_id = a.inventory_item_id
648: AND moqd.planning_organization_id = p_planning_org_id

Line 651: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd

647: AND moqd.inventory_item_id = a.inventory_item_id
648: AND moqd.planning_organization_id = p_planning_org_id
649: AND moqd.planning_tp_type = p_planning_tp_type))
650: AND (p_owning_org_id IS NULL
651: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd
652: WHERE moqd.revision = a.revision
653: AND moqd.organization_id = a.organization_id
654: AND moqd.inventory_item_id = a.inventory_item_id
655: AND moqd.owning_organization_id = p_owning_org_id

Line 699: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd

695: AND a.inventory_item_id = p_inventory_item_id
696: AND a.implementation_date is not null --BUG 7204523 Added to restrict the revisions that are not yet implemented.
697: AND a.revision LIKE (p_revision)
698: AND (p_planning_org_id IS NULL
699: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd
700: WHERE moqd.revision = a.revision
701: AND moqd.organization_id = a.organization_id
702: AND moqd.inventory_item_id = a.inventory_item_id
703: AND moqd.planning_organization_id = p_planning_org_id

Line 706: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd

702: AND moqd.inventory_item_id = a.inventory_item_id
703: AND moqd.planning_organization_id = p_planning_org_id
704: AND moqd.planning_tp_type = p_planning_tp_type))
705: AND (p_owning_org_id IS NULL
706: OR EXISTS(SELECT 1 FROM mtl_onhand_quantities_detail moqd
707: WHERE moqd.revision = a.revision
708: AND moqd.organization_id = a.organization_id
709: AND moqd.inventory_item_id = a.inventory_item_id
710: AND moqd.owning_organization_id = p_owning_org_id

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

1993: l_cross_ref := lpad(Rtrim(p_concatenated_segments, '%'), g_gtin_code_length, '00000000000000');
1994:
1995: l_append:=wms_deploy.get_item_suffix_for_lov(p_concatenated_segments);
1996:
1997: l_sql_stmt1 := l_sql_stmt1 || ' FROM mtl_system_items_vl msik, mtl_onhand_quantities_detail moqd'
1998: || ' WHERE msik.concatenated_segments LIKE (''' || p_concatenated_segments ||l_append|| ''')'
1999: || ' AND msik.organization_id = ' || p_organization_id
2000: || ' AND (msik.lot_status_enabled = ''Y'' OR msik.serial_status_enabled = ''Y'')';
2001:

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

1999: || ' AND msik.organization_id = ' || p_organization_id
2000: || ' AND (msik.lot_status_enabled = ''Y'' OR msik.serial_status_enabled = ''Y'')';
2001:
2002: l_sql_stmt_xref := l_sql_stmt_xref || ' FROM mtl_system_items_vl msik,'
2003: || 'mtl_cross_references mcr, mtl_onhand_quantities_detail moqd'
2004: || ' WHERE msik.organization_id = ' || p_organization_id
2005: || ' AND (msik.lot_status_enabled = ''Y'' OR msik.serial_status_enabled = ''Y'' )'
2006: || ' AND msik.inventory_item_id = mcr.inventory_item_id'
2007: || ' AND mcr.cross_reference_type = ''' || g_gtin_cross_ref_type || ''''

Line 3488: 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

3484: NVL(msi.SECONDARY_DEFAULT_IND,''),
3485: NVL(msi.TRACKING_QUANTITY_IND,'P'),
3486: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
3487: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
3488: 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
3489: WHERE moq.organization_id = p_org_id
3490: AND NVL(moq.subinventory_code, '@') = NVL(p_subinventory_code, NVL(moq.subinventory_code, '@'))
3491: AND NVL(moq.locator_id, -1) = NVL(p_locator_id, NVL(moq.locator_id, -1))
3492: AND moq.containerized_flag = 2

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

3540: NVL(msi.SECONDARY_DEFAULT_IND,''),
3541: NVL(msi.TRACKING_QUANTITY_IND,'P'),
3542: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
3543: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
3544: FROM mtl_onhand_quantities_detail moq, -- Bug 2687570, use MOQD instead of MOQ because consigned stock is not visible in MOQ
3545: mtl_system_items_vl msi, /* Bug 5581528 */
3546: mtl_cross_references mcr
3547: WHERE moq.organization_id = p_org_id
3548: AND NVL(moq.subinventory_code, '@') = NVL(p_subinventory_code, NVL(moq.subinventory_code, '@'))

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

3602: NVL(msi.SECONDARY_DEFAULT_IND,''),
3603: NVL(msi.TRACKING_QUANTITY_IND,'P'),
3604: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
3605: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
3606: FROM mtl_onhand_quantities_detail moq, mtl_system_items_vl msi /* Bug 5581528 */
3607: -- Bug 2687570, use MOQD instead of MOQ because consigned stock is not visible in MOQ
3608: WHERE moq.organization_id = p_org_id
3609: AND NVL(moq.subinventory_code, '@') = NVL(p_subinventory_code, NVL(moq.subinventory_code, '@'))
3610: AND NVL(moq.locator_id, -1) = NVL(p_locator_id, NVL(moq.locator_id, -1))

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

3659: NVL(msi.SECONDARY_DEFAULT_IND,''),
3660: NVL(msi.TRACKING_QUANTITY_IND,'P'),
3661: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
3662: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
3663: FROM mtl_onhand_quantities_detail moq, -- Bug 2687570, use MOQD instead of MOQ because consigned stock is not visible in MOQ
3664: mtl_system_items_vl msi, /* Bug 5581528 */
3665: mtl_cross_references mcr
3666: WHERE moq.organization_id = p_org_id
3667: AND NVL(moq.subinventory_code, '@') = NVL(p_subinventory_code, NVL(moq.subinventory_code, '@'))

Line 3970: 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

3966: NVL(msi.SECONDARY_DEFAULT_IND,''),
3967: NVL(msi.TRACKING_QUANTITY_IND,'P'),
3968: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
3969: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
3970: 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
3971: WHERE msi.organization_id = p_org_id
3972: AND NVL(serial_number_control_code, 1) IN (1, 2, 5, 6)
3973: AND msi.concatenated_segments LIKE (p_item||l_append)
3974: AND NVL(container_item_flag, 'N') = NVL(p_container_item_flag, NVL(container_item_flag, 'N'))

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

4024: NVL(msi.SECONDARY_DEFAULT_IND,''),
4025: NVL(msi.TRACKING_QUANTITY_IND,'P'),
4026: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
4027: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
4028: FROM mtl_onhand_quantities_detail moq, -- Bug 2687570, use MOQD instead of MOQ because consigned stock is not visible in MOQ
4029: mtl_system_items_vl msi, /* Bug 5581528 */
4030: mtl_cross_references mcr
4031: WHERE msi.organization_id = p_org_id
4032: AND NVL(serial_number_control_code, 1) IN (1, 2, 5, 6)

Line 5041: 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

5037: NVL(msi.SECONDARY_DEFAULT_IND,''),
5038: NVL(msi.TRACKING_QUANTITY_IND,'P'),
5039: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
5040: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
5041: 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
5042: WHERE moq.containerized_flag = 2
5043: AND moq.organization_id = p_org_id
5044: AND moq.inventory_item_id = msi.inventory_item_id
5045: AND msi.concatenated_segments LIKE (p_item||l_append)

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

5090: NVL(msi.SECONDARY_DEFAULT_IND,''),
5091: NVL(msi.TRACKING_QUANTITY_IND,'P'),
5092: NVL(msi.DUAL_UOM_DEVIATION_HIGH,0),
5093: NVL(msi.DUAL_UOM_DEVIATION_LOW,0)
5094: FROM mtl_onhand_quantities_detail moq, -- Bug 2687570, use MOQD instead of MOQ because consigned stock is not visible in MOQ
5095: mtl_system_items_vl msi, /* Bug 5581528 */
5096: mtl_cross_references mcr
5097: WHERE moq.containerized_flag = 2
5098: AND moq.organization_id = p_org_id

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

6027:
6028:
6029: IF P_LPN IS NULL THEN
6030:
6031: l_sql_stmt1 := l_sql_stmt1 || ' FROM mtl_system_items_vl msik, mtl_onhand_quantities_detail moqd'
6032: || ' WHERE msik.concatenated_segments LIKE (''' || p_concatenated_segments ||l_append|| ''')' -- Bug 9369327
6033:
6034: || ' AND msik.organization_id = ' || p_organization_id
6035: || ' AND (msik.serial_number_control_code in (1,6) OR msik.serial_status_enabled = ''Y'' )'

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

6037: || ' AND moqd.organization_id = msik.organization_id '
6038: || ' AND moqd.lpn_id is NULL ' ;
6039:
6040: l_sql_stmt_xref := l_sql_stmt_xref || ' FROM mtl_system_items_vl msik,'
6041: || 'mtl_cross_references mcr, mtl_onhand_quantities_detail moqd'
6042: || ' WHERE msik.organization_id = ' || p_organization_id
6043: || ' AND (msik.serial_number_control_code in (1,6) OR msik.serial_status_enabled = ''Y'' )'
6044: || ' AND msik.inventory_item_id = mcr.inventory_item_id'
6045: || ' AND mcr.cross_reference_type = ''' || g_gtin_cross_ref_type || ''''

Line 6068: 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'

6064: l_sql_stmt_xref := l_sql_stmt_xref || ' AND moqd.locator_id = ' || p_locator_id;
6065: END IF;
6066: END IF;
6067: ELSE
6068: 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'
6069: || ' WHERE WLPN.LICENSE_PLATE_NUMBER = ''' || p_lpn || ''''
6070: || ' AND WLC.PARENT_LPN_ID = WLPN.LPN_ID '
6071: || ' AND MSIK.INVENTORY_ITEM_ID = WLC.INVENTORY_ITEM_ID '
6072: || ' AND msik.concatenated_segments LIKE (''' || p_concatenated_segments ||l_append|| ''')' -- Bug 9369327

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

6075: || ' AND moqd.organization_id = msik.organization_id'
6076: || ' AND moqd.inventory_item_id = msik.inventory_item_id';
6077:
6078: l_sql_stmt_xref := l_sql_stmt_xref || ' FROM mtl_system_items_vl msik,'
6079: || 'mtl_cross_references mcr, mtl_onhand_quantities_detail moqd ,WMS_LICENSE_PLATE_NUMBERS WLPN ,WMS_LPN_CONTENTS WLC'
6080: || ' WHERE WLPN.LICENSE_PLATE_NUMBER = ''' || p_lpn || ''''
6081: || ' AND WLC.PARENT_LPN_ID = WLPN.LPN_ID '
6082: || ' AND MSIK.INVENTORY_ITEM_ID = WLC.INVENTORY_ITEM_ID '
6083: || ' AND msik.organization_id = ' || p_organization_id