DBA Data[Home] [Help]

APPS.INV_UI_TASK_LOVS dependencies on PO_LINES_ALL

Line 171: FROM po_lines_all pol

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

Line 225: FROM po_lines_all pol

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

Line 347: po_lines_all pol

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