[Home] [Help]
94: xlah.ae_header_id,
95: xlah.ledger_id,
96: SUM(xdln.unrounded_accounted_dr) gross_amount,
97: MIN(aip.invoice_id) invoice_id
98: FROM ap_invoice_distributions aid ,
99: ap_invoice_payments aip ,
100: ap_payment_hist_dists payh ,
101: xla_distribution_links xdln ,
102: xla_ae_headers xlah
123: xlah.ae_header_id,
124: xlah.ledger_id,
125: SUM(xdln.unrounded_accounted_dr) gross_amount,
126: MIN(aip.invoice_id) invoice_id
127: FROM ap_invoice_distributions aid ,
128: ap_invoice_payments aip ,
129: ap_payment_hist_dists payh ,
130: xla_distribution_links xdln ,
131: xla_ae_headers xlah
152: SELECT xdln.event_id event,
153: xlah.ae_header_id ,
154: xlah.ledger_id ,
155: SUM(xdln.unrounded_accounted_dr) pay_amount
156: FROM ap_invoice_distributions_all aid ,
157: ap_payment_hist_dists payh ,
158: xla_distribution_links xdln ,
159: xla_ae_headers xlah ,
160: ap_invoice_payments_all aip
177:
178: CURSOR c_get_invwht_check (cn_invoice_id NUMBER) IS
179: SELECT ai.invoice_id invoice_id
180: FROM ap_invoice_payments aip,
181: ap_invoice_distributions aid,
182: ap_invoices ai
183: WHERE ai.invoice_id = cn_invoice_id
184: AND ai.invoice_id = aip.invoice_id
185: AND aip.invoice_id = aid.invoice_id
191: SELECT xdln.event_id event,
192: xlah.ae_header_id ,
193: xlah.ledger_id ,
194: SUM(xdln.unrounded_accounted_dr) pay_amount
195: FROM ap_invoice_distributions_all aid ,
196: xla_distribution_links xdln,
197: xla_ae_headers xlah
198: WHERE aid.invoice_id = cn_invoice_id
199: AND aid.line_type_lookup_code = 'AWT'
239: END LOOP;
240: ELSE
241: BEGIN
242: SELECT SUM(xdln.unrounded_accounted_dr) INTO ln_invoice_amount
243: FROM ap_invoice_distributions_all aid ,
244: xla_distribution_links xdln,
245: xla_ae_headers xlah
246: WHERE aid.invoice_id = ln_invoice_id
247: AND aid.line_type_lookup_code <> 'AWT'