APPS.POA_SAVINGS_MAIN dependencies on PO_DISTRIBUTIONS_ALL

Line 44: po_distributions_all pod

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
47: and pod.po_header_id = poh.po_header_id
48: and pll.shipment_type = 'STANDARD'

Line 60: po_distributions_all pod

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
62: and pod.po_release_id = por.po_release_id
63: and pod.po_line_id = pol.po_line_id
64: and pod.po_header_id = poh.po_header_id

Line 158: FROM po_distributions_all pod

154:
155: OPEN v_account_cursor FOR
156: SELECT distinct pod.code_combination_id
157: , pod.set_of_books_id
158: FROM po_distributions_all pod
159: where pod.po_distribution_id IN
160: (SELECT distinct poa.distribution_transaction_id
161: FROM poa_bis_savings poa);
162:

Line 182: FROM po_distributions_all pod

178: account_id = v_account_id,
179: company_id = v_company_id
180: WHERE poa.distribution_transaction_id IN
181: (SELECT pod.po_distribution_id
182: FROM po_distributions_all pod
183: WHERE pod.code_combination_id = v_ccid
184: and pod.set_of_books_id = v_set_of_books_id);
185:
186: END LOOP;