DBA Data[Home] [Help]

APPS.POA_EDW_PO_DIST_F_C dependencies on PO_LINES_ALL

Line 563: FROM po_lines_all pol,

559: p_batch_size number) IS
560: SELECT po_distribution_id, ceil(rownum/p_batch_size)
561: FROM
562: (SELECT pod.PO_DISTRIBUTION_ID, pol.item_id, pod.creation_date
563: FROM po_lines_all pol,
564: po_line_locations_all pll,
565: po_headers_all poh,
566: po_distributions_all pod
567: WHERE pod.line_location_id = pll.line_location_id

Line 578: FROM po_lines_all pol,

574: poh.last_update_date, pod.last_update_date, nvl(pod.program_update_date, pod.last_update_date))
575: between g_push_from_date and g_push_to_date
576: UNION ALL
577: SELECT pod.PO_DISTRIBUTION_ID, pol.item_id, pod.creation_date
578: FROM po_lines_all pol,
579: po_line_locations_all pll,
580: po_headers_all poh,
581: po_releases_all por,
582: po_distributions_all pod