DBA Data[Home] [Help]

APPS.GMD_SAMPLES_PUB dependencies on PO_LINES_ALL

Line 2163: FROM po_lines_all pla

2159: SELECT 1
2160: FROM po_headers_all pha
2161: WHERE pha.po_header_id IN
2162: (SELECT pla.po_header_id
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

Line 2176: FROM po_lines_all pla

2172: AND pha.po_header_id = p_sample_rec.po_header_id;
2173:
2174: CURSOR c_po_line IS
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