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 1599: FROM ra_cust_trx_types ctt

1595: FROM ar_trx_header_gt gt
1596: WHERE gt.cust_trx_type_id IS NOT NULL
1597: AND NOT EXISTS (
1598: SELECT 'X'
1599: FROM ra_cust_trx_types ctt
1600: where nvl(gt.trx_date, trunc(sysdate)) between
1601: ctt.start_date and nvl(ctt.end_date, nvl(gt.trx_date, trunc(sysdate)))
1602: and type IN ('INV', 'DM', 'CM') -- added CM for ER 5869149
1603: and ctt.cust_trx_type_id = gt.cust_trx_type_id);

Line 2089: ra_cust_trx_types ctt

2085: SELECT gt.trx_header_id,
2086: arp_standard.fnd_message('AR_INVALID_TERM'),
2087: gt.term_id
2088: FROM ar_trx_header_gt gt,
2089: ra_cust_trx_types ctt
2090: WHERE gt.term_id IS NOT NULL
2091: AND gt.trx_class <> 'CM' -- added for ER 5869149
2092: AND ctt.cust_trx_type_id = gt.cust_trx_type_id -- ER 5869149
2093: AND ctt.type <> 'CM' -- ER 5869149

Line 2112: ra_cust_trx_types ctt

2108: SELECT gt.trx_header_id,
2109: arp_standard.fnd_message('AR_INAPI_TERM_NOT_ALLOWED'),
2110: gt.term_id
2111: FROM ar_trx_header_gt gt,
2112: ra_cust_trx_types ctt
2113: WHERE gt.term_id IS NOT NULL
2114: AND gt.cust_trx_type_id = ctt.cust_trx_type_id
2115: AND ctt.type = 'CM';
2116:

Line 2256: FROM ra_cust_trx_types tt

2252: FROM ar_trx_header_gt gt
2253: WHERE gt.invoicing_rule_id IS NOT NULL
2254: AND gt.cust_trx_type_id NOT IN (
2255: SELECT tt.cust_trx_type_id
2256: FROM ra_cust_trx_types tt
2257: WHERE tt.cust_trx_type_id = gt.cust_trx_type_id
2258: AND tt.type = 'INV' );
2259:
2260: INSERT INTO ar_trx_errors_gt (

Line 2515: ra_cust_trx_types types

2511: WHERE gt.related_customer_trx_id IS NOT NULL
2512: AND NOT EXISTS (
2513: SELECT 'X'
2514: FROM ra_customer_trx trx, ra_batch_sources bs, ar_lookups look,
2515: ra_cust_trx_types types
2516: where trx.batch_source_id = bs.batch_source_id
2517: and trx.cust_trx_type_id = types.cust_trx_type_id
2518: and look.lookup_type = 'INV/CM'
2519: and types.type = look.lookup_code

Line 2565: ra_cust_trx_types tt

2561: CURSOR cglDate IS
2562: select hdr.trx_header_id, hdr.gl_date, hdr.invoicing_rule_id,
2563: NVL(tt.post_to_gl, 'N') post_to_gl
2564: from ar_trx_header_gt hdr,
2565: ra_cust_trx_types tt
2566: where tt.cust_trx_type_id = hdr.cust_trx_type_id;
2567:
2568: l_period_status gl_period_statuses.closing_status%type DEFAULT 'U';
2569: BEGIN

Line 2835: l_default_printing_option ra_cust_trx_types.default_printing_option%type;

2831: PROCEDURE Get_trx_type_details (
2832: x_errmsg OUT NOCOPY VARCHAR2,
2833: x_return_status OUT NOCOPY VARCHAR2) IS
2834:
2835: l_default_printing_option ra_cust_trx_types.default_printing_option%type;
2836: l_default_status ra_cust_trx_types.default_status%type;
2837: l_allow_freight_flag ra_cust_trx_types.allow_freight_flag%type;
2838: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
2839: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;

Line 2836: l_default_status ra_cust_trx_types.default_status%type;

2832: x_errmsg OUT NOCOPY VARCHAR2,
2833: x_return_status OUT NOCOPY VARCHAR2) IS
2834:
2835: l_default_printing_option ra_cust_trx_types.default_printing_option%type;
2836: l_default_status ra_cust_trx_types.default_status%type;
2837: l_allow_freight_flag ra_cust_trx_types.allow_freight_flag%type;
2838: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
2839: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;
2840: l_creation_sign ra_cust_trx_types.creation_sign%type;

Line 2837: l_allow_freight_flag ra_cust_trx_types.allow_freight_flag%type;

2833: x_return_status OUT NOCOPY VARCHAR2) IS
2834:
2835: l_default_printing_option ra_cust_trx_types.default_printing_option%type;
2836: l_default_status ra_cust_trx_types.default_status%type;
2837: l_allow_freight_flag ra_cust_trx_types.allow_freight_flag%type;
2838: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
2839: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;
2840: l_creation_sign ra_cust_trx_types.creation_sign%type;
2841: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;

Line 2838: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;

2834:
2835: l_default_printing_option ra_cust_trx_types.default_printing_option%type;
2836: l_default_status ra_cust_trx_types.default_status%type;
2837: l_allow_freight_flag ra_cust_trx_types.allow_freight_flag%type;
2838: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
2839: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;
2840: l_creation_sign ra_cust_trx_types.creation_sign%type;
2841: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;
2842: l_accounting_affect_flag ra_cust_trx_types.accounting_affect_flag%type;

Line 2839: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;

2835: l_default_printing_option ra_cust_trx_types.default_printing_option%type;
2836: l_default_status ra_cust_trx_types.default_status%type;
2837: l_allow_freight_flag ra_cust_trx_types.allow_freight_flag%type;
2838: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
2839: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;
2840: l_creation_sign ra_cust_trx_types.creation_sign%type;
2841: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;
2842: l_accounting_affect_flag ra_cust_trx_types.accounting_affect_flag%type;
2843: l_cust_trx_type_name ra_cust_trx_types.name%type;

Line 2840: l_creation_sign ra_cust_trx_types.creation_sign%type;

2836: l_default_status ra_cust_trx_types.default_status%type;
2837: l_allow_freight_flag ra_cust_trx_types.allow_freight_flag%type;
2838: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
2839: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;
2840: l_creation_sign ra_cust_trx_types.creation_sign%type;
2841: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;
2842: l_accounting_affect_flag ra_cust_trx_types.accounting_affect_flag%type;
2843: l_cust_trx_type_name ra_cust_trx_types.name%type;
2844: l_trx_type ra_cust_trx_types.type%type;

Line 2841: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;

2837: l_allow_freight_flag ra_cust_trx_types.allow_freight_flag%type;
2838: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
2839: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;
2840: l_creation_sign ra_cust_trx_types.creation_sign%type;
2841: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;
2842: l_accounting_affect_flag ra_cust_trx_types.accounting_affect_flag%type;
2843: l_cust_trx_type_name ra_cust_trx_types.name%type;
2844: l_trx_type ra_cust_trx_types.type%type;
2845:

Line 2842: l_accounting_affect_flag ra_cust_trx_types.accounting_affect_flag%type;

2838: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
2839: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;
2840: l_creation_sign ra_cust_trx_types.creation_sign%type;
2841: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;
2842: l_accounting_affect_flag ra_cust_trx_types.accounting_affect_flag%type;
2843: l_cust_trx_type_name ra_cust_trx_types.name%type;
2844: l_trx_type ra_cust_trx_types.type%type;
2845:
2846: CURSOR cust_trx_type_c IS

Line 2843: l_cust_trx_type_name ra_cust_trx_types.name%type;

2839: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;
2840: l_creation_sign ra_cust_trx_types.creation_sign%type;
2841: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;
2842: l_accounting_affect_flag ra_cust_trx_types.accounting_affect_flag%type;
2843: l_cust_trx_type_name ra_cust_trx_types.name%type;
2844: l_trx_type ra_cust_trx_types.type%type;
2845:
2846: CURSOR cust_trx_type_c IS
2847: SELECT distinct cust_trx_type_id

Line 2844: l_trx_type ra_cust_trx_types.type%type;

2840: l_creation_sign ra_cust_trx_types.creation_sign%type;
2841: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;
2842: l_accounting_affect_flag ra_cust_trx_types.accounting_affect_flag%type;
2843: l_cust_trx_type_name ra_cust_trx_types.name%type;
2844: l_trx_type ra_cust_trx_types.type%type;
2845:
2846: CURSOR cust_trx_type_c IS
2847: SELECT distinct cust_trx_type_id
2848: FROM ar_trx_header_gt;

Line 2880: FROM ra_cust_trx_types

2876: l_natural_application_flag,
2877: l_accounting_affect_flag,
2878: l_cust_trx_type_name,
2879: l_trx_type
2880: FROM ra_cust_trx_types
2881: WHERE cust_trx_type_id = cust_trx_type_rec.cust_trx_type_id;
2882:
2883:
2884: IF pg_debug = 'Y'

Line 4703: l_allow_freight_flag ra_cust_trx_types.allow_freight_flag%type;

4699:
4700: -- first get all the freight lines
4701: l_header_freight_count NUMBER;
4702: l_line_freight_count NUMBER;
4703: l_allow_freight_flag ra_cust_trx_types.allow_freight_flag%type;
4704: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
4705: CURSOR c_freight IS
4706: SELECT trx_header_id, count(*) number_of_freight_lines
4707: FROM ar_trx_lines_gt

Line 4704: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;

4700: -- first get all the freight lines
4701: l_header_freight_count NUMBER;
4702: l_line_freight_count NUMBER;
4703: l_allow_freight_flag ra_cust_trx_types.allow_freight_flag%type;
4704: l_cust_trx_type_id ra_cust_trx_types.cust_trx_type_id%type;
4705: CURSOR c_freight IS
4706: SELECT trx_header_id, count(*) number_of_freight_lines
4707: FROM ar_trx_lines_gt
4708: WHERE line_type = 'FREIGHT'

Line 5062: FROM ra_cust_trx_types ctt,

5058: AND NVL(ri.new_customer_trx_id, -98)
5059: <> NVL(gt.customer_trx_id, -99)
5060: UNION
5061: SELECT 'Y' --already exists /*Bug 4080107*/
5062: FROM ra_cust_trx_types ctt,
5063: ra_interface_lines ril
5064: WHERE ril.cust_trx_type_name = ctt.name(+)
5065: AND NVL(ril.cust_trx_type_id,
5066: ctt.cust_trx_type_id) = gt.cust_trx_type_id

Line 7524: --RA_CUST_TRX_TYPES TYPE,

7520: D.ACCTD_AMOUNT),
7521: NULL))
7522: FROM ar_trx_DIST_gt D,
7523: ar_trx_header_gt h
7524: --RA_CUST_TRX_TYPES TYPE,
7525: FND_CURRENCIES C,
7526: GL_SETS_OF_BOOKS G,
7527: --RA_CUSTOMER_TRX PREV_TRX,
7528: ar_trx_LINES_GT L_PARENT,

Line 7571: ra_cust_trx_types ctt

7567: UPDATE ar_trx_dist_gt
7568: SET gl_date = NULL
7569: WHERE trx_header_id IN (SELECT trx_header_id
7570: FROM ar_trx_header_gt gt,
7571: ra_cust_trx_types ctt
7572: WHERE ctt.cust_trx_type_id = gt.cust_trx_type_id
7573: AND ctt.post_to_gl = 'N');
7574:
7575: EXCEPTION