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.GML_MOBILE_RECEIPT dependencies on MTL_CROSS_REFERENCES

Line 1117: ,mtl_cross_references mcr

1113: msi.inventory_asset_flag,
1114: msi.outside_operation_flag
1115: from po_lines_all pol
1116: ,mtl_system_items_kfv msi
1117: ,mtl_cross_references mcr
1118: where msi.organization_id = p_organization_id
1119: and ( (mcr.cross_reference_type = p_crossreftype
1120: and mcr.cross_reference like p_concatenated_segments
1121: ) or

Line 1406: ,mtl_cross_references mcr

1402: msi.inventory_asset_flag,
1403: msi.outside_operation_flag
1404: from po_lines_all pol
1405: ,mtl_system_items_kfv msi
1406: ,mtl_cross_references mcr
1407: where msi.organization_id = p_organization_id
1408: and ( (mcr.cross_reference_type = p_crossreftype
1409: and mcr.cross_reference like p_concatenated_segments
1410: ) or

Line 1692: ,mtl_cross_references mcr

1688: msi.inventory_asset_flag,
1689: msi.outside_operation_flag
1690: from po_lines_all pol
1691: ,mtl_system_items_kfv msi
1692: ,mtl_cross_references mcr
1693: where msi.organization_id = p_organization_id
1694: and ( (mcr.cross_reference_type = p_crossreftype
1695: and mcr.cross_reference like p_concatenated_segments
1696: ) or

Line 1956: ,mtl_cross_references mcr

1952: msi.inventory_asset_flag,
1953: msi.outside_operation_flag
1954: from po_lines_all pol
1955: ,mtl_system_items_kfv msi
1956: ,mtl_cross_references mcr
1957: where msi.organization_id = p_organization_id
1958: and ( (mcr.cross_reference_type = p_crossreftype
1959: and mcr.cross_reference like p_concatenated_segments
1960: ) or

Line 2206: ,mtl_cross_references mcr

2202: msi.inventory_asset_flag,
2203: msi.outside_operation_flag
2204: from po_lines_all pol
2205: ,mtl_system_items_kfv msi
2206: ,mtl_cross_references mcr
2207: where msi.organization_id = p_organization_id
2208: and ( (mcr.cross_reference_type = p_crossreftype
2209: and mcr.cross_reference like p_concatenated_segments
2210: ) or

Line 2455: ,mtl_cross_references mcr

2451: msi.inventory_asset_flag,
2452: msi.outside_operation_flag
2453: from po_lines_all pol
2454: ,mtl_system_items_kfv msi
2455: ,mtl_cross_references mcr
2456: where msi.organization_id = p_organization_id
2457: and ( (mcr.cross_reference_type = p_crossreftype
2458: and mcr.cross_reference like p_concatenated_segments
2459: ) or

Line 2673: mtl_cross_references mcr

2669: msn.inventory_asset_flag,
2670: msn.outside_operation_flag
2671: from mtl_system_items_kfv msn,
2672: rcv_shipment_lines rsl,
2673: mtl_cross_references mcr
2674: WHERE msn.organization_id = p_Organization_Id
2675: and ( mcr.cross_reference_type = g_gtin_cross_ref_type
2676: AND mcr.cross_reference LIKE g_crossref
2677: )

Line 2766: ,mtl_cross_references mcr

2762: 0,
2763: msi.inventory_asset_flag,
2764: msi.outside_operation_flag
2765: from mtl_system_items_kfv msi
2766: ,mtl_cross_references mcr
2767: WHERE msi.organization_id = p_Organization_Id
2768: and ( mcr.cross_reference_type = g_gtin_cross_ref_type
2769: AND mcr.cross_reference LIKE g_crossref
2770: )

Line 2864: ,mtl_cross_references mcr

2860: 0,
2861: msi.inventory_asset_flag,
2862: msi.outside_operation_flag
2863: from mtl_system_items_kfv msi
2864: ,mtl_cross_references mcr
2865: WHERE msi.organization_id = p_Organization_Id
2866: and ( mcr.cross_reference_type = g_gtin_cross_ref_type
2867: AND mcr.cross_reference LIKE g_crossref
2868: )

Line 3048: ,mtl_cross_references mcr

3044: msi.inventory_asset_flag,
3045: msi.outside_operation_flag
3046: from
3047: mtl_system_items_kfv msi
3048: ,mtl_cross_references mcr
3049: where msi.organization_id = p_organization_id
3050: and ( (mcr.cross_reference_type = p_crossreftype
3051: and mcr.cross_reference like p_concatenated_segments
3052: ) or