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_IPV_FA_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 51: from ap_invoice_distributions_all

47:
48: IS
49: Cursor c_success_count( cp_conc_request_id NUMBER ) IS
50: select count(1) success_count
51: from ap_invoice_distributions_all
52: where request_id = cp_conc_request_id ;
53:
54: Cursor c_failed_count( cp_conc_request_id NUMBER ) IS
55: select count(1 ) failed_count

Line 66: ap_invoice_distributions_all aida,

62: aida.quantity_invoiced quantity_invoiced,
63: aida.base_invoice_price_variance base_invoice_price_variance,
64: cte.error_text error_text
65: from ap_invoices_all aia,
66: ap_invoice_distributions_all aida,
67: csi_txn_errors cte
68: where aida.invoice_id = aia.invoice_id
69: and cte.source_id = aida.invoice_distribution_id
70: and cte.source_group_ref_id = cp_conc_request_id ;

Line 527: l_txn_error_rec.source_type := 'AP_INVOICE_DISTRIBUTIONS_ALL';

523: x_processed_flag := 'N';
524: l_txn_error_rec := cse_util_pkg.init_txn_error_rec;
525: l_txn_error_rec.error_text := l_error_message;
526: l_txn_error_rec.source_group_ref_id := l_conc_request_id;
527: l_txn_error_rec.source_type := 'AP_INVOICE_DISTRIBUTIONS_ALL';
528: l_txn_error_rec.source_id := p_invoice_rec.invoice_dist_id;
529: l_txn_error_rec.processed_flag := 'N';
530: csi_transactions_pvt.create_txn_error(
531: p_api_version => 1.0,

Line 575: FROM ap_invoice_distributions_all aida1

571: SELECT aida.invoice_id,
572: aida.distribution_line_number,
573: aida.unit_price,
574: decode(aida.line_type_lookup_code,'NONREC_TAX', (SELECT aida1.quantity_invoiced
575: FROM ap_invoice_distributions_all aida1
576: WHERE aida1.invoice_distribution_id = aida.charge_applicable_to_dist_id),'TRV', (SELECT aida2.quantity_invoiced
577: FROM ap_invoice_distributions_all aida2
578: WHERE aida2.invoice_distribution_id = aida.charge_applicable_to_dist_id),'TIPV', (SELECT aida2.quantity_invoiced
579: FROM ap_invoice_distributions_all aida2

Line 577: FROM ap_invoice_distributions_all aida2

573: aida.unit_price,
574: decode(aida.line_type_lookup_code,'NONREC_TAX', (SELECT aida1.quantity_invoiced
575: FROM ap_invoice_distributions_all aida1
576: WHERE aida1.invoice_distribution_id = aida.charge_applicable_to_dist_id),'TRV', (SELECT aida2.quantity_invoiced
577: FROM ap_invoice_distributions_all aida2
578: WHERE aida2.invoice_distribution_id = aida.charge_applicable_to_dist_id),'TIPV', (SELECT aida2.quantity_invoiced
579: FROM ap_invoice_distributions_all aida2
580: WHERE aida2.invoice_distribution_id = aida.charge_applicable_to_dist_id),'ERV', (SELECT aida2.quantity_invoiced
581: FROM ap_invoice_distributions_all aida2

Line 579: FROM ap_invoice_distributions_all aida2

575: FROM ap_invoice_distributions_all aida1
576: WHERE aida1.invoice_distribution_id = aida.charge_applicable_to_dist_id),'TRV', (SELECT aida2.quantity_invoiced
577: FROM ap_invoice_distributions_all aida2
578: WHERE aida2.invoice_distribution_id = aida.charge_applicable_to_dist_id),'TIPV', (SELECT aida2.quantity_invoiced
579: FROM ap_invoice_distributions_all aida2
580: WHERE aida2.invoice_distribution_id = aida.charge_applicable_to_dist_id),'ERV', (SELECT aida2.quantity_invoiced
581: FROM ap_invoice_distributions_all aida2
582: WHERE aida2.invoice_distribution_id = aida.charge_applicable_to_dist_id),aila.quantity_invoiced) quantity_invoiced, --Modified for bug 12991094 and 13770784
583: aida.invoice_distribution_id,

Line 581: FROM ap_invoice_distributions_all aida2

577: FROM ap_invoice_distributions_all aida2
578: WHERE aida2.invoice_distribution_id = aida.charge_applicable_to_dist_id),'TIPV', (SELECT aida2.quantity_invoiced
579: FROM ap_invoice_distributions_all aida2
580: WHERE aida2.invoice_distribution_id = aida.charge_applicable_to_dist_id),'ERV', (SELECT aida2.quantity_invoiced
581: FROM ap_invoice_distributions_all aida2
582: WHERE aida2.invoice_distribution_id = aida.charge_applicable_to_dist_id),aila.quantity_invoiced) quantity_invoiced, --Modified for bug 12991094 and 13770784
583: aida.invoice_distribution_id,
584: aida.line_type_lookup_code invoice_distribution_type, --Added for bug 12991094
585: aida.po_distribution_id,

Line 592: FROM ap_invoice_distributions_all aida,

588: NVL(aida.base_amount,nvl(aida.amount, 0)) price_variance,
589: aila.inventory_item_id,
590: aila.org_id,
591: 'N' as self_assessed_flag
592: FROM ap_invoice_distributions_all aida,
593: ap_invoice_lines_all aila,
594: ap_invoices_all aia
595: WHERE aida.line_type_lookup_code IN ('IPV','FREIGHT', 'NONREC_TAX', 'TRV','TIPV','ERV') --Modified for bug 12991094,13770784 and 13647752
596: AND aida.posted_flag = 'Y'

Line 627: FROM ap_invoice_distributions_all aida1

623: SELECT aida.invoice_id,
624: aida.distribution_line_number,
625: aida.unit_price,
626: decode(aida.line_type_lookup_code,'FREIGHT', (SELECT aida1.quantity_invoiced
627: FROM ap_invoice_distributions_all aida1
628: WHERE aida1.invoice_distribution_id = aida.charge_applicable_to_dist_id),aila.quantity_invoiced) quantity_invoiced,
629: aida.invoice_distribution_id,
630: aida.line_type_lookup_code invoice_distribution_type,
631: decode(aida.line_type_lookup_code,'FREIGHT', (SELECT aida2.po_distribution_id

Line 632: FROM ap_invoice_distributions_all aida2

628: WHERE aida1.invoice_distribution_id = aida.charge_applicable_to_dist_id),aila.quantity_invoiced) quantity_invoiced,
629: aida.invoice_distribution_id,
630: aida.line_type_lookup_code invoice_distribution_type,
631: decode(aida.line_type_lookup_code,'FREIGHT', (SELECT aida2.po_distribution_id
632: FROM ap_invoice_distributions_all aida2
633: WHERE aida2.invoice_distribution_id = aida.charge_applicable_to_dist_id),aida.po_distribution_id) po_distribution_id,
634: aia.invoice_num,
635: --nvl(aida.amount, 0) price_variance,
636: NVL(aida.base_amount,nvl(aida.amount, 0)) price_variance,

Line 640: FROM ap_invoice_distributions_all aida,

636: NVL(aida.base_amount,nvl(aida.amount, 0)) price_variance,
637: aila.inventory_item_id,
638: aila.org_id,
639: 'N' as self_assessed_flag
640: FROM ap_invoice_distributions_all aida,
641: ap_invoice_lines_all aila,
642: ap_invoices_all aia
643: WHERE aida.line_type_lookup_code IN ('FREIGHT')
644: AND aida.posted_flag = 'Y'

Line 657: FROM ap_invoice_distributions_all aida4

653: WHERE aila2.invoice_id = aila.invoice_id
654: AND aila2.inventory_item_id = nvl(p_inventory_item_id, aila2.inventory_item_id))
655: AND EXISTS (
656: SELECT '1'
657: FROM ap_invoice_distributions_all aida4
658: WHERE aida4.invoice_distribution_id = aida.charge_applicable_to_dist_id
659: AND EXISTS (
660: SELECT '1'
661: FROM csi_transactions ct

Line 677: FROM ap_invoice_distributions_all aida1

673: SELECT aida.invoice_id,
674: aida.distribution_line_number,
675: aida.unit_price,
676: decode(aida.line_type_lookup_code,'NONREC_TAX', (SELECT aida1.quantity_invoiced
677: FROM ap_invoice_distributions_all aida1
678: WHERE aida1.invoice_distribution_id = aida.charge_applicable_to_dist_id),aila.quantity_invoiced) quantity_invoiced, --Modified for bug 12991094
679: aida.invoice_distribution_id,
680: aida.line_type_lookup_code invoice_distribution_type, --Added for bug 12991094
681: aida.po_distribution_id,

Line 688: FROM ap_invoice_distributions_all aida,

684: NVL(aida.base_amount,nvl(aida.amount, 0)) price_variance,
685: aila.inventory_item_id,
686: aila.org_id,
687: 'N' as self_assessed_flag
688: FROM ap_invoice_distributions_all aida,
689: ap_invoice_lines_all aila,
690: ap_invoices_all aia
691: WHERE aida.line_type_lookup_code IN ('NONREC_TAX')
692: --WHERE aida.line_type_lookup_code IN ('NONREC_TAX', 'TRV','TIPV','ERV')

Line 733: --ap_invoice_distributions_all aida,

729: aila.inventory_item_id,
730: aila.org_id,
731: asstda.SELF_ASSESSED_FLAG as self_assessed_flag
732: FROM AP_SELF_ASSESSED_TAX_DIST_all asstda,
733: --ap_invoice_distributions_all aida,
734: ap_invoice_lines_all aila,
735: ap_invoices_all aia
736: WHERE asstda.line_type_lookup_code IN ('NONREC_TAX')
737: AND asstda.posted_flag = 'Y'

Line 773: FROM ap_invoice_distributions_all aida,

769: aia.invoice_type_lookup_code invoice_type,
770: nvl(aida.amount,0) base_amount,
771: aida.accounting_date,
772: aida.dist_code_combination_id inv_dist_ccid
773: FROM ap_invoice_distributions_all aida,
774: ap_invoices_all aia
775: WHERE aida.invoice_id = p_invoice_id
776: AND aida.project_id = p_project_id
777: AND aida.task_id = p_task_id

Line 1011: UPDATE ap_invoice_distributions_all

1007:
1008: END IF; -- NVL(p_include_zero_ipv, 'Y') = 'Y' || (NVL(p_include_zero_ipv, 'Y') = 'N' AND invoice_rec.price_variance > 0)
1009:
1010: IF l_processed_flag = 'Y' AND NVL(invoice_rec.self_assessed_flag,'N') = 'N' THEN
1011: UPDATE ap_invoice_distributions_all
1012: SET assets_addition_flag = 'Y',
1013: request_id = l_conc_request_id
1014: WHERE invoice_distribution_id = invoice_rec.invoice_distribution_id
1015: AND assets_addition_flag <>'Y';

Line 1018: debug('Processed successfully. updating ap_invoice_distributions_all.assets_addition_flag = Y');

1014: WHERE invoice_distribution_id = invoice_rec.invoice_distribution_id
1015: AND assets_addition_flag <>'Y';
1016:
1017: debug('invoice_distribution_id : '||invoice_rec.invoice_distribution_id);
1018: debug('Processed successfully. updating ap_invoice_distributions_all.assets_addition_flag = Y');
1019: END IF;
1020:
1021: -- Updating ap_self_assessed_tax_dist_all table
1022: IF l_processed_flag = 'Y' AND NVL(invoice_rec.self_assessed_flag,'N') = 'Y' THEN

Line 1042: l_txn_error_rec.source_type := 'AP_INVOICE_DISTRIBUTIONS_ALL';

1038: --null;
1039: l_txn_error_rec := cse_util_pkg.init_txn_error_rec;
1040: l_txn_error_rec.error_text := SQLERRM;
1041: l_txn_error_rec.source_group_ref_id := l_conc_request_id;
1042: l_txn_error_rec.source_type := 'AP_INVOICE_DISTRIBUTIONS_ALL';
1043: l_txn_error_rec.source_id := invoice_rec.invoice_distribution_id;
1044: l_txn_error_rec.processed_flag := 'N';
1045: csi_transactions_pvt.create_txn_error(
1046: p_api_version => 1.0,

Line 1068: l_txn_error_rec.source_type := 'AP_INVOICE_DISTRIBUTIONS_ALL';

1064: WHEN OTHERS THEN
1065: l_txn_error_rec := cse_util_pkg.init_txn_error_rec;
1066: l_txn_error_rec.error_text := SQLERRM;
1067: l_txn_error_rec.source_group_ref_id := l_conc_request_id;
1068: l_txn_error_rec.source_type := 'AP_INVOICE_DISTRIBUTIONS_ALL';
1069: l_txn_error_rec.source_id := l_invoice_distribution_id;
1070: l_txn_error_rec.processed_flag := 'N';
1071: csi_transactions_pvt.create_txn_error(
1072: p_api_version => 1.0,