APPS.POA_SAVINGS_MAIN dependencies on PO_LINE_LOCATIONS_ALL

Line 42: po_line_locations_all pll,

38: cursor v_changed_rows(p_start_date date,p_end_date date,p_batch_size number) is
39: SELECT PO_DISTRIBUTION_ID, 1,ceil(rownum/p_batch_size)
40: FROM (SELECT pod.PO_DISTRIBUTION_ID,pol.item_id,pod.creation_date
41: FROM po_lines_all pol,
42: po_line_locations_all pll,
43: po_headers_all poh,
44: po_distributions_all pod
45: WHERE pod.line_location_id = pll.line_location_id
46: and pod.po_line_id = pol.po_line_id

Line 57: po_line_locations_all pll,

53: between p_start_date and p_end_date
54: UNION ALL
55: SELECT pod.PO_DISTRIBUTION_ID,pol.item_id,pod.creation_date
56: FROM po_lines_all pol,
57: po_line_locations_all pll,
58: po_headers_all poh,
59: po_releases_all por,
60: po_distributions_all pod
61: WHERE pod.line_location_id = pll.line_location_id