DBA Data[Home] [Help]

APPS.GMD_SAMPLES_PUB dependencies on PO_LINES_ALL

Line 2293: FROM po_lines_all pla

2289: SELECT 1
2290: FROM po_headers_all pha
2291: WHERE pha.po_header_id IN
2292: (SELECT pla.po_header_id
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

Line 2306: FROM po_lines_all pla

2302: AND pha.po_header_id = p_sample_rec.po_header_id;
2303:
2304: CURSOR c_po_line IS
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