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_SYSTEM_ITEMS_KFV

Line 132: , mtl_system_items_kfv msi

128: , msi.outside_operation_flag
129: , mum.uom_code
130: from po_lines_all pl
131: , mtl_units_of_measure mum
132: , mtl_system_items_kfv msi
133: where pl.item_id = msi.inventory_item_id (+)
134: and mum.UNIT_OF_MEASURE(+) = pl.UNIT_MEAS_LOOKUP_CODE
135: and Nvl(msi.organization_id, p_organization_id) = p_organization_id
136: and pl.po_header_id = p_po_header_id

Line 161: , mtl_system_items_kfv msi

157: , msi.outside_operation_flag
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

Line 200: , mtl_system_items_kfv msi

196: , mum.uom_code
197: FROM rcv_supply rsup
198: , mtl_units_of_measure mum
199: , po_lines_all pl
200: , mtl_system_items_kfv msi
201: WHERE rsup.po_line_id = pl.po_line_id
202: and mum.UNIT_OF_MEASURE(+) = pl.UNIT_MEAS_LOOKUP_CODE
203: AND pl.item_id = msi.inventory_item_id (+)
204: and Nvl(msi.organization_id, p_organization_id) = p_organization_id

Line 691: , mtl_system_items_kfv msi

687: AND NVL(POH.CLOSED_CODE, 'OPEN') NOT IN ('CLOSED', 'FINALLY CLOSED','CLOSED FOR RECEIVING', 'CLOSED') -- 3152693
688: AND poh.segment1 LIKE (p_doc_number)
689: AND exists ( select 'x'
690: from po_lines_all pl
691: , mtl_system_items_kfv msi
692: where pl.item_id = msi.inventory_item_id (+)
693: and Nvl(msi.organization_id, p_organization_id) = p_organization_id
694: and pl.po_header_id = poh.po_header_id
695: AND Nvl(pl.vendor_product_num,' ') =

Line 742: , mtl_system_items_kfv msi

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
746: and msi.inventory_item_id like p_inventory_item_id ) or

Line 899: from mtl_system_items_kfv

895: inventory_item_flag,
896: 0,
897: inventory_asset_flag,
898: outside_operation_flag
899: from mtl_system_items_kfv
900: WHERE organization_id = p_Organization_Id
901: and concatenated_segments like p_concatenated_segments
902: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
903: and inventory_item_id IN (SELECT pol.item_id FROM po_lines_all pol

Line 952: ,mtl_system_items_kfv msi

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
956: and pol.po_header_id = p_poHeaderID

Line 953: ,mtl_system_items_kfv msia

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
956: and pol.po_header_id = p_poHeaderID
957: and pol.item_id = msia.inventory_item_id

Line 1011: , mtl_system_items_kfv msi

1007: 0,
1008: msi.inventory_asset_flag,
1009: msi.outside_operation_flag
1010: from po_lines_all pol
1011: , mtl_system_items_kfv msi
1012: where organization_id = p_organization_id
1013: and pol.vendor_product_num like p_concatenated_segments
1014: and pol.item_id = msi.inventory_item_id
1015: and pol.vendor_product_num IS NOT NULL

Line 1116: ,mtl_system_items_kfv msi

1112: 0,
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

Line 1184: from mtl_system_items_kfv

1180: inventory_item_flag,
1181: 0,
1182: inventory_asset_flag,
1183: outside_operation_flag
1184: from mtl_system_items_kfv
1185: WHERE organization_id = p_Organization_Id
1186: and concatenated_segments like p_concatenated_segments
1187: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
1188: and inventory_item_id IN (SELECT pol.item_id FROM po_lines_all pol WHERE

Line 1238: ,mtl_system_items_kfv msi

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
1242: and pol.po_header_id = p_poHeaderID

Line 1239: ,mtl_system_items_kfv msia

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
1242: and pol.po_header_id = p_poHeaderID
1243: and pol.item_id = msia.inventory_item_id

Line 1298: , mtl_system_items_kfv msi

1294: 0,
1295: msi.inventory_asset_flag,
1296: msi.outside_operation_flag
1297: from po_lines_all pol
1298: , mtl_system_items_kfv msi
1299: where organization_id = p_organization_id
1300: and pol.vendor_product_num like p_concatenated_segments
1301: and pol.item_id = msi.inventory_item_id
1302: and pol.vendor_product_num IS NOT NULL

Line 1405: ,mtl_system_items_kfv msi

1401: 0,
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

Line 1473: from mtl_system_items_kfv

1469: inventory_item_flag,
1470: 0,
1471: inventory_asset_flag,
1472: outside_operation_flag
1473: from mtl_system_items_kfv
1474: WHERE organization_id = p_Organization_Id
1475: and concatenated_segments like p_concatenated_segments
1476: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
1477: and inventory_item_id IN

Line 1526: ,mtl_system_items_kfv msi

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
1530: and pol.po_header_id = p_poHeaderID

Line 1527: ,mtl_system_items_kfv msia

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
1530: and pol.po_header_id = p_poHeaderID
1531: and pol.item_id = msia.inventory_item_id

Line 1585: , mtl_system_items_kfv msi

1581: 0,
1582: msi.inventory_asset_flag,
1583: msi.outside_operation_flag
1584: from po_lines_all pol
1585: , mtl_system_items_kfv msi
1586: where organization_id = p_organization_id
1587: and pol.vendor_product_num like p_concatenated_segments
1588: and pol.item_id = msi.inventory_item_id
1589: and pol.vendor_product_num IS NOT NULL

Line 1691: ,mtl_system_items_kfv msi

1687: 0,
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

Line 1766: from mtl_system_items_kfv

1762: inventory_item_flag,
1763: 0,
1764: inventory_asset_flag,
1765: outside_operation_flag
1766: from mtl_system_items_kfv
1767: WHERE organization_id = p_Organization_Id
1768: and concatenated_segments like p_concatenated_segments
1769: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
1770: and inventory_item_id IN (SELECT pol.item_id FROM po_lines_all pol

Line 1812: ,mtl_system_items_kfv msi

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
1816: and pol.po_header_id = p_poHeaderID

Line 1813: ,mtl_system_items_kfv msia

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
1816: and pol.po_header_id = p_poHeaderID
1817: and pol.item_id = msia.inventory_item_id

Line 1864: , mtl_system_items_kfv msi

1860: 0,
1861: msi.inventory_asset_flag,
1862: msi.outside_operation_flag
1863: from po_lines_all pol
1864: , mtl_system_items_kfv msi
1865: where organization_id = p_organization_id
1866: and pol.vendor_product_num like p_concatenated_segments
1867: and pol.item_id = msi.inventory_item_id
1868: and pol.vendor_product_num IS NOT NULL

Line 1955: ,mtl_system_items_kfv msi

1951: 0,
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

Line 2015: from mtl_system_items_kfv

2011: inventory_item_flag,
2012: 0,
2013: inventory_asset_flag,
2014: outside_operation_flag
2015: from mtl_system_items_kfv
2016: WHERE organization_id = p_Organization_Id
2017: and concatenated_segments like p_concatenated_segments
2018: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
2019: and inventory_item_id IN (SELECT pl.item_id FROM po_lines_all pl WHERE

Line 2062: ,mtl_system_items_kfv msi

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
2066: and pol.po_header_id = p_poHeaderID

Line 2063: ,mtl_system_items_kfv msia

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
2066: and pol.po_header_id = p_poHeaderID
2067: and pol.item_id = msia.inventory_item_id

Line 2113: ,mtl_system_items_kfv msi

2109: 0,
2110: msi.inventory_asset_flag,
2111: msi.outside_operation_flag
2112: from po_lines_all pol
2113: ,mtl_system_items_kfv msi
2114: where organization_id = p_organization_id
2115: and pol.vendor_product_num like p_concatenated_segments
2116: and pol.item_id = msi.inventory_item_id
2117: and pol.vendor_product_num IS NOT NULL

Line 2205: ,mtl_system_items_kfv msi

2201: 0,
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

Line 2266: from mtl_system_items_kfv

2262: inventory_item_flag,
2263: 0,
2264: inventory_asset_flag,
2265: outside_operation_flag
2266: from mtl_system_items_kfv
2267: WHERE organization_id = p_Organization_Id
2268: and concatenated_segments like p_concatenated_segments
2269: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
2270: and inventory_item_id IN

Line 2311: ,mtl_system_items_kfv msi

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
2315: and pol.po_header_id = p_poHeaderID

Line 2312: ,mtl_system_items_kfv msia

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
2315: and pol.po_header_id = p_poHeaderID
2316: and pol.item_id = msia.inventory_item_id

Line 2362: , mtl_system_items_kfv msi

2358: 0,
2359: msi.inventory_asset_flag,
2360: msi.outside_operation_flag
2361: from po_lines_all pol
2362: , mtl_system_items_kfv msi
2363: where organization_id = p_organization_id
2364: and pol.vendor_product_num like p_concatenated_segments
2365: and pol.item_id = msi.inventory_item_id
2366: and pol.vendor_product_num IS NOT NULL

Line 2454: ,mtl_system_items_kfv msi

2450: 0,
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

Line 2526: from mtl_system_items_kfv msn,

2522: inventory_item_flag,
2523: 0,
2524: inventory_asset_flag,
2525: outside_operation_flag
2526: from mtl_system_items_kfv msn,
2527: rcv_shipment_lines rsl
2528: WHERE msn.organization_id = p_Organization_Id
2529: and msn.concatenated_segments like p_concatenated_segments
2530: and (msn.purchasing_enabled_flag = 'Y' OR msn.stock_enabled_flag = 'Y')

Line 2568: ,mtl_system_items_kfv msi

2564: 0,
2565: msi.inventory_asset_flag,
2566: msi.outside_operation_flag
2567: from po_lines_all pol
2568: ,mtl_system_items_kfv msi
2569: , rcv_shipment_lines rsl
2570: where organization_id = p_Organization_Id
2571: and pol.vendor_product_num like p_concatenated_segments
2572: and pol.item_id = msi.inventory_item_id

Line 2671: from mtl_system_items_kfv msn,

2667: msn.inventory_item_flag,
2668: 0,
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

Line 2726: from mtl_system_items_kfv

2722: inventory_item_flag,
2723: 0,
2724: inventory_asset_flag,
2725: outside_operation_flag
2726: from mtl_system_items_kfv
2727: WHERE organization_id = p_Organization_Id
2728: and concatenated_segments like p_concatenated_segments
2729: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
2730: and inventory_item_id IN (SELECT oel.inventory_item_id FROM

Line 2765: from mtl_system_items_kfv msi

2761: msi.inventory_item_flag,
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

Line 2820: from mtl_system_items_kfv

2816: inventory_item_flag,
2817: 0,
2818: inventory_asset_flag,
2819: outside_operation_flag
2820: from mtl_system_items_kfv
2821: WHERE organization_id = p_Organization_Id
2822: and concatenated_segments like p_concatenated_segments
2823: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
2824: and exists (SELECT 1 FROM po_requisition_lines_all prl,

Line 2863: from mtl_system_items_kfv msi

2859: msi.inventory_item_flag,
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

Line 2923: from mtl_system_items_kfv

2919: inventory_item_flag,
2920: 0,
2921: inventory_asset_flag,
2922: outside_operation_flag
2923: from mtl_system_items_kfv
2924: WHERE organization_id = p_Organization_Id
2925: and concatenated_segments like p_concatenated_segments
2926: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
2927: UNION

Line 2958: ,mtl_system_items_kfv msi

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
2962: and pol.item_id = msia.inventory_item_id

Line 2959: ,mtl_system_items_kfv msia

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
2962: and pol.item_id = msia.inventory_item_id
2963: and msia.organization_id = p_organization_id

Line 3009: ,mtl_system_items_kfv msi

3005: 0,
3006: msi.inventory_asset_flag,
3007: msi.outside_operation_flag
3008: from po_lines_all pol
3009: ,mtl_system_items_kfv msi
3010: where organization_id = p_organization_id
3011: and (purchasing_enabled_flag = 'Y' OR stock_enabled_flag = 'Y')
3012: and pol.vendor_product_num like p_concatenated_segments
3013: and pol.item_id = msi.inventory_item_id

Line 3047: mtl_system_items_kfv msi

3043: 0,
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