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.GMD_SAMPLES_PUB dependencies on MTL_SYSTEM_ITEMS

Line 927: -- bug 4165704: source subinventory is now retrieved from mtl_system_items

923: l_qc_samples_out_rec.sample_inv_trans_ind = 'Y' THEN
924:
925: -- bug# 2995114
926: -- added code to get whse for wip sample.
927: -- bug 4165704: source subinventory is now retrieved from mtl_system_items
928: --IF l_qc_samples_out_rec.source_whse IS NULL THEN
929: -- Get Replenish Warehouse for item and/or plant
930: -- OPEN Cur_replenish_whse(l_qc_samples_out_rec.inventory_item_id);
931: -- FETCH Cur_replenish_whse INTO l_qc_samples_out_rec.source_whse ;

Line 2099: FROM mtl_system_items msi

2095: , oe_transaction_types_tl ttt
2096: WHERE oola.header_id = oha.header_id
2097: AND oola.inventory_item_id IN
2098: (SELECT msi.inventory_item_id
2099: FROM mtl_system_items msi
2100: WHERE msi.segment1 IN
2101: (SELECT segment1
2102: FROM mtl_system_items_b
2103: WHERE inventory_item_id = p_sample_rec.inventory_item_id))

Line 2102: FROM mtl_system_items_b

2098: (SELECT msi.inventory_item_id
2099: FROM mtl_system_items msi
2100: WHERE msi.segment1 IN
2101: (SELECT segment1
2102: FROM mtl_system_items_b
2103: WHERE inventory_item_id = p_sample_rec.inventory_item_id))
2104: AND oha.order_type_id = ttt.transaction_type_id
2105: AND NVL( p_sample_rec.ship_to_site_id, oola.ship_to_org_id) = oola.ship_to_org_id
2106: AND NVL( p_sample_rec.organization_id, oha.org_id) = oha.org_id

Line 2137: FROM mtl_system_items msi

2133: WHERE oola.header_id = p_sample_rec.order_id
2134: AND NVL( p_sample_rec.ship_to_site_id, oola.ship_to_org_id) = oola.ship_to_org_id
2135: AND oola.inventory_item_id IN
2136: (SELECT msi.inventory_item_id
2137: FROM mtl_system_items msi
2138: WHERE msi.segment1 IN
2139: (SELECT segment1
2140: FROM mtl_system_items_b
2141: WHERE inventory_item_id = p_sample_rec.inventory_item_id))

Line 2140: FROM mtl_system_items_b

2136: (SELECT msi.inventory_item_id
2137: FROM mtl_system_items msi
2138: WHERE msi.segment1 IN
2139: (SELECT segment1
2140: FROM mtl_system_items_b
2141: WHERE inventory_item_id = p_sample_rec.inventory_item_id))
2142: AND oola.header_id = p_sample_rec.order_id
2143: AND oola.line_id = p_sample_rec.order_line_id;
2144:

Line 2286: -- Changed mtl_system_items to mtl_system_items_b and added organization_id where clause for msi to fix performance issues

2282: AND v.vendor_id = p_sample_rec.supplier_id
2283: AND v.vendor_site_id = p_sample_rec.supplier_site_id;
2284:
2285: -- Bug# 5226352
2286: -- Changed mtl_system_items to mtl_system_items_b and added organization_id where clause for msi to fix performance issues
2287: CURSOR c_po
2288: IS
2289: SELECT 1
2290: FROM po_headers_all pha

Line 2297: FROM mtl_system_items_b msi

2293: FROM po_lines_all pla
2294: WHERE pla.po_header_id = pha.po_header_id
2295: AND pla.item_id IN
2296: (SELECT msi.inventory_item_id
2297: FROM mtl_system_items_b msi
2298: WHERE organization_id = p_sample_rec.organization_id
2299: AND inventory_item_id = p_sample_rec.inventory_item_id))
2300: AND pha.vendor_id = p_sample_rec.supplier_id
2301: AND pha.vendor_site_id = p_sample_rec.supplier_site_id

Line 2309: FROM mtl_system_items msi

2305: SELECT 1
2306: FROM po_lines_all pla
2307: WHERE pla.item_id IN
2308: (SELECT msi.inventory_item_id
2309: FROM mtl_system_items msi
2310: WHERE msi.segment1 IN
2311: (SELECT segment1
2312: FROM mtl_system_items_b
2313: WHERE inventory_item_id = p_sample_rec.inventory_item_id))

Line 2312: FROM mtl_system_items_b

2308: (SELECT msi.inventory_item_id
2309: FROM mtl_system_items msi
2310: WHERE msi.segment1 IN
2311: (SELECT segment1
2312: FROM mtl_system_items_b
2313: WHERE inventory_item_id = p_sample_rec.inventory_item_id))
2314: AND pla.po_header_id = p_sample_rec.po_header_id
2315: AND pla.po_line_id = p_sample_rec.po_line_id;
2316:

Line 2329: FROM mtl_system_items msi

2325: FROM rcv_shipment_lines rsl
2326: WHERE rsl.po_header_id = p_sample_rec.po_header_id
2327: AND rsl.item_id IN
2328: (SELECT msi.inventory_item_id
2329: FROM mtl_system_items msi
2330: WHERE msi.segment1 IN
2331: (SELECT segment1
2332: FROM mtl_system_items_b
2333: WHERE inventory_item_id = p_sample_rec.inventory_item_id))

Line 2332: FROM mtl_system_items_b

2328: (SELECT msi.inventory_item_id
2329: FROM mtl_system_items msi
2330: WHERE msi.segment1 IN
2331: (SELECT segment1
2332: FROM mtl_system_items_b
2333: WHERE inventory_item_id = p_sample_rec.inventory_item_id))
2334: AND rsl.po_line_id = p_sample_rec.po_line_id
2335: AND rsl.shipment_header_id = rsh.shipment_header_id);*/
2336:

Line 2835: FROM mtl_system_items_b

2831:
2832: -- bug 5291495
2833: CURSOR uom is
2834: SELECT PRIMARY_UOM_CODE
2835: FROM mtl_system_items_b
2836: WHERE organization_id = p_sample_rec.organization_id
2837: AND inventory_item_id = p_sample_rec.inventory_item_id;
2838: l_uom mtl_units_of_measure.uom_code%TYPE;
2839: l_test_qty number;