DBA Data[Home] [Help]

APPS.INV_UI_TASK_LOVS dependencies on PO_DISTRIBUTIONS_ALL

Line 164: po_distributions_all pod,

160: SELECT DISTINCT t.task_id,
161: NVL ( t.task_number, ' ' ),
162: NVL ( t.task_name, ' ' )
163: FROM pjm_tasks_mtll_v t,
164: po_distributions_all pod,
165: po_line_locations_all poll
166: WHERE pod.task_id = t.task_id
167: AND pod.po_header_id = p_po_header_id
168: AND pod.po_line_id = NVL ( p_po_line_id, pod.po_line_id )

Line 219: po_distributions_all pod

215: SELECT DISTINCT t.task_id,
216: NVL ( t.task_number, ' ' ),
217: NVL ( t.task_name, ' ' )
218: FROM pjm_tasks_mtll_v t,
219: po_distributions_all pod
220: WHERE pod.task_id = t.task_id
221: AND pod.po_header_id = p_po_header_id
222: AND pod.po_line_id = NVL ( p_po_line_id, pod.po_line_id )
223: AND pod.project_id = p_project_id

Line 317: po_distributions_all pod,

313: SELECT DISTINCT t.task_id,
314: NVL ( t.task_number, ' ' ),
315: NVL ( t.task_name, ' ' )
316: FROM pjm_tasks_mtll_v t,
317: po_distributions_all pod,
318: rcv_shipment_lines rsl
319: WHERE rsl.shipment_header_id = p_shipment_id
320: AND rsl.po_header_id =
321: NVL ( p_po_header_id, rsl.po_header_id )