DBA Data[Home] [Help]

APPS.PO_POXPOBPS_XMLP_PKG dependencies on PO_HEADERS_ALL

Line 217: FROM po_headers_all

213:
214:
215: SELECT nvl(global_agreement_flag,'N')
216: INTO X_GA_FLAG
217: FROM po_headers_all
218: WHERE po_header_id = po_header_id1;
219:
220: IF X_GA_FLAG = 'N' THEN
221:

Line 248: po_headers_all poh,

244: (NVL(PLL.quantity, 0) - NVL(PLL.quantity_cancelled, 0))
245: * NVL(PLL.price_override, 0)))
246: INTO X_RELEASED_AMT
247: FROM po_line_locations_all pll,
248: po_headers_all poh,
249: po_lines_all POL
250: WHERE poh.po_header_id = pll.from_header_id
251: AND POH.po_header_id = POL.po_header_id
252: AND POL.po_line_id = PLL.from_line_id