eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSE_AP_PA_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 121: FROM ap_invoice_distributions_all aida

117: FROM dual
118: UNION ALL
119: SELECT 'CSE_IPV_ADJUSTMENT' txn_source , distribution_line_number
120: sys_reference3
121: FROM ap_invoice_distributions_all aida
122: WHERE po_distribution_id = p_po_distribution_id
123: and aida.invoice_id = cdl.system_reference2)
124: AND nvl(ei.net_zero_adjustment_flag, 'N') = 'N'
125: UNION ALL

Line 145: FROM ap_invoice_distributions_all aida

141: FROM dual
142: UNION ALL
143: SELECT 'CSE_IPV_ADJUSTMENT' txn_source , distribution_line_number
144: sys_reference3
145: FROM ap_invoice_distributions_all aida
146: WHERE po_distribution_id = p_po_distribution_id
147: and aida.invoice_id = ti.cdl_system_reference2)
148: ORDER BY instance_id, transaction_source desc;
149:

Line 428: FROM ap_invoice_distributions_all aida1

424: aida.distribution_line_number,
425: nvl(aida.amount,0) base_amount,
426: aila.line_number,
427: decode(aida.line_type_lookup_code,'NONREC_TAX', (SELECT aida1.quantity_invoiced
428: FROM ap_invoice_distributions_all aida1
429: WHERE aida1.invoice_distribution_id = aida.charge_applicable_to_dist_id),'TRV', (SELECT aida2.quantity_invoiced
430: FROM ap_invoice_distributions_all aida2
431: WHERE aida2.invoice_distribution_id = aida.charge_applicable_to_dist_id),'TIPV', (SELECT aida3.quantity_invoiced
432: FROM ap_invoice_distributions_all aida3

Line 430: FROM ap_invoice_distributions_all aida2

426: aila.line_number,
427: decode(aida.line_type_lookup_code,'NONREC_TAX', (SELECT aida1.quantity_invoiced
428: FROM ap_invoice_distributions_all aida1
429: WHERE aida1.invoice_distribution_id = aida.charge_applicable_to_dist_id),'TRV', (SELECT aida2.quantity_invoiced
430: FROM ap_invoice_distributions_all aida2
431: WHERE aida2.invoice_distribution_id = aida.charge_applicable_to_dist_id),'TIPV', (SELECT aida3.quantity_invoiced
432: FROM ap_invoice_distributions_all aida3
433: WHERE aida3.invoice_distribution_id = aida.charge_applicable_to_dist_id),'ERV', (SELECT aida4.quantity_invoiced
434: FROM ap_invoice_distributions_all aida4

Line 432: FROM ap_invoice_distributions_all aida3

428: FROM ap_invoice_distributions_all aida1
429: WHERE aida1.invoice_distribution_id = aida.charge_applicable_to_dist_id),'TRV', (SELECT aida2.quantity_invoiced
430: FROM ap_invoice_distributions_all aida2
431: WHERE aida2.invoice_distribution_id = aida.charge_applicable_to_dist_id),'TIPV', (SELECT aida3.quantity_invoiced
432: FROM ap_invoice_distributions_all aida3
433: WHERE aida3.invoice_distribution_id = aida.charge_applicable_to_dist_id),'ERV', (SELECT aida4.quantity_invoiced
434: FROM ap_invoice_distributions_all aida4
435: WHERE aida4.invoice_distribution_id = aida.charge_applicable_to_dist_id),'TERV', (SELECT aida5.quantity_invoiced
436: FROM ap_invoice_distributions_all aida5

Line 434: FROM ap_invoice_distributions_all aida4

430: FROM ap_invoice_distributions_all aida2
431: WHERE aida2.invoice_distribution_id = aida.charge_applicable_to_dist_id),'TIPV', (SELECT aida3.quantity_invoiced
432: FROM ap_invoice_distributions_all aida3
433: WHERE aida3.invoice_distribution_id = aida.charge_applicable_to_dist_id),'ERV', (SELECT aida4.quantity_invoiced
434: FROM ap_invoice_distributions_all aida4
435: WHERE aida4.invoice_distribution_id = aida.charge_applicable_to_dist_id),'TERV', (SELECT aida5.quantity_invoiced
436: FROM ap_invoice_distributions_all aida5
437: WHERE aida5.invoice_distribution_id = aida.charge_applicable_to_dist_id),aila.quantity_invoiced) quantity_invoiced, --Modified for bug 8927385&15877255
438:

Line 436: FROM ap_invoice_distributions_all aida5

432: FROM ap_invoice_distributions_all aida3
433: WHERE aida3.invoice_distribution_id = aida.charge_applicable_to_dist_id),'ERV', (SELECT aida4.quantity_invoiced
434: FROM ap_invoice_distributions_all aida4
435: WHERE aida4.invoice_distribution_id = aida.charge_applicable_to_dist_id),'TERV', (SELECT aida5.quantity_invoiced
436: FROM ap_invoice_distributions_all aida5
437: WHERE aida5.invoice_distribution_id = aida.charge_applicable_to_dist_id),aila.quantity_invoiced) quantity_invoiced, --Modified for bug 8927385&15877255
438:
439: aida.unit_price,
440: aida.price_var_code_combination_id inv_dist_ccid

Line 442: ap_invoice_distributions_all aida,

438:
439: aida.unit_price,
440: aida.price_var_code_combination_id inv_dist_ccid
441: FROM po_distributions_all pda,
442: ap_invoice_distributions_all aida,
443: ap_invoice_lines_all aila,
444: ap_invoices_all aia
445: WHERE EXISTS (
446: SELECT '1' FROM csi_transactions ct

Line 496: FROM ap_invoice_distributions_all aida,

492: aia.invoice_type_lookup_code invoice_type,
493: nvl(aida.amount,0) base_amount,
494: aida.accounting_date,
495: aida.dist_code_combination_id inv_dist_ccid
496: FROM ap_invoice_distributions_all aida,
497: ap_invoice_distributions_all aida1,
498: ap_invoices_all aia
499: WHERE aida.invoice_id = p_invoice_id
500: AND aida.project_id = p_project_id

Line 497: ap_invoice_distributions_all aida1,

493: nvl(aida.amount,0) base_amount,
494: aida.accounting_date,
495: aida.dist_code_combination_id inv_dist_ccid
496: FROM ap_invoice_distributions_all aida,
497: ap_invoice_distributions_all aida1,
498: ap_invoices_all aia
499: WHERE aida.invoice_id = p_invoice_id
500: AND aida.project_id = p_project_id
501: AND aida.task_id = p_task_id

Line 763: debug('updating ap_invoice_distributions_all.pa_addition_flag = Y ');

759:
760: END IF;
761:
762: IF l_in_service_flag <> 'N' THEN -- Bug 8565319
763: debug('updating ap_invoice_distributions_all.pa_addition_flag = Y ');
764:
765: UPDATE ap_invoice_distributions_all
766: SET pa_addition_flag = 'Y',
767: last_update_date = sysdate,

Line 765: UPDATE ap_invoice_distributions_all

761:
762: IF l_in_service_flag <> 'N' THEN -- Bug 8565319
763: debug('updating ap_invoice_distributions_all.pa_addition_flag = Y ');
764:
765: UPDATE ap_invoice_distributions_all
766: SET pa_addition_flag = 'Y',
767: last_update_date = sysdate,
768: last_updated_by = fnd_global.user_id,
769: last_update_login = fnd_global.login_id,

Line 773: UPDATE ap_invoice_distributions_all

769: last_update_login = fnd_global.login_id,
770: request_id = fnd_global.conc_request_id
771: WHERE invoice_distribution_id = ap_inv_rec.invoice_distribution_id;
772:
773: UPDATE ap_invoice_distributions_all
774: SET pa_addition_flag = 'Y',
775: last_update_date = sysdate,
776: last_updated_by = fnd_global.user_id,
777: last_update_login = fnd_global.login_id,

Line 790: --debug('updating ap_invoice_distributions_all.pa_addition_flag = Y ');

786: FOR l_ind IN l_ap_ft_tbl.FIRST .. l_ap_ft_tbl.LAST
787: LOOP
788:
789: null;
790: --debug('updating ap_invoice_distributions_all.pa_addition_flag = Y ');
791: END LOOP;
792: END IF;
793:
794: END LOOP;