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 759: ra_cust_trx_types ctt

755: 'GUAR', 'Y',
756: 'N')
757: INTO l_activity_flag
758: FROM ra_customer_trx ct,
759: ra_cust_trx_types ctt
760: WHERE ct.cust_trx_type_id = ctt.cust_trx_type_id
761: AND ct.customer_trx_id = p_initial_customer_trx_id
762: --begin anuj
763: /* Multi-Org Access Control Changes for SSA;Begin;anukumar;11/01/2002*/

Line 1704: ra_cust_trx_types inv_type,

1700: SELECT 'commitments_exist'
1701: FROM hz_cust_accounts cust_acct,
1702: so_agreements soa,
1703: hz_cust_acct_sites acct_site,
1704: ra_cust_trx_types inv_type,
1705: ra_cust_trx_types type,
1706: ra_customer_trx trx
1707: WHERE trx.cust_trx_type_id = type.cust_trx_type_id
1708: AND trx.bill_to_customer_id = cust_acct.cust_account_id

Line 1705: ra_cust_trx_types type,

1701: FROM hz_cust_accounts cust_acct,
1702: so_agreements soa,
1703: hz_cust_acct_sites acct_site,
1704: ra_cust_trx_types inv_type,
1705: ra_cust_trx_types type,
1706: ra_customer_trx trx
1707: WHERE trx.cust_trx_type_id = type.cust_trx_type_id
1708: AND trx.bill_to_customer_id = cust_acct.cust_account_id
1709: AND trx.remit_to_address_id = acct_site.cust_acct_site_id(+)

Line 2461: l_name ra_cust_trx_types.name%type;

2457: FUNCTION get_trx_type_details(p_trx_type_id IN NUMBER,
2458: p_detail_type IN VARCHAR2,
2459: p_org_id IN NUMBER DEFAULT NULL) /* Bug fix 5462362*/
2460: RETURN VARCHAR2 IS
2461: l_name ra_cust_trx_types.name%type;
2462: l_type ra_cust_trx_types.type%type;
2463: l_subseq_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%type;
2464: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;
2465: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;

Line 2462: l_type ra_cust_trx_types.type%type;

2458: p_detail_type IN VARCHAR2,
2459: p_org_id IN NUMBER DEFAULT NULL) /* Bug fix 5462362*/
2460: RETURN VARCHAR2 IS
2461: l_name ra_cust_trx_types.name%type;
2462: l_type ra_cust_trx_types.type%type;
2463: l_subseq_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%type;
2464: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;
2465: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;
2466: l_creation_sign ra_cust_trx_types.creation_sign%type;

Line 2463: l_subseq_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%type;

2459: p_org_id IN NUMBER DEFAULT NULL) /* Bug fix 5462362*/
2460: RETURN VARCHAR2 IS
2461: l_name ra_cust_trx_types.name%type;
2462: l_type ra_cust_trx_types.type%type;
2463: l_subseq_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%type;
2464: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;
2465: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;
2466: l_creation_sign ra_cust_trx_types.creation_sign%type;
2467: -- Bug 4221745

Line 2464: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;

2460: RETURN VARCHAR2 IS
2461: l_name ra_cust_trx_types.name%type;
2462: l_type ra_cust_trx_types.type%type;
2463: l_subseq_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%type;
2464: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;
2465: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;
2466: l_creation_sign ra_cust_trx_types.creation_sign%type;
2467: -- Bug 4221745
2468: l_post_to_gl ra_cust_trx_types.post_to_gl%type;

Line 2465: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;

2461: l_name ra_cust_trx_types.name%type;
2462: l_type ra_cust_trx_types.type%type;
2463: l_subseq_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%type;
2464: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;
2465: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;
2466: l_creation_sign ra_cust_trx_types.creation_sign%type;
2467: -- Bug 4221745
2468: l_post_to_gl ra_cust_trx_types.post_to_gl%type;
2469: BEGIN

Line 2466: l_creation_sign ra_cust_trx_types.creation_sign%type;

2462: l_type ra_cust_trx_types.type%type;
2463: l_subseq_trx_type_id ra_cust_trx_types.subsequent_trx_type_id%type;
2464: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;
2465: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;
2466: l_creation_sign ra_cust_trx_types.creation_sign%type;
2467: -- Bug 4221745
2468: l_post_to_gl ra_cust_trx_types.post_to_gl%type;
2469: BEGIN
2470: IF p_trx_type_id IS NOT NULL THEN

Line 2468: l_post_to_gl ra_cust_trx_types.post_to_gl%type;

2464: l_allow_overapplication_flag ra_cust_trx_types.allow_overapplication_flag%type;
2465: l_natural_application_flag ra_cust_trx_types.natural_application_only_flag%type;
2466: l_creation_sign ra_cust_trx_types.creation_sign%type;
2467: -- Bug 4221745
2468: l_post_to_gl ra_cust_trx_types.post_to_gl%type;
2469: BEGIN
2470: IF p_trx_type_id IS NOT NULL THEN
2471:
2472: IF pg_trx_type_rec.EXISTS(p_trx_type_id) THEN

Line 2492: FROM ra_cust_trx_types_all

2488: INTO l_name, l_type, l_subseq_trx_type_id,
2489: l_allow_overapplication_flag ,
2490: l_natural_application_flag,
2491: l_creation_sign, l_post_to_gl
2492: FROM ra_cust_trx_types_all
2493: WHERE cust_trx_type_id = p_trx_type_id
2494: AND org_id = p_org_id;
2495: EXCEPTION WHEN OTHERS THEN
2496: return('-99999999');

Line 2508: FROM ra_cust_trx_types

2504: INTO l_name, l_type, l_subseq_trx_type_id,
2505: l_allow_overapplication_flag ,
2506: l_natural_application_flag,
2507: l_creation_sign, l_post_to_gl
2508: FROM ra_cust_trx_types
2509: WHERE cust_trx_type_id = p_trx_type_id;
2510: EXCEPTION
2511: WHEN NO_DATA_FOUND THEN
2512: -- bug 4221745 : when running for Operating Unit, try from _ALL table

Line 2522: FROM ra_cust_trx_types_all

2518: INTO l_name, l_type, l_subseq_trx_type_id,
2519: l_allow_overapplication_flag ,
2520: l_natural_application_flag,
2521: l_creation_sign, l_post_to_gl
2522: FROM ra_cust_trx_types_all
2523: WHERE cust_trx_type_id = p_trx_type_id;
2524: EXCEPTION
2525: WHEN NO_DATA_FOUND THEN
2526: return('-99999999');

Line 2984: l_trx_name ra_cust_trx_types.name%type;

2980:
2981: p_concat_segments varchar2(100);
2982: tab_indx BINARY_INTEGER := 0;
2983: found BOOLEAN ;
2984: l_trx_name ra_cust_trx_types.name%type;
2985: l_hash_value NUMBER;
2986: BEGIN
2987: /*----------------------------------------------------------------+
2988: | Search the cache for the concantenated segments. |

Line 3035: FROM ra_cust_trx_types_all

3031: ELSE
3032:
3033: SELECT name
3034: INTO l_trx_name
3035: FROM ra_cust_trx_types_all
3036: WHERE cust_trx_type_id = p_trx_type_id
3037: AND NVL(org_id,-99) = NVL(p_org_id,-99);
3038:
3039: