APPS.GMD_SAMPLES_PUB dependencies on MTL_SYSTEM_ITEMS_B

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 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 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 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;