APPS.PO_CONTRACTS_S dependencies on PO_LINES

Line 32: FROM po_lines_gt pol, --

28: SELECT distinct contracts.po_header_id,
29: contracts.amount_limit ,
30: NVL(contracts.rate, 1), -- Bug# 4685260
31: contracts.currency_code --Bug# 4685260
32: FROM po_lines_gt pol, --
33: po_headers contracts -- --
34: WHERE contracts.po_header_id = pol.contract_id
35: AND NVL(contracts.global_agreement_flag, 'N') = 'N' --
36: AND pol.po_header_id = X_po_header_id

Line 42: /* Main loop to get all po_lines that you're trying to insert and then

38:
39:
40: BEGIN
41:
42: /* Main loop to get all po_lines that you're trying to insert and then
43: go get the total po amounts that you've created to see if it's okay to
44: insert this po
45: */
46: X_progress := 10;

Line 102: FROM po_lines pol,

98: INTO x_diff_curr
99: from dual
100: where exists (
101: SELECT 'Exists'
102: FROM po_lines pol,
103: po_line_locations pll,
104: po_headers poh2
105: WHERE pol.contract_id = X_contract_id --
106: AND pol.po_line_id = pll.po_line_id

Line 114: FROM po_lines_gt pol, --

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

Line 154: FROM po_lines pol,

150: 0
151: )
152: )
153: INTO X_purchased_amount
154: FROM po_lines pol,
155: po_line_locations pll,
156: po_headers poh2
157: WHERE pol.contract_id = X_contract_id --
158: AND pol.po_line_id = pll.po_line_id

Line 195: FROM po_lines_gt pol, --

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