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

Line 691: ra_cust_trx_types ctt

687: 'GUAR', 'Y',
688: 'N')
689: INTO l_activity_flag
690: FROM ra_customer_trx ct,
691: ra_cust_trx_types ctt
692: WHERE ct.cust_trx_type_id = ctt.cust_trx_type_id
693: AND ct.customer_trx_id = p_initial_customer_trx_id
694: --begin anuj
695: /* Multi-Org Access Control Changes for SSA;Begin;anukumar;11/01/2002*/

Line 1614: ra_cust_trx_types inv_type,

1610: SELECT 'commitments_exist'
1611: FROM hz_cust_accounts cust_acct,
1612: so_agreements soa,
1613: hz_cust_acct_sites acct_site,
1614: ra_cust_trx_types inv_type,
1615: ra_cust_trx_types type,
1616: ra_customer_trx trx
1617: WHERE trx.cust_trx_type_id = type.cust_trx_type_id
1618: AND trx.bill_to_customer_id = cust_acct.cust_account_id

Line 1615: ra_cust_trx_types type,

1611: FROM hz_cust_accounts cust_acct,
1612: so_agreements soa,
1613: hz_cust_acct_sites acct_site,
1614: ra_cust_trx_types inv_type,
1615: ra_cust_trx_types type,
1616: ra_customer_trx trx
1617: WHERE trx.cust_trx_type_id = type.cust_trx_type_id
1618: AND trx.bill_to_customer_id = cust_acct.cust_account_id
1619: AND trx.remit_to_address_id = acct_site.cust_acct_site_id(+)

Line 2342: l_name ra_cust_trx_types.name%type;

2338: FUNCTION get_trx_type_details(p_trx_type_id IN NUMBER,
2339: p_detail_type IN VARCHAR2,
2340: p_org_id IN NUMBER DEFAULT NULL) /* Bug fix 5462362*/
2341: RETURN VARCHAR2 IS
2342: l_name ra_cust_trx_types.name%type;
2343: l_type ra_cust_trx_types.type%type;
2344: l_subseq_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%type;
2345: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;
2346: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;

Line 2343: l_type ra_cust_trx_types.type%type;

2339: p_detail_type IN VARCHAR2,
2340: p_org_id IN NUMBER DEFAULT NULL) /* Bug fix 5462362*/
2341: RETURN VARCHAR2 IS
2342: l_name ra_cust_trx_types.name%type;
2343: l_type ra_cust_trx_types.type%type;
2344: l_subseq_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%type;
2345: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;
2346: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;
2347: l_creation_sign ra_cust_trx_types.creation_sign%type;

Line 2344: l_subseq_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%type;

2340: p_org_id IN NUMBER DEFAULT NULL) /* Bug fix 5462362*/
2341: RETURN VARCHAR2 IS
2342: l_name ra_cust_trx_types.name%type;
2343: l_type ra_cust_trx_types.type%type;
2344: l_subseq_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%type;
2345: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;
2346: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;
2347: l_creation_sign ra_cust_trx_types.creation_sign%type;
2348: -- Bug 4221745

Line 2345: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;

2341: RETURN VARCHAR2 IS
2342: l_name ra_cust_trx_types.name%type;
2343: l_type ra_cust_trx_types.type%type;
2344: l_subseq_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%type;
2345: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;
2346: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;
2347: l_creation_sign ra_cust_trx_types.creation_sign%type;
2348: -- Bug 4221745
2349: l_post_to_gl ra_cust_trx_types.post_to_gl%type;

Line 2346: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;

2342: l_name ra_cust_trx_types.name%type;
2343: l_type ra_cust_trx_types.type%type;
2344: l_subseq_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%type;
2345: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;
2346: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;
2347: l_creation_sign ra_cust_trx_types.creation_sign%type;
2348: -- Bug 4221745
2349: l_post_to_gl ra_cust_trx_types.post_to_gl%type;
2350: BEGIN

Line 2347: l_creation_sign ra_cust_trx_types.creation_sign%type;

2343: l_type ra_cust_trx_types.type%type;
2344: l_subseq_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%type;
2345: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;
2346: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;
2347: l_creation_sign ra_cust_trx_types.creation_sign%type;
2348: -- Bug 4221745
2349: l_post_to_gl ra_cust_trx_types.post_to_gl%type;
2350: BEGIN
2351: IF p_trx_type_id IS NOT NULL THEN

Line 2349: l_post_to_gl ra_cust_trx_types.post_to_gl%type;

2345: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;
2346: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;
2347: l_creation_sign ra_cust_trx_types.creation_sign%type;
2348: -- Bug 4221745
2349: l_post_to_gl ra_cust_trx_types.post_to_gl%type;
2350: BEGIN
2351: IF p_trx_type_id IS NOT NULL THEN
2352:
2353: IF pg_trx_type_rec.EXISTS(p_trx_type_id) THEN

Line 2373: FROM ra_cust_trx_types_all

2369: INTO l_name, l_type, l_subseq_trx_type_id,
2370: l_allow_overapplication_flag ,
2371: l_natural_application_flag,
2372: l_creation_sign, l_post_to_gl
2373: FROM ra_cust_trx_types_all
2374: WHERE cust_trx_type_id = p_trx_type_id
2375: AND org_id = p_org_id;
2376: EXCEPTION WHEN OTHERS THEN
2377: return('-99999999');

Line 2389: FROM ra_cust_trx_types

2385: INTO l_name, l_type, l_subseq_trx_type_id,
2386: l_allow_overapplication_flag ,
2387: l_natural_application_flag,
2388: l_creation_sign, l_post_to_gl
2389: FROM ra_cust_trx_types
2390: WHERE cust_trx_type_id = p_trx_type_id;
2391: EXCEPTION
2392: WHEN NO_DATA_FOUND THEN
2393: -- bug 4221745 : when running for Operating Unit, try from _ALL table

Line 2403: FROM ra_cust_trx_types_all

2399: INTO l_name, l_type, l_subseq_trx_type_id,
2400: l_allow_overapplication_flag ,
2401: l_natural_application_flag,
2402: l_creation_sign, l_post_to_gl
2403: FROM ra_cust_trx_types_all
2404: WHERE cust_trx_type_id = p_trx_type_id;
2405: EXCEPTION
2406: WHEN NO_DATA_FOUND THEN
2407: return('-99999999');

Line 2865: l_trx_name ra_cust_trx_types.name%type;

2861:
2862: p_concat_segments varchar2(100);
2863: tab_indx BINARY_INTEGER := 0;
2864: found BOOLEAN ;
2865: l_trx_name ra_cust_trx_types.name%type;
2866: l_hash_value NUMBER;
2867: BEGIN
2868: /*----------------------------------------------------------------+
2869: | Search the cache for the concantenated segments. |

Line 2916: FROM ra_cust_trx_types_all

2912: ELSE
2913:
2914: SELECT name
2915: INTO l_trx_name
2916: FROM ra_cust_trx_types_all
2917: WHERE cust_trx_type_id = p_trx_type_id
2918: AND NVL(org_id,-99) = NVL(p_org_id,-99);
2919:
2920: