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_RELATED_ITEMS

Line 162: , mtl_related_items mri

158: , mum.uom_code
159: from po_lines_all pl
160: , mtl_units_of_measure mum
161: , mtl_system_items_kfv msi
162: , mtl_related_items mri
163: where Nvl(msi.organization_id, p_organization_id) = p_organization_id
164: and mum.UNIT_OF_MEASURE(+) = pl.UNIT_MEAS_LOOKUP_CODE
165: and pl.po_header_id = p_po_header_id
166: and exists (SELECT 'Valid PO Shipments'

Line 741: , mtl_related_items mri

737: AND NVL(POH.CLOSED_CODE, 'OPEN') NOT IN ('CLOSED', 'FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3152693
738: AND poh.segment1 LIKE (p_doc_number)
739: AND exists ( select 'x'
740: from po_lines_all pl
741: , mtl_related_items mri
742: , mtl_system_items_kfv msi
743: Where msi.organization_id = p_organization_id
744: and (( mri.related_item_id = msi.inventory_item_id
745: and pl.item_id = mri.inventory_item_id

Line 951: ,mtl_related_items mri

947: 0,
948: msi.inventory_asset_flag,
949: msi.outside_operation_flag
950: from po_lines_all pol
951: ,mtl_related_items mri
952: ,mtl_system_items_kfv msi
953: ,mtl_system_items_kfv msia
954: where msi.organization_id = p_organization_id
955: and msi.concatenated_segments like p_concatenated_segments

Line 1237: ,mtl_related_items mri

1233: 0,
1234: msi.inventory_asset_flag,
1235: msi.outside_operation_flag
1236: from po_lines_all pol
1237: ,mtl_related_items mri
1238: ,mtl_system_items_kfv msi
1239: ,mtl_system_items_kfv msia
1240: where msi.organization_id = p_organization_id
1241: and msi.concatenated_segments like p_concatenated_segments

Line 1525: ,mtl_related_items mri

1521: 0,
1522: msi.inventory_asset_flag,
1523: msi.outside_operation_flag
1524: from po_lines_all pol
1525: ,mtl_related_items mri
1526: ,mtl_system_items_kfv msi
1527: ,mtl_system_items_kfv msia
1528: where msi.organization_id = p_organization_id
1529: and msi.concatenated_segments like p_concatenated_segments

Line 1811: ,mtl_related_items mri

1807: 0,
1808: msi.inventory_asset_flag,
1809: msi.outside_operation_flag
1810: from po_lines_all pol
1811: ,mtl_related_items mri
1812: ,mtl_system_items_kfv msi
1813: ,mtl_system_items_kfv msia
1814: where msi.organization_id = p_organization_id
1815: and msi.concatenated_segments like p_concatenated_segments

Line 2061: ,mtl_related_items mri

2057: 0,
2058: msi.inventory_asset_flag,
2059: msi.outside_operation_flag
2060: from po_lines_all pol
2061: ,mtl_related_items mri
2062: ,mtl_system_items_kfv msi
2063: ,mtl_system_items_kfv msia
2064: where msi.organization_id = p_organization_id
2065: and msi.concatenated_segments like p_concatenated_segments

Line 2310: ,mtl_related_items mri

2306: 0,
2307: msi.inventory_asset_flag,
2308: msi.outside_operation_flag
2309: from po_lines_all pol
2310: ,mtl_related_items mri
2311: ,mtl_system_items_kfv msi
2312: ,mtl_system_items_kfv msia
2313: where msi.organization_id = p_organization_id
2314: and msi.concatenated_segments like p_concatenated_segments

Line 2957: ,mtl_related_items mri

2953: 0,
2954: msi.inventory_asset_flag,
2955: msi.outside_operation_flag
2956: from po_lines_all pol
2957: ,mtl_related_items mri
2958: ,mtl_system_items_kfv msi
2959: ,mtl_system_items_kfv msia
2960: where msi.organization_id = p_organization_id
2961: and msi.concatenated_segments like p_concatenated_segments