DBA Data[Home] [Help]

APPS.POA_EDW_SPEND_PKG dependencies on PO_RELEASES_ALL

Line 73: FROM po_releases_all por,

69: * nvl(pll.price_override,0) ))
70: )
71: )
72: INTO v_amt_released
73: FROM po_releases_all por,
74: po_headers_all poh,
75: po_line_locations_all pll,
76: po_distributions_all pod,
77: po_lines_all pol

Line 204: po_releases_all por,

200: INTO v_amt_released
201: FROM po_distributions_all pod,
202: po_line_locations_all pll,
203: po_headers_all poh,
204: po_releases_all por,
205: po_lines_all pol
206: WHERE pod.po_release_id = por.po_release_id
207: and pod.po_header_id = poh.po_header_id
208: and pod.po_line_id = pol.po_line_id

Line 262: po_releases_all por

258: INTO v_qty_released
259: FROM po_distributions_all pod,
260: po_line_locations_all pll,
261: po_headers_all poh,
262: po_releases_all por
263: WHERE pod.po_release_id = por.po_release_id
264: and pod.po_header_id = poh.po_header_id
265: and pod.line_location_id = pll.line_location_id
266: and poh.po_header_id = p_contract_id