DBA Data[Home] [Help]

APPS.POA_SAVINGS_MAIN dependencies on PO_HEADERS_ALL

Line 43: po_headers_all poh,

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
47: and pod.po_header_id = poh.po_header_id

Line 58: po_headers_all poh,

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
62: and pod.po_release_id = por.po_release_id