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_RCV_LOVS dependencies on MTL_CROSS_REFERENCES

Line 3649: ,mtl_cross_references mcr

3645: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
3646: msi.stock_enabled_flag
3647: from po_lines_all pol
3648: ,mtl_system_items_vl msi /* Bug 5581528 */
3649: ,mtl_cross_references mcr
3650: where msi.organization_id = p_organization_id
3651: and ( (mcr.cross_reference_type = p_crossreftype
3652: and mcr.cross_reference like p_concatenated_segments
3653: ) or

Line 4113: ,mtl_cross_references mcr

4109: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4110: msi.stock_enabled_flag
4111: from po_lines_all pol
4112: ,mtl_system_items_vl msi /* Bug 5581528 */
4113: ,mtl_cross_references mcr
4114: where msi.organization_id = p_organization_id
4115: and ( (mcr.cross_reference_type = p_crossreftype
4116: and mcr.cross_reference like p_concatenated_segments
4117: ) or

Line 4583: ,mtl_cross_references mcr

4579: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
4580: msi.stock_enabled_flag
4581: from po_lines_all pol
4582: ,mtl_system_items_vl msi /* Bug 5581528 */
4583: ,mtl_cross_references mcr
4584: where msi.organization_id = p_organization_id
4585: and ( (mcr.cross_reference_type = p_crossreftype
4586: and mcr.cross_reference like p_concatenated_segments
4587: ) or

Line 5023: ,mtl_cross_references mcr

5019: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5020: msi.stock_enabled_flag
5021: from po_lines_all pol
5022: ,mtl_system_items_vl msi /* Bug 5581528 */
5023: ,mtl_cross_references mcr
5024: where msi.organization_id = p_organization_id
5025: and ( (mcr.cross_reference_type = p_crossreftype
5026: and mcr.cross_reference like p_concatenated_segments
5027: ) or

Line 5443: ,mtl_cross_references mcr

5439: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5440: msi.stock_enabled_flag
5441: from po_lines_all pol
5442: ,mtl_system_items_vl msi /* Bug 5581528 */
5443: ,mtl_cross_references mcr
5444: where msi.organization_id = p_organization_id
5445: and ( (mcr.cross_reference_type = p_crossreftype
5446: and mcr.cross_reference like p_concatenated_segments
5447: ) or

Line 5861: ,mtl_cross_references mcr

5857: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
5858: msi.stock_enabled_flag
5859: from po_lines_all pol
5860: ,mtl_system_items_vl msi /* Bug 5581528 */
5861: ,mtl_cross_references mcr
5862: where msi.organization_id = p_organization_id
5863: and ( (mcr.cross_reference_type = p_crossreftype
5864: and mcr.cross_reference like p_concatenated_segments
5865: ) or

Line 6217: mtl_cross_references mcr

6213: NVL(MSN.DUAL_UOM_DEVIATION_LOW,0),
6214: msn.stock_enabled_flag
6215: from mtl_system_items_vl msn, /* Bug 5581528 */
6216: rcv_shipment_lines rsl,
6217: mtl_cross_references mcr
6218: WHERE msn.organization_id = p_Organization_Id
6219: and ( mcr.cross_reference_type = g_gtin_cross_ref_type
6220: AND mcr.cross_reference LIKE g_crossref
6221: )

Line 6364: ,mtl_cross_references mcr

6360: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
6361: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
6362: msi.stock_enabled_flag
6363: from mtl_system_items_vl msi /* Bug 5581528 */
6364: ,mtl_cross_references mcr
6365: WHERE msi.organization_id = p_Organization_Id
6366: and ( mcr.cross_reference_type = g_gtin_cross_ref_type
6367: AND mcr.cross_reference LIKE g_crossref
6368: )

Line 6516: ,mtl_cross_references mcr

6512: NVL(MSI.DUAL_UOM_DEVIATION_HIGH,0),
6513: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
6514: msi.stock_enabled_flag
6515: from mtl_system_items_vl msi Bug 5581528
6516: ,mtl_cross_references mcr
6517: WHERE msi.organization_id = p_Organization_Id
6518: and ( mcr.cross_reference_type = g_gtin_cross_ref_type
6519: AND mcr.cross_reference LIKE g_crossref
6520: )

Line 6754: mtl_cross_references mcr

6750: msi.stock_enabled_flag
6751: FROM mtl_system_items_vl msi
6752: /* Bug 5581528 */
6753: ,
6754: mtl_cross_references mcr
6755: WHERE msi.organization_id = p_Organization_Id
6756: AND ( mcr.cross_reference_type = g_gtin_cross_ref_type
6757: AND mcr.cross_reference LIKE g_crossref )
6758: AND ( (mcr.org_independent_flag = 'Y')

Line 7074: mtl_cross_references mcr

7070: NVL(MSI.DUAL_UOM_DEVIATION_LOW,0),
7071: msi.stock_enabled_flag
7072: FROM
7073: mtl_system_items_vl msi, /* Bug 5581528 */
7074: mtl_cross_references mcr
7075: WHERE msi.organization_id = p_organization_Id
7076: AND ( (mcr.cross_reference_type = p_crossreftype
7077: AND mcr.cross_reference LIKE p_concatenated_segments
7078: ) OR

Line 7281: mtl_cross_references mcr

7277: NVL(TRACKING_QUANTITY_IND,'P'),
7278: NVL(DUAL_UOM_DEVIATION_HIGH,0),
7279: NVL(DUAL_UOM_DEVIATION_LOW,0)
7280: from mtl_system_items_vl msik, /* Bug 5581528 */
7281: mtl_cross_references mcr
7282: WHERE msik.organization_id = p_Organization_Id
7283: AND msik.inventory_item_id = mcr.inventory_item_id
7284: AND mcr.cross_reference_type = g_gtin_cross_ref_type
7285: AND mcr.cross_reference LIKE g_crossref

Line 7605: mtl_cross_references mcr

7601: NVL(DUAL_UOM_DEVIATION_HIGH,0),
7602: NVL(DUAL_UOM_DEVIATION_LOW,0)
7603: FROM
7604: mtl_system_items_vl msik, /* Bug 5581528 */
7605: mtl_cross_references mcr
7606: WHERE
7607: msik.organization_id = p_organization_id
7608: AND msik.inventory_item_id = mcr.inventory_item_id
7609: AND mcr.cross_reference_type = g_gtin_cross_ref_type

Line 7726: mtl_cross_references mcr

7722: NVL(DUAL_UOM_DEVIATION_HIGH,0),
7723: NVL(DUAL_UOM_DEVIATION_LOW,0)
7724: FROM
7725: mtl_system_items_vl msik, /* Bug 5581528 */
7726: mtl_cross_references mcr
7727: WHERE
7728: msik.organization_id = p_organization_id
7729: AND msik.inventory_item_id = mcr.inventory_item_id
7730: AND mcr.cross_reference_type = g_gtin_cross_ref_type

Line 7841: mtl_cross_references mcr

7837: NVL(DUAL_UOM_DEVIATION_HIGH,0),
7838: NVL(DUAL_UOM_DEVIATION_LOW,0)
7839: FROM
7840: mtl_system_items_vl msik, /* Bug 5581528 */
7841: mtl_cross_references mcr
7842: WHERE
7843: msik.organization_id = p_organization_id
7844: AND msik.inventory_item_id = mcr.inventory_item_id
7845: AND mcr.cross_reference_type = g_gtin_cross_ref_type

Line 7956: mtl_cross_references mcr

7952: NVL(DUAL_UOM_DEVIATION_HIGH,0),
7953: NVL(DUAL_UOM_DEVIATION_LOW,0)
7954: FROM
7955: mtl_system_items_vl msik, /* Bug 5581528 */
7956: mtl_cross_references mcr
7957: WHERE
7958: msik.organization_id = p_organization_id
7959: AND msik.inventory_item_id = mcr.inventory_item_id
7960: AND mcr.cross_reference_type = g_gtin_cross_ref_type

Line 8072: mtl_cross_references mcr

8068: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8069: NVL(DUAL_UOM_DEVIATION_LOW,0)
8070: FROM
8071: mtl_system_items_vl msik, /* Bug 5581528 */
8072: mtl_cross_references mcr
8073: WHERE
8074: msik.organization_id = p_organization_id
8075: AND msik.inventory_item_id = mcr.inventory_item_id
8076: AND mcr.cross_reference_type = g_gtin_cross_ref_type

Line 8187: mtl_cross_references mcr

8183: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8184: NVL(DUAL_UOM_DEVIATION_LOW,0)
8185: FROM
8186: mtl_system_items_vl msik, /* Bug 5581528 */
8187: mtl_cross_references mcr
8188: WHERE
8189: msik.organization_id = p_organization_id
8190: AND msik.inventory_item_id = mcr.inventory_item_id
8191: AND mcr.cross_reference_type = g_gtin_cross_ref_type

Line 8302: mtl_cross_references mcr

8298: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8299: NVL(DUAL_UOM_DEVIATION_LOW,0)
8300: FROM
8301: mtl_system_items_vl msik, /* Bug 5581528 */
8302: mtl_cross_references mcr
8303: WHERE
8304: msik.organization_id = p_organization_id
8305: AND msik.inventory_item_id = mcr.inventory_item_id
8306: AND mcr.cross_reference_type = g_gtin_cross_ref_type