DBA Data[Home] [Help]

APPS.INV_UI_TASK_LOVS dependencies on PO_LINES_ALL

Line 173: FROM po_lines_all pol

169: AND pod.project_id = p_project_id
170: AND t.project_id = p_project_id
171: AND ( p_item_id IS NULL
172: OR ( pod.po_line_id IN ( SELECT pol.po_line_id
173: FROM po_lines_all pol
174: WHERE pol.item_id = p_item_id ) )
175: )
176: AND ( p_po_release_id IS NULL
177: OR ( pod.po_release_id = p_po_release_id)

Line 227: FROM po_lines_all pol

223: AND pod.project_id = p_project_id
224: AND t.project_id = p_project_id
225: AND ( p_item_id IS NULL
226: OR ( pod.po_line_id IN ( SELECT pol.po_line_id
227: FROM po_lines_all pol
228: WHERE pol.item_id = p_item_id ) )
229: )
230: AND ( p_po_release_id IS NULL
231: OR ( pod.po_release_id = p_po_release_id)

Line 349: po_lines_all pol

345:
346: /* AND rsl.item_id IN (
347: SELECT wlc.inventory_item_id
348: FROM wms_lpn_contents wlc,
349: po_lines_all pol
350: WHERE pol.item_id = wlc.inventory_item_id
351: AND parent_lpn_id =
352: NVL ( p_lpn_id, parent_lpn_id )
353: AND pod.po_line_id = pol.po_line_id )*/; --bug 2876336