DBA Data[Home] [Help]

APPS.POA_EDW_PO_DIST_F_C dependencies on PO_LINE_LOCATIONS_ALL

Line 564: po_line_locations_all pll,

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
568: and pod.po_line_id = pol.po_line_id

Line 579: po_line_locations_all pll,

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
583: WHERE pod.line_location_id = pll.line_location_id