DBA Data[Home] [Help]

APPS.PO_CONTRACTS_S dependencies on PO_HEADERS_GT

Line 123: po_headers_gt potoapp --

119: UNION ALL
120: SELECT 'Exists'
121: FROM po_lines_gt pol, --
122: po_line_locations_gt pll, --
123: po_headers_gt potoapp --
124: WHERE pol.contract_id = X_contract_id --
125: AND pol.po_line_id = pll.po_line_id
126: AND pol.po_header_id = potoapp.po_header_id
127: AND potoapp.po_header_id = X_po_header_id

Line 205: po_headers_gt potoapp --

201: )
202: INTO X_current_amount
203: FROM po_lines_gt pol, --
204: po_line_locations_gt pll, --
205: po_headers_gt potoapp --
206: WHERE pol.contract_id = X_contract_id --
207: AND pol.po_line_id = pll.po_line_id
208: AND pol.po_header_id = potoapp.po_header_id
209: AND potoapp.po_header_id = X_po_header_id