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.AR_DEPOSIT_API_PUB dependencies on RA_CUST_TRX_TYPES

Line 523: ra_cust_trx_types.cust_trx_type_id%type;

519: l_auto_trx_numbering_flag ra_batch_sources.auto_trx_numbering_flag%type;
520: l_batch_source_type ra_batch_sources.batch_source_type%type;
521: l_copy_doc_number_flag ra_batch_sources.copy_doc_number_flag%type;
522: l_bs_default_cust_trx_type_id
523: ra_cust_trx_types.cust_trx_type_id%type;
524: l_default_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
525: l_default_type_name ra_cust_trx_types.name%type;
526: l_class ra_cust_trx_types.type%type;
527: l_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%type;

Line 524: l_default_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;

520: l_batch_source_type ra_batch_sources.batch_source_type%type;
521: l_copy_doc_number_flag ra_batch_sources.copy_doc_number_flag%type;
522: l_bs_default_cust_trx_type_id
523: ra_cust_trx_types.cust_trx_type_id%type;
524: l_default_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
525: l_default_type_name ra_cust_trx_types.name%type;
526: l_class ra_cust_trx_types.type%type;
527: l_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%type;
528: l_post_to_gl_flag ra_cust_trx_types.post_to_gl%type;

Line 525: l_default_type_name ra_cust_trx_types.name%type;

521: l_copy_doc_number_flag ra_batch_sources.copy_doc_number_flag%type;
522: l_bs_default_cust_trx_type_id
523: ra_cust_trx_types.cust_trx_type_id%type;
524: l_default_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
525: l_default_type_name ra_cust_trx_types.name%type;
526: l_class ra_cust_trx_types.type%type;
527: l_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%type;
528: l_post_to_gl_flag ra_cust_trx_types.post_to_gl%type;
529: l_allow_freight_flag ra_cust_trx_types.allow_freight_flag%type;

Line 526: l_class ra_cust_trx_types.type%type;

522: l_bs_default_cust_trx_type_id
523: ra_cust_trx_types.cust_trx_type_id%type;
524: l_default_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
525: l_default_type_name ra_cust_trx_types.name%type;
526: l_class ra_cust_trx_types.type%type;
527: l_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%type;
528: l_post_to_gl_flag ra_cust_trx_types.post_to_gl%type;
529: l_allow_freight_flag ra_cust_trx_types.allow_freight_flag%type;
530: l_creation_sign ra_cust_trx_types.creation_sign%type;

Line 527: l_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%type;

523: ra_cust_trx_types.cust_trx_type_id%type;
524: l_default_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
525: l_default_type_name ra_cust_trx_types.name%type;
526: l_class ra_cust_trx_types.type%type;
527: l_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%type;
528: l_post_to_gl_flag ra_cust_trx_types.post_to_gl%type;
529: l_allow_freight_flag ra_cust_trx_types.allow_freight_flag%type;
530: l_creation_sign ra_cust_trx_types.creation_sign%type;
531: l_dft_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;

Line 528: l_post_to_gl_flag ra_cust_trx_types.post_to_gl%type;

524: l_default_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
525: l_default_type_name ra_cust_trx_types.name%type;
526: l_class ra_cust_trx_types.type%type;
527: l_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%type;
528: l_post_to_gl_flag ra_cust_trx_types.post_to_gl%type;
529: l_allow_freight_flag ra_cust_trx_types.allow_freight_flag%type;
530: l_creation_sign ra_cust_trx_types.creation_sign%type;
531: l_dft_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
532: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;

Line 529: l_allow_freight_flag ra_cust_trx_types.allow_freight_flag%type;

525: l_default_type_name ra_cust_trx_types.name%type;
526: l_class ra_cust_trx_types.type%type;
527: l_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%type;
528: l_post_to_gl_flag ra_cust_trx_types.post_to_gl%type;
529: l_allow_freight_flag ra_cust_trx_types.allow_freight_flag%type;
530: l_creation_sign ra_cust_trx_types.creation_sign%type;
531: l_dft_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
532: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
533: l_default_status_code ar_lookups.lookup_code%type;

Line 530: l_creation_sign ra_cust_trx_types.creation_sign%type;

526: l_class ra_cust_trx_types.type%type;
527: l_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%type;
528: l_post_to_gl_flag ra_cust_trx_types.post_to_gl%type;
529: l_allow_freight_flag ra_cust_trx_types.allow_freight_flag%type;
530: l_creation_sign ra_cust_trx_types.creation_sign%type;
531: l_dft_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
532: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
533: l_default_status_code ar_lookups.lookup_code%type;
534: l_default_status ar_lookups.meaning%type;

Line 531: l_dft_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;

527: l_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%type;
528: l_post_to_gl_flag ra_cust_trx_types.post_to_gl%type;
529: l_allow_freight_flag ra_cust_trx_types.allow_freight_flag%type;
530: l_creation_sign ra_cust_trx_types.creation_sign%type;
531: l_dft_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
532: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
533: l_default_status_code ar_lookups.lookup_code%type;
534: l_default_status ar_lookups.meaning%type;
535: l_status_trx ar_lookups.meaning%type;

Line 532: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;

528: l_post_to_gl_flag ra_cust_trx_types.post_to_gl%type;
529: l_allow_freight_flag ra_cust_trx_types.allow_freight_flag%type;
530: l_creation_sign ra_cust_trx_types.creation_sign%type;
531: l_dft_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
532: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
533: l_default_status_code ar_lookups.lookup_code%type;
534: l_default_status ar_lookups.meaning%type;
535: l_status_trx ar_lookups.meaning%type;
536: l_default_printing_option ar_lookups.meaning%type;

Line 544: l_ctt_default_ctrx_type_id ra_cust_trx_types.cust_trx_type_id%type;

540: l_number_of_due_dates number;
541: l_term_due_date date;
542: l_default_gl_date date;
543: l_gd_default_gl_date date;
544: l_ctt_default_ctrx_type_id ra_cust_trx_types.cust_trx_type_id%type;
545: l_ctt_default_type_name ra_cust_trx_types.name%type;
546: l_ctt_bs_default_type_name ra_cust_trx_types.name%type;
547: l_batch_source_id ra_batch_sources.batch_source_id%type;
548: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;

Line 545: l_ctt_default_type_name ra_cust_trx_types.name%type;

541: l_term_due_date date;
542: l_default_gl_date date;
543: l_gd_default_gl_date date;
544: l_ctt_default_ctrx_type_id ra_cust_trx_types.cust_trx_type_id%type;
545: l_ctt_default_type_name ra_cust_trx_types.name%type;
546: l_ctt_bs_default_type_name ra_cust_trx_types.name%type;
547: l_batch_source_id ra_batch_sources.batch_source_id%type;
548: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
549: l_term_id ra_terms.term_id%type;

Line 546: l_ctt_bs_default_type_name ra_cust_trx_types.name%type;

542: l_default_gl_date date;
543: l_gd_default_gl_date date;
544: l_ctt_default_ctrx_type_id ra_cust_trx_types.cust_trx_type_id%type;
545: l_ctt_default_type_name ra_cust_trx_types.name%type;
546: l_ctt_bs_default_type_name ra_cust_trx_types.name%type;
547: l_batch_source_id ra_batch_sources.batch_source_id%type;
548: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
549: l_term_id ra_terms.term_id%type;
550: l_salesrep_id ra_salesreps.salesrep_id%type;

Line 548: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;

544: l_ctt_default_ctrx_type_id ra_cust_trx_types.cust_trx_type_id%type;
545: l_ctt_default_type_name ra_cust_trx_types.name%type;
546: l_ctt_bs_default_type_name ra_cust_trx_types.name%type;
547: l_batch_source_id ra_batch_sources.batch_source_id%type;
548: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
549: l_term_id ra_terms.term_id%type;
550: l_salesrep_id ra_salesreps.salesrep_id%type;
551: l_default_salesrep_id ra_salesreps.salesrep_id%type;
552: l_dft_bill_to_contact_id Number;

Line 636: ra_cust_trx_types.cust_trx_type_id%type;

632: ra_customer_trx.customer_bank_account_id%type;
633: l_new_customer_trx_line_id
634: ra_customer_trx_lines.customer_trx_line_id%type;
635: l_ctt_bs_deflt_ctrx_type_id
636: ra_cust_trx_types.cust_trx_type_id%type;
637: l_allow_overapplication_flag
638: ra_cust_trx_types.allow_overapplication_flag%type;
639: l_natural_app_only_flag
640: ra_cust_trx_types.natural_application_only_flag%type;

Line 638: ra_cust_trx_types.allow_overapplication_flag%type;

634: ra_customer_trx_lines.customer_trx_line_id%type;
635: l_ctt_bs_deflt_ctrx_type_id
636: ra_cust_trx_types.cust_trx_type_id%type;
637: l_allow_overapplication_flag
638: ra_cust_trx_types.allow_overapplication_flag%type;
639: l_natural_app_only_flag
640: ra_cust_trx_types.natural_application_only_flag%type;
641: l_default_printing_option_code
642: ar_lookups.lookup_code%type;

Line 640: ra_cust_trx_types.natural_application_only_flag%type;

636: ra_cust_trx_types.cust_trx_type_id%type;
637: l_allow_overapplication_flag
638: ra_cust_trx_types.allow_overapplication_flag%type;
639: l_natural_app_only_flag
640: ra_cust_trx_types.natural_application_only_flag%type;
641: l_default_printing_option_code
642: ar_lookups.lookup_code%type;
643: l_org_return_status VARCHAR2(1);
644: l_org_id NUMBER;

Line 1036: FROM ra_cust_trx_types

1032: ELSIF l_cust_trx_type_id is NULL and l_default_cust_trx_type_id is NOT NULL THEN
1033: BEGIN
1034: SELECT cust_trx_type_id
1035: INTO l_cust_trx_type_id
1036: FROM ra_cust_trx_types
1037: where type = 'DEP' and
1038: nvl(p_deposit_date, trunc(sysdate)) between
1039: nvl(start_date(+), nvl(p_deposit_date, trunc(sysdate))) and
1040: nvl(end_date(+), nvl(p_deposit_date, trunc(sysdate))) and

Line 1753: ra_cust_trx_types cust_trx_type

1749: FND_MSG_PUB.Add;
1750:
1751: SELECT customer_trx_id into l_dummy_number
1752: FROM ra_customer_trx cust_trx ,
1753: ra_cust_trx_types cust_trx_type
1754: WHERE cust_trx.cust_trx_type_id =cust_trx_type.cust_trx_type_id
1755: and customer_trx_id = l_customer_trx_id
1756: and cust_trx_type.TYPE = 'DEP';
1757: exception

Line 1774: ra_cust_trx_types cust_trx_type

1770: WHERE customer_trx_id = p_customer_trx_id;
1771:
1772: SELECT customer_trx_id into l_dummy_number
1773: FROM ra_customer_trx cust_trx ,
1774: ra_cust_trx_types cust_trx_type
1775: WHERE cust_trx.cust_trx_type_id =cust_trx_type.cust_trx_type_id
1776: and customer_trx_id = l_customer_trx_id and
1777: cust_trx_type.TYPE = 'DEP';
1778: exception

Line 1795: ra_cust_trx_types cust_trx_type

1791: WHERE trx_number = p_deposit_number;
1792:
1793: SELECT customer_trx_id into l_dummy_number
1794: FROM ra_customer_trx cust_trx ,
1795: ra_cust_trx_types cust_trx_type
1796: WHERE cust_trx.cust_trx_type_id =cust_trx_type.cust_trx_type_id
1797: and customer_trx_id = l_customer_trx_id and
1798: cust_trx_type.TYPE = 'DEP';
1799: exception