DBA Data[Home] [Help]

APPS.PO_CONTRACTS_S dependencies on PO_HEADERS_GT

Line 116: po_headers_gt potoapp --

112: UNION ALL
113: SELECT 'Exists'
114: FROM po_lines_gt pol, --
115: po_line_locations_gt pll, --
116: po_headers_gt potoapp --
117: WHERE pol.contract_id = X_contract_id --
118: AND pol.po_line_id = pll.po_line_id
119: AND pol.po_header_id = potoapp.po_header_id
120: AND potoapp.po_header_id = X_po_header_id

Line 197: po_headers_gt potoapp --

193: )
194: INTO X_current_amount
195: FROM po_lines_gt pol, --
196: po_line_locations_gt pll, --
197: po_headers_gt potoapp --
198: WHERE pol.contract_id = X_contract_id --
199: AND pol.po_line_id = pll.po_line_id
200: AND pol.po_header_id = potoapp.po_header_id
201: AND potoapp.po_header_id = X_po_header_id;