APPS.POA_SAVINGS_MAIN dependencies on PO_LINES_ALL

Line 41: FROM po_lines_all pol,

37: l_no_batch NUMBER;
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

Line 56: FROM po_lines_all pol,

52: poh.last_update_date, pod.last_update_date, nvl(pod.program_update_date, pod.last_update_date))
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