APPS.PO_CONTRACTS_S dependencies on PO_LINES_GT

Line 36: FROM po_lines_gt pol, --

32: SELECT distinct contracts.po_header_id,
33: contracts.amount_limit ,
34: NVL(contracts.rate, 1), -- Bug# 4685260
35: contracts.currency_code --Bug# 4685260
36: FROM po_lines_gt pol, --
37: po_headers_all contracts -- --
38: WHERE contracts.po_header_id = pol.contract_id
39: --AND NVL(contracts.global_agreement_flag, 'N') = 'N' --
40: AND pol.po_header_id = X_po_header_id

Line 121: FROM po_lines_gt pol, --

117: AND pol.po_header_id <> X_po_header_id
118: AND poh2.currency_code <> x_currency_code
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

Line 203: FROM po_lines_gt pol, --

199: 'Y', nvl(POTOAPP.rate, 1),1) --Bug4685260
200: )
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