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_INVOICE_UTILS dependencies on RA_CUST_TRX_TYPES

Line 1558: FROM ra_cust_trx_types ctt

1554: FROM ar_trx_header_gt gt
1555: WHERE gt.cust_trx_type_id IS NOT NULL
1556: AND NOT EXISTS (
1557: SELECT 'X'
1558: FROM ra_cust_trx_types ctt
1559: where nvl(gt.trx_date, trunc(sysdate)) between
1560: ctt.start_date and nvl(ctt.end_date, nvl(gt.trx_date, trunc(sysdate)))
1561: and type IN ('INV', 'DM', 'CM') -- added CM for ER 5869149
1562: and ctt.cust_trx_type_id = gt.cust_trx_type_id);

Line 1999: ra_cust_trx_types ctt

1995: SELECT gt.trx_header_id,
1996: arp_standard.fnd_message('AR_INVALID_TERM'),
1997: gt.term_id
1998: FROM ar_trx_header_gt gt,
1999: ra_cust_trx_types ctt
2000: WHERE gt.term_id IS NOT NULL
2001: AND gt.trx_class <> 'CM' -- added for ER 5869149
2002: AND ctt.cust_trx_type_id = gt.cust_trx_type_id -- ER 5869149
2003: AND ctt.type <> 'CM' -- ER 5869149

Line 2022: ra_cust_trx_types ctt

2018: SELECT gt.trx_header_id,
2019: arp_standard.fnd_message('AR_INAPI_TERM_NOT_ALLOWED'),
2020: gt.term_id
2021: FROM ar_trx_header_gt gt,
2022: ra_cust_trx_types ctt
2023: WHERE gt.term_id IS NOT NULL
2024: AND gt.cust_trx_type_id = ctt.cust_trx_type_id
2025: AND ctt.type = 'CM';
2026:

Line 2179: FROM ra_cust_trx_types tt

2175: FROM ar_trx_header_gt gt
2176: WHERE gt.invoicing_rule_id IS NOT NULL
2177: AND gt.cust_trx_type_id NOT IN (
2178: SELECT tt.cust_trx_type_id
2179: FROM ra_cust_trx_types tt
2180: WHERE tt.cust_trx_type_id = gt.cust_trx_type_id
2181: AND tt.type = 'INV' );
2182:
2183: INSERT INTO ar_trx_errors_gt (

Line 2438: ra_cust_trx_types types

2434: WHERE gt.related_customer_trx_id IS NOT NULL
2435: AND NOT EXISTS (
2436: SELECT 'X'
2437: FROM ra_customer_trx trx, ra_batch_sources bs, ar_lookups look,
2438: ra_cust_trx_types types
2439: where trx.batch_source_id = bs.batch_source_id
2440: and trx.cust_trx_type_id = types.cust_trx_type_id
2441: and look.lookup_type = 'INV/CM'
2442: and types.type = look.lookup_code

Line 2488: ra_cust_trx_types tt

2484: CURSOR cglDate IS
2485: select hdr.trx_header_id, hdr.gl_date, hdr.invoicing_rule_id,
2486: NVL(tt.post_to_gl, 'N') post_to_gl
2487: from ar_trx_header_gt hdr,
2488: ra_cust_trx_types tt
2489: where tt.cust_trx_type_id = hdr.cust_trx_type_id;
2490:
2491: l_period_status gl_period_statuses.closing_status%type DEFAULT 'U';
2492: BEGIN

Line 2758: l_default_printing_option ra_cust_trx_types.default_printing_option%type;

2754: PROCEDURE Get_trx_type_details (
2755: x_errmsg OUT NOCOPY VARCHAR2,
2756: x_return_status OUT NOCOPY VARCHAR2) IS
2757:
2758: l_default_printing_option ra_cust_trx_types.default_printing_option%type;
2759: l_default_status ra_cust_trx_types.default_status%type;
2760: l_allow_freight_flag ra_cust_trx_types.allow_freight_flag%type;
2761: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
2762: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;

Line 2759: l_default_status ra_cust_trx_types.default_status%type;

2755: x_errmsg OUT NOCOPY VARCHAR2,
2756: x_return_status OUT NOCOPY VARCHAR2) IS
2757:
2758: l_default_printing_option ra_cust_trx_types.default_printing_option%type;
2759: l_default_status ra_cust_trx_types.default_status%type;
2760: l_allow_freight_flag ra_cust_trx_types.allow_freight_flag%type;
2761: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
2762: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;
2763: l_creation_sign ra_cust_trx_types.creation_sign%type;

Line 2760: l_allow_freight_flag ra_cust_trx_types.allow_freight_flag%type;

2756: x_return_status OUT NOCOPY VARCHAR2) IS
2757:
2758: l_default_printing_option ra_cust_trx_types.default_printing_option%type;
2759: l_default_status ra_cust_trx_types.default_status%type;
2760: l_allow_freight_flag ra_cust_trx_types.allow_freight_flag%type;
2761: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
2762: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;
2763: l_creation_sign ra_cust_trx_types.creation_sign%type;
2764: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;

Line 2761: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;

2757:
2758: l_default_printing_option ra_cust_trx_types.default_printing_option%type;
2759: l_default_status ra_cust_trx_types.default_status%type;
2760: l_allow_freight_flag ra_cust_trx_types.allow_freight_flag%type;
2761: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
2762: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;
2763: l_creation_sign ra_cust_trx_types.creation_sign%type;
2764: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;
2765: l_accounting_affect_flag ra_cust_trx_types.accounting_affect_flag%type;

Line 2762: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;

2758: l_default_printing_option ra_cust_trx_types.default_printing_option%type;
2759: l_default_status ra_cust_trx_types.default_status%type;
2760: l_allow_freight_flag ra_cust_trx_types.allow_freight_flag%type;
2761: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
2762: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;
2763: l_creation_sign ra_cust_trx_types.creation_sign%type;
2764: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;
2765: l_accounting_affect_flag ra_cust_trx_types.accounting_affect_flag%type;
2766: l_cust_trx_type_name ra_cust_trx_types.name%type;

Line 2763: l_creation_sign ra_cust_trx_types.creation_sign%type;

2759: l_default_status ra_cust_trx_types.default_status%type;
2760: l_allow_freight_flag ra_cust_trx_types.allow_freight_flag%type;
2761: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
2762: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;
2763: l_creation_sign ra_cust_trx_types.creation_sign%type;
2764: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;
2765: l_accounting_affect_flag ra_cust_trx_types.accounting_affect_flag%type;
2766: l_cust_trx_type_name ra_cust_trx_types.name%type;
2767: l_trx_type ra_cust_trx_types.type%type;

Line 2764: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;

2760: l_allow_freight_flag ra_cust_trx_types.allow_freight_flag%type;
2761: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
2762: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;
2763: l_creation_sign ra_cust_trx_types.creation_sign%type;
2764: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;
2765: l_accounting_affect_flag ra_cust_trx_types.accounting_affect_flag%type;
2766: l_cust_trx_type_name ra_cust_trx_types.name%type;
2767: l_trx_type ra_cust_trx_types.type%type;
2768:

Line 2765: l_accounting_affect_flag ra_cust_trx_types.accounting_affect_flag%type;

2761: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
2762: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;
2763: l_creation_sign ra_cust_trx_types.creation_sign%type;
2764: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;
2765: l_accounting_affect_flag ra_cust_trx_types.accounting_affect_flag%type;
2766: l_cust_trx_type_name ra_cust_trx_types.name%type;
2767: l_trx_type ra_cust_trx_types.type%type;
2768:
2769: CURSOR cust_trx_type_c IS

Line 2766: l_cust_trx_type_name ra_cust_trx_types.name%type;

2762: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;
2763: l_creation_sign ra_cust_trx_types.creation_sign%type;
2764: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;
2765: l_accounting_affect_flag ra_cust_trx_types.accounting_affect_flag%type;
2766: l_cust_trx_type_name ra_cust_trx_types.name%type;
2767: l_trx_type ra_cust_trx_types.type%type;
2768:
2769: CURSOR cust_trx_type_c IS
2770: SELECT distinct cust_trx_type_id

Line 2767: l_trx_type ra_cust_trx_types.type%type;

2763: l_creation_sign ra_cust_trx_types.creation_sign%type;
2764: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;
2765: l_accounting_affect_flag ra_cust_trx_types.accounting_affect_flag%type;
2766: l_cust_trx_type_name ra_cust_trx_types.name%type;
2767: l_trx_type ra_cust_trx_types.type%type;
2768:
2769: CURSOR cust_trx_type_c IS
2770: SELECT distinct cust_trx_type_id
2771: FROM ar_trx_header_gt;

Line 2803: FROM ra_cust_trx_types

2799: l_natural_application_flag,
2800: l_accounting_affect_flag,
2801: l_cust_trx_type_name,
2802: l_trx_type
2803: FROM ra_cust_trx_types
2804: WHERE cust_trx_type_id = cust_trx_type_rec.cust_trx_type_id;
2805:
2806:
2807: IF pg_debug = 'Y'

Line 4597: l_allow_freight_flag ra_cust_trx_types.allow_freight_flag%type;

4593:
4594: -- first get all the freight lines
4595: l_header_freight_count NUMBER;
4596: l_line_freight_count NUMBER;
4597: l_allow_freight_flag ra_cust_trx_types.allow_freight_flag%type;
4598: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
4599: CURSOR c_freight IS
4600: SELECT trx_header_id, count(*) number_of_freight_lines
4601: FROM ar_trx_lines_gt

Line 4598: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;

4594: -- first get all the freight lines
4595: l_header_freight_count NUMBER;
4596: l_line_freight_count NUMBER;
4597: l_allow_freight_flag ra_cust_trx_types.allow_freight_flag%type;
4598: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
4599: CURSOR c_freight IS
4600: SELECT trx_header_id, count(*) number_of_freight_lines
4601: FROM ar_trx_lines_gt
4602: WHERE line_type = 'FREIGHT'

Line 4935: FROM ra_cust_trx_types ctt,

4931: AND NVL(ri.new_customer_trx_id, -98)
4932: <> NVL(gt.customer_trx_id, -99)
4933: UNION
4934: SELECT 'Y' --already exists /*Bug 4080107*/
4935: FROM ra_cust_trx_types ctt,
4936: ra_interface_lines ril
4937: WHERE ril.cust_trx_type_name = ctt.name(+)
4938: AND NVL(ril.cust_trx_type_id,
4939: ctt.cust_trx_type_id) = gt.cust_trx_type_id

Line 7185: --RA_CUST_TRX_TYPES TYPE,

7181: D.ACCTD_AMOUNT),
7182: NULL))
7183: FROM ar_trx_DIST_gt D,
7184: ar_trx_header_gt h
7185: --RA_CUST_TRX_TYPES TYPE,
7186: FND_CURRENCIES C,
7187: GL_SETS_OF_BOOKS G,
7188: --RA_CUSTOMER_TRX PREV_TRX,
7189: ar_trx_LINES_GT L_PARENT,

Line 7232: ra_cust_trx_types ctt

7228: UPDATE ar_trx_dist_gt
7229: SET gl_date = NULL
7230: WHERE trx_header_id IN (SELECT trx_header_id
7231: FROM ar_trx_header_gt gt,
7232: ra_cust_trx_types ctt
7233: WHERE ctt.cust_trx_type_id = gt.cust_trx_type_id
7234: AND ctt.post_to_gl = 'N');
7235:
7236: EXCEPTION