DBA Data[Home] [Help]

APPS.GMD_SAMPLES_PUB dependencies on MTL_SYSTEM_ITEMS

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

839: l_qc_samples_out_rec.sample_inv_trans_ind = 'Y' THEN
840:
841: -- bug# 2995114
842: -- added code to get whse for wip sample.
843: -- bug 4165704: source subinventory is now retrieved from mtl_system_items
844: --IF l_qc_samples_out_rec.source_whse IS NULL THEN
845: -- Get Replenish Warehouse for item and/or plant
846: -- OPEN Cur_replenish_whse(l_qc_samples_out_rec.inventory_item_id);
847: -- FETCH Cur_replenish_whse INTO l_qc_samples_out_rec.source_whse ;

Line 1969: FROM mtl_system_items msi

1965: , oe_transaction_types_tl ttt
1966: WHERE oola.header_id = oha.header_id
1967: AND oola.inventory_item_id IN
1968: (SELECT msi.inventory_item_id
1969: FROM mtl_system_items msi
1970: WHERE msi.segment1 IN
1971: (SELECT segment1
1972: FROM mtl_system_items_b
1973: WHERE inventory_item_id = p_sample_rec.inventory_item_id))

Line 1972: FROM mtl_system_items_b

1968: (SELECT msi.inventory_item_id
1969: FROM mtl_system_items msi
1970: WHERE msi.segment1 IN
1971: (SELECT segment1
1972: FROM mtl_system_items_b
1973: WHERE inventory_item_id = p_sample_rec.inventory_item_id))
1974: AND oha.order_type_id = ttt.transaction_type_id
1975: AND NVL( p_sample_rec.ship_to_site_id, oola.ship_to_org_id) = oola.ship_to_org_id
1976: AND NVL( p_sample_rec.organization_id, oha.org_id) = oha.org_id

Line 2007: FROM mtl_system_items msi

2003: WHERE oola.header_id = p_sample_rec.order_id
2004: AND NVL( p_sample_rec.ship_to_site_id, oola.ship_to_org_id) = oola.ship_to_org_id
2005: AND oola.inventory_item_id IN
2006: (SELECT msi.inventory_item_id
2007: FROM mtl_system_items msi
2008: WHERE msi.segment1 IN
2009: (SELECT segment1
2010: FROM mtl_system_items_b
2011: WHERE inventory_item_id = p_sample_rec.inventory_item_id))

Line 2010: FROM mtl_system_items_b

2006: (SELECT msi.inventory_item_id
2007: FROM mtl_system_items msi
2008: WHERE msi.segment1 IN
2009: (SELECT segment1
2010: FROM mtl_system_items_b
2011: WHERE inventory_item_id = p_sample_rec.inventory_item_id))
2012: AND oola.header_id = p_sample_rec.order_id
2013: AND oola.line_id = p_sample_rec.order_line_id;
2014:

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

2152: AND v.vendor_id = p_sample_rec.supplier_id
2153: AND v.vendor_site_id = p_sample_rec.supplier_site_id;
2154:
2155: -- Bug# 5226352
2156: -- Changed mtl_system_items to mtl_system_items_b and added organization_id where clause for msi to fix performance issues
2157: CURSOR c_po
2158: IS
2159: SELECT 1
2160: FROM po_headers_all pha

Line 2167: FROM mtl_system_items_b msi

2163: FROM po_lines_all pla
2164: WHERE pla.po_header_id = pha.po_header_id
2165: AND pla.item_id IN
2166: (SELECT msi.inventory_item_id
2167: FROM mtl_system_items_b msi
2168: WHERE organization_id = p_sample_rec.organization_id
2169: AND inventory_item_id = p_sample_rec.inventory_item_id))
2170: AND pha.vendor_id = p_sample_rec.supplier_id
2171: AND pha.vendor_site_id = p_sample_rec.supplier_site_id

Line 2179: FROM mtl_system_items msi

2175: SELECT 1
2176: FROM po_lines_all pla
2177: WHERE pla.item_id IN
2178: (SELECT msi.inventory_item_id
2179: FROM mtl_system_items msi
2180: WHERE msi.segment1 IN
2181: (SELECT segment1
2182: FROM mtl_system_items_b
2183: WHERE inventory_item_id = p_sample_rec.inventory_item_id))

Line 2182: FROM mtl_system_items_b

2178: (SELECT msi.inventory_item_id
2179: FROM mtl_system_items msi
2180: WHERE msi.segment1 IN
2181: (SELECT segment1
2182: FROM mtl_system_items_b
2183: WHERE inventory_item_id = p_sample_rec.inventory_item_id))
2184: AND pla.po_header_id = p_sample_rec.po_header_id
2185: AND pla.po_line_id = p_sample_rec.po_line_id;
2186:

Line 2199: FROM mtl_system_items msi

2195: FROM rcv_shipment_lines rsl
2196: WHERE rsl.po_header_id = p_sample_rec.po_header_id
2197: AND rsl.item_id IN
2198: (SELECT msi.inventory_item_id
2199: FROM mtl_system_items msi
2200: WHERE msi.segment1 IN
2201: (SELECT segment1
2202: FROM mtl_system_items_b
2203: WHERE inventory_item_id = p_sample_rec.inventory_item_id))

Line 2202: FROM mtl_system_items_b

2198: (SELECT msi.inventory_item_id
2199: FROM mtl_system_items msi
2200: WHERE msi.segment1 IN
2201: (SELECT segment1
2202: FROM mtl_system_items_b
2203: WHERE inventory_item_id = p_sample_rec.inventory_item_id))
2204: AND rsl.po_line_id = p_sample_rec.po_line_id
2205: AND rsl.shipment_header_id = rsh.shipment_header_id);*/
2206:

Line 2705: FROM mtl_system_items_b

2701:
2702: -- bug 5291495
2703: CURSOR uom is
2704: SELECT PRIMARY_UOM_CODE
2705: FROM mtl_system_items_b
2706: WHERE organization_id = p_sample_rec.organization_id
2707: AND inventory_item_id = p_sample_rec.inventory_item_id;
2708: l_uom mtl_units_of_measure.uom_code%TYPE;
2709: l_test_qty number;