DBA Data[Home] [Help]

APPS.INV_UI_TASK_LOVS dependencies on PO_DISTRIBUTIONS_ALL

Line 162: po_distributions_all pod,

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

Line 217: po_distributions_all pod

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

Line 315: po_distributions_all pod,

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