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 3807: ,mtl_cross_references mcr

3803: ' ',
3804: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
3805: from po_lines_trx_v pol -- CLM project, bug 9403291
3806: ,mtl_system_items_vl msi /* Bug 5581528 */
3807: ,mtl_cross_references mcr
3808: where msi.organization_id = p_organization_id
3809: and ( (mcr.cross_reference_type = p_crossreftype
3810: and mcr.cross_reference like p_concatenated_segments
3811: ) or

Line 4385: ,mtl_cross_references mcr

4381: ' ',
4382: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
4383: from po_lines_trx_v pol -- CLM project, bug 9403291
4384: ,mtl_system_items_vl msi /* Bug 5581528 */
4385: ,mtl_cross_references mcr
4386: where msi.organization_id = p_organization_id
4387: and ( (mcr.cross_reference_type = p_crossreftype
4388: and mcr.cross_reference like p_concatenated_segments
4389: ) or

Line 4971: ,mtl_cross_references mcr

4967: ' ',
4968: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
4969: from po_lines_trx_v pol -- CLM project, bug 9403291
4970: ,mtl_system_items_vl msi /* Bug 5581528 */
4971: ,mtl_cross_references mcr
4972: where msi.organization_id = p_organization_id
4973: and ( (mcr.cross_reference_type = p_crossreftype
4974: and mcr.cross_reference like p_concatenated_segments
4975: ) or

Line 5514: ,mtl_cross_references mcr

5510: ' ',
5511: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
5512: from po_lines_trx_v pol -- CLM project, bug 9403291
5513: ,mtl_system_items_vl msi /* Bug 5581528 */
5514: ,mtl_cross_references mcr
5515: where msi.organization_id = p_organization_id
5516: and ( (mcr.cross_reference_type = p_crossreftype
5517: and mcr.cross_reference like p_concatenated_segments
5518: ) or

Line 6040: ,mtl_cross_references mcr

6036: ' ',
6037: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
6038: from po_lines_trx_v pol -- CLM project, bug 9403291
6039: ,mtl_system_items_vl msi /* Bug 5581528 */
6040: ,mtl_cross_references mcr
6041: where msi.organization_id = p_organization_id
6042: and ( (mcr.cross_reference_type = p_crossreftype
6043: and mcr.cross_reference like p_concatenated_segments
6044: ) or

Line 6561: ,mtl_cross_references mcr

6557: ' ',
6558: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
6559: from po_lines_trx_v pol -- CLM project, bug 9403291
6560: ,mtl_system_items_vl msi /* Bug 5581528 */
6561: ,mtl_cross_references mcr
6562: where msi.organization_id = p_organization_id
6563: and ( (mcr.cross_reference_type = p_crossreftype
6564: and mcr.cross_reference like p_concatenated_segments
6565: ) or

Line 7029: mtl_cross_references mcr

7025: from wms_lpn_contents wlc,
7026: mtl_system_items_vl msn, /* Bug 5581528 */
7027: rcv_shipment_lines rsl,
7028: rcv_shipment_headers rsh, /* Added for Bug9257750 */
7029: mtl_cross_references mcr
7030: WHERE msn.organization_id = p_Organization_Id
7031: and wlc.parent_lpn_id = l_from_lpn_id
7032: and wlc.inventory_item_id = rsl.item_id
7033: and ( mcr.cross_reference_type = g_gtin_cross_ref_type

Line 7365: mtl_cross_references mcr

7361: p_shipmentHeaderID) -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
7362: from mtl_system_items_vl msn, /* Bug 5581528 */
7363: rcv_shipment_lines rsl,
7364: rcv_shipment_headers rsh, /* Added for Bug9257750 */
7365: mtl_cross_references mcr
7366: WHERE msn.organization_id = p_Organization_Id
7367: and ( mcr.cross_reference_type = g_gtin_cross_ref_type
7368: AND mcr.cross_reference LIKE g_crossref
7369: )

Line 7515: ,mtl_cross_references mcr

7511: msi.stock_enabled_flag,
7512: ' ',
7513: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
7514: from mtl_system_items_vl msi /* Bug 5581528 */
7515: ,mtl_cross_references mcr
7516: WHERE msi.organization_id = p_Organization_Id
7517: and ( mcr.cross_reference_type = g_gtin_cross_ref_type
7518: AND mcr.cross_reference LIKE g_crossref
7519: )

Line 7773: mtl_cross_references mcr,

7769: to_char(rsl1.shipment_header_id) -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
7770: FROM mtl_system_items_vl msi
7771: /* Bug 5581528 */
7772: ,
7773: mtl_cross_references mcr,
7774: -- This Select clause added by Bug9257750 to fetch the values of Shipment Number and Shipment Header id
7775: (
7776: SELECT rsl.Item_Id,rsh.shipment_num shipment_num,
7777: rsh.shipment_header_id shipment_header_id

Line 8125: mtl_cross_references mcr

8121: ' ',
8122: ' ' -- Added by Bug9257750 for values corr to Shipment Number and Shipment Header id
8123: FROM
8124: mtl_system_items_vl msi, /* Bug 5581528 */
8125: mtl_cross_references mcr
8126: WHERE msi.organization_id = p_organization_Id
8127: AND ( (mcr.cross_reference_type = p_crossreftype
8128: AND mcr.cross_reference LIKE p_concatenated_segments
8129: ) OR

Line 8341: mtl_cross_references mcr

8337: NVL(TRACKING_QUANTITY_IND,'P'),
8338: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8339: NVL(DUAL_UOM_DEVIATION_LOW,0)
8340: from mtl_system_items_vl msik, /* Bug 5581528 */
8341: mtl_cross_references mcr
8342: WHERE msik.organization_id = p_Organization_Id
8343: AND msik.inventory_item_id = mcr.inventory_item_id
8344: AND mcr.cross_reference_type = g_gtin_cross_ref_type
8345: AND mcr.cross_reference LIKE g_crossref

Line 8669: mtl_cross_references mcr

8665: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8666: NVL(DUAL_UOM_DEVIATION_LOW,0)
8667: FROM
8668: mtl_system_items_vl msik, /* Bug 5581528 */
8669: mtl_cross_references mcr
8670: WHERE
8671: msik.organization_id = p_organization_id
8672: AND msik.inventory_item_id = mcr.inventory_item_id
8673: AND mcr.cross_reference_type = g_gtin_cross_ref_type

Line 8792: mtl_cross_references mcr

8788: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8789: NVL(DUAL_UOM_DEVIATION_LOW,0)
8790: FROM
8791: mtl_system_items_vl msik, /* Bug 5581528 */
8792: mtl_cross_references mcr
8793: WHERE
8794: msik.organization_id = p_organization_id
8795: AND msik.inventory_item_id = mcr.inventory_item_id
8796: AND mcr.cross_reference_type = g_gtin_cross_ref_type

Line 8909: mtl_cross_references mcr

8905: NVL(DUAL_UOM_DEVIATION_HIGH,0),
8906: NVL(DUAL_UOM_DEVIATION_LOW,0)
8907: FROM
8908: mtl_system_items_vl msik, /* Bug 5581528 */
8909: mtl_cross_references mcr
8910: WHERE
8911: msik.organization_id = p_organization_id
8912: AND msik.inventory_item_id = mcr.inventory_item_id
8913: AND mcr.cross_reference_type = g_gtin_cross_ref_type

Line 9026: mtl_cross_references mcr

9022: NVL(DUAL_UOM_DEVIATION_HIGH,0),
9023: NVL(DUAL_UOM_DEVIATION_LOW,0)
9024: FROM
9025: mtl_system_items_vl msik, /* Bug 5581528 */
9026: mtl_cross_references mcr
9027: WHERE
9028: msik.organization_id = p_organization_id
9029: AND msik.inventory_item_id = mcr.inventory_item_id
9030: AND mcr.cross_reference_type = g_gtin_cross_ref_type

Line 9144: mtl_cross_references mcr

9140: NVL(DUAL_UOM_DEVIATION_HIGH,0),
9141: NVL(DUAL_UOM_DEVIATION_LOW,0)
9142: FROM
9143: mtl_system_items_vl msik, /* Bug 5581528 */
9144: mtl_cross_references mcr
9145: WHERE
9146: msik.organization_id = p_organization_id
9147: AND msik.inventory_item_id = mcr.inventory_item_id
9148: AND mcr.cross_reference_type = g_gtin_cross_ref_type

Line 9265: mtl_cross_references mcr

9261: NVL(DUAL_UOM_DEVIATION_HIGH,0),
9262: NVL(DUAL_UOM_DEVIATION_LOW,0)
9263: FROM
9264: mtl_system_items_vl msik, /* Bug 5581528 */
9265: mtl_cross_references mcr
9266: WHERE
9267: msik.organization_id = p_organization_id
9268: AND msik.inventory_item_id = mcr.inventory_item_id
9269: AND mcr.cross_reference_type = g_gtin_cross_ref_type

Line 9386: mtl_cross_references mcr

9382: NVL(DUAL_UOM_DEVIATION_HIGH,0),
9383: NVL(DUAL_UOM_DEVIATION_LOW,0)
9384: FROM
9385: mtl_system_items_vl msik, /* Bug 5581528 */
9386: mtl_cross_references mcr
9387: WHERE
9388: msik.organization_id = p_organization_id
9389: AND msik.inventory_item_id = mcr.inventory_item_id
9390: AND mcr.cross_reference_type = g_gtin_cross_ref_type