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

Line 13: P_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,

9: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
10: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
11: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
12: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
13: P_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
14: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
15: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
16: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
17: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 54: P_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,

50: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
51: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
52: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
53: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
54: P_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
55: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
56: p_cust_bank_branch_id IN CE_BANK_BRANCHES_V.branch_party_id%TYPE,
57: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
58: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 99: P_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,

95: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
96: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
97: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
98: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
99: P_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
100: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
101: p_cust_bank_branch_id IN CE_BANK_BRANCHES_V.branch_party_id%TYPE,
102: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
103: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 125: P_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,

121: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
122: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
123: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
124: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
125: P_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
126: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
127: p_cust_bank_branch_id IN CE_BANK_BRANCHES_V.branch_party_id%TYPE,
128: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
129: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 143: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,

139: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
140: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
141: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
142: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
143: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
144: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
145: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
146: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
147: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,

Line 166: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,

162: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
163: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
164: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
165: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
166: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
167: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
168: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
169: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
170: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,

Line 188: p_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,

184: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
185: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
186: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
187: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
188: p_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
189: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
190: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
191: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
192: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,

Line 396: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE DEFAULT NULL,

392: p_due_date_low IN VARCHAR2 DEFAULT NULL,
393: p_due_date_high IN VARCHAR2 DEFAULT NULL,
394: p_trx_date_low IN VARCHAR2 DEFAULT NULL,
395: p_trx_date_high IN VARCHAR2 DEFAULT NULL,
396: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE DEFAULT NULL,
397: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE DEFAULT NULL,
398: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE DEFAULT NULL,
399: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE DEFAULT NULL,
400: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE DEFAULT NULL,

Line 618: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,

614: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
615: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
616: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
617: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
618: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
619: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
620: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
621: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
622: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 736: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,

732: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
733: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
734: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
735: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
736: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
737: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
738: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
739: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
740: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 901: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,

897: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
898: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
899: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
900: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
901: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
902: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
903: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
904: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
905: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 1173: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,

1169: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1170: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1171: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
1172: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
1173: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
1174: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
1175: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
1176: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
1177: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 1205: ra_cust_trx_types type,

1201: FROM ra_batches batch,
1202: ar_receipt_classes class,
1203: ar_receipt_methods pm,
1204: ra_customer_trx trx,
1205: ra_cust_trx_types type,
1206: fnd_currencies_vl cur
1207: WHERE pm.receipt_method_id = NVL(p_rcpt_meth_id,pm.receipt_method_id)
1208: AND type.cust_trx_type_id = NVL(p_trx_type_id,type.cust_trx_type_id)
1209: AND trx.trx_number BETWEEN NVL(p_trx_number_low,trx.trx_number) AND NVL(p_trx_number_high,trx.trx_number)

Line 1241: ra_cust_trx_types type,

1237: FROM ra_batches batch,
1238: ar_receipt_classes class,
1239: ar_receipt_methods pm,
1240: ra_customer_trx trx,
1241: ra_cust_trx_types type,
1242: fnd_currencies_vl cur,
1243: iby_trxn_extensions_v extn
1244: WHERE pm.receipt_method_id = rm_id
1245: AND type.cust_trx_type_id = NVL(p_trx_type_id,type.cust_trx_type_id)

Line 2024: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,

2020: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2021: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2022: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2023: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2024: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2025: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
2026: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
2027: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
2028: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,

Line 2064: ra_cust_trx_types type,

2060: 'FROM ra_batches batch,
2061: ar_receipt_methods pm,
2062: ar_payment_schedules ps,
2063: ra_customer_trx trx,
2064: ra_cust_trx_types type,
2065: fnd_currencies_vl cur,
2066: hz_cust_accounts cust,
2067: hz_parties party,
2068: iby_trxn_extensions_v extn

Line 2254: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,

2250: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2251: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2252: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2253: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2254: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2255: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
2256: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
2257: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
2258: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,

Line 2502: p_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,

2498: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2499: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2500: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2501: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2502: p_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
2503: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
2504: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
2505: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
2506: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,

Line 3148: and not exists (select ''x'' from ra_cust_trx_types t

3144: execute immediate l_statement INTO l_due_date_nimm;
3145:
3146: -- Bug 3930958 : exclude CMs when picking trx to base maturity date from
3147: l_statement := 'SELECT MIN(due_date) FROM '||g_tmp_table_imm||' imm WHERE exclude_flag IS NULL
3148: and not exists (select ''x'' from ra_cust_trx_types t
3149: where t.cust_trx_type_id = imm.cust_trx_type_id
3150: and t.type = ''CM'') ';
3151: execute immediate l_statement INTO l_due_date_imm;
3152:

Line 3168: and not exists (select ''x'' from ra_cust_trx_types t

3164: execute immediate l_statement INTO l_due_date_nimm;
3165:
3166: -- Bug 3930958 : exclude CMs when picking trx to base maturity date from
3167: l_statement := 'SELECT MAX(due_date) FROM '||g_tmp_table_imm||' imm WHERE exclude_flag IS NULL
3168: and not exists (select ''x'' from ra_cust_trx_types t
3169: where t.cust_trx_type_id = imm.cust_trx_type_id
3170: and t.type = ''CM'') ';
3171: execute immediate l_statement INTO l_due_date_imm;
3172:

Line 3504: FROM RA_CUST_TRX_TYPES

3500:
3501: BEGIN
3502: SELECT NULL
3503: INTO l_gl_date
3504: FROM RA_CUST_TRX_TYPES
3505: WHERE cust_trx_type_id = l_cust_trx_type_id
3506: AND org_id = l_org_id
3507: AND signed_flag = 'Y'
3508: AND l_created_from = 'ARBRCBAT.fmx';

Line 4000: FROM ra_cust_trx_types type,

3996: the BR type printing option is set to 'Y' */
3997:
3998: SELECT NVL(default_printing_option,'NOT')
3999: into l_default_printing_option
4000: FROM ra_cust_trx_types type,
4001: ra_customer_trx trx
4002: WHERE trx.customer_trx_id = l_bill_id
4003: AND trx.cust_trx_type_id = type.cust_trx_type_id;
4004:

Line 4982: ' ra_cust_trx_types type,'||

4978: to check that the transaction has not been reserved.
4979: */
4980:
4981: l_suffixe_select_statement := ' FROM ar_payment_schedules ps,'||
4982: ' ra_cust_trx_types type,'||
4983: ' ra_customer_trx trx,'||
4984: ' ar_receipt_methods pm '||
4985: 'WHERE ps.cust_trx_type_id = type.cust_trx_type_id '||
4986: 'AND (type.type IN (''INV'',''DEP'',''CB'') OR '||