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 384: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE DEFAULT NULL,

380: p_due_date_low IN VARCHAR2 DEFAULT NULL,
381: p_due_date_high IN VARCHAR2 DEFAULT NULL,
382: p_trx_date_low IN VARCHAR2 DEFAULT NULL,
383: p_trx_date_high IN VARCHAR2 DEFAULT NULL,
384: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE DEFAULT NULL,
385: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE DEFAULT NULL,
386: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE DEFAULT NULL,
387: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE DEFAULT NULL,
388: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE DEFAULT NULL,

Line 598: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,

594: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
595: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
596: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
597: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
598: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
599: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
600: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
601: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
602: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 716: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,

712: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
713: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
714: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
715: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
716: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
717: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
718: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
719: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
720: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 881: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,

877: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
878: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
879: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
880: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
881: P_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
882: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
883: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
884: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
885: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 1154: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,

1150: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1151: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1152: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
1153: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
1154: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
1155: p_rcpt_meth_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
1156: p_cust_bank_branch_id IN ce_bank_branches_v.branch_party_id%TYPE,
1157: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
1158: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,

Line 1183: ra_cust_trx_types type,

1179: FROM ra_batches batch,
1180: ar_receipt_classes class,
1181: ar_receipt_methods pm,
1182: ra_customer_trx trx,
1183: ra_cust_trx_types type,
1184: fnd_currencies_vl cur
1185: WHERE pm.receipt_method_id = NVL(p_rcpt_meth_id,pm.receipt_method_id)
1186: AND type.cust_trx_type_id = NVL(p_trx_type_id,type.cust_trx_type_id)
1187: AND trx.trx_number BETWEEN NVL(p_trx_number_low,trx.trx_number) AND NVL(p_trx_number_high,trx.trx_number)

Line 1220: ra_cust_trx_types type,

1216: FROM ra_batches batch,
1217: ar_receipt_classes class,
1218: ar_receipt_methods pm,
1219: ra_customer_trx trx,
1220: ra_cust_trx_types type,
1221: fnd_currencies_vl cur,
1222: iby_trxn_extensions_v extn
1223: WHERE pm.receipt_method_id = rm_id
1224: AND type.cust_trx_type_id = NVL(p_trx_type_id,type.cust_trx_type_id)

Line 1875: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,

1871: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1872: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
1873: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
1874: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
1875: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
1876: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
1877: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
1878: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
1879: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,

Line 1915: ra_cust_trx_types type,

1911: 'FROM ra_batches batch,
1912: ar_receipt_methods pm,
1913: ar_payment_schedules ps,
1914: ra_customer_trx trx,
1915: ra_cust_trx_types type,
1916: fnd_currencies_vl cur,
1917: hz_cust_accounts cust,
1918: hz_parties party,
1919: iby_trxn_extensions_v extn

Line 2113: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,

2109: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2110: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2111: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2112: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2113: p_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%TYPE,
2114: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
2115: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
2116: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
2117: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,

Line 2361: p_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,

2357: p_due_date_low IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2358: p_due_date_high IN AR_PAYMENT_SCHEDULES.due_date%TYPE,
2359: p_trx_date_low IN RA_CUSTOMER_TRX.trx_date%TYPE,
2360: p_trx_date_high IN RA_CUSTOMER_TRX.trx_date%TYPE,
2361: p_trx_type_id IN RA_CUST_TRX_TYPES.cust_trx_type_id%TYPE,
2362: p_trx_number_low IN RA_CUSTOMER_TRX.trx_number%TYPE,
2363: p_trx_number_high IN RA_CUSTOMER_TRX.trx_number%TYPE,
2364: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
2365: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,

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

3002: execute immediate l_statement INTO l_due_date_nimm;
3003:
3004: -- Bug 3930958 : exclude CMs when picking trx to base maturity date from
3005: l_statement := 'SELECT MIN(due_date) FROM '||g_tmp_table_imm||' imm WHERE exclude_flag IS NULL
3006: and not exists (select ''x'' from ra_cust_trx_types t
3007: where t.cust_trx_type_id = imm.cust_trx_type_id
3008: and t.type = ''CM'') ';
3009: execute immediate l_statement INTO l_due_date_imm;
3010:

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

3022: execute immediate l_statement INTO l_due_date_nimm;
3023:
3024: -- Bug 3930958 : exclude CMs when picking trx to base maturity date from
3025: l_statement := 'SELECT MAX(due_date) FROM '||g_tmp_table_imm||' imm WHERE exclude_flag IS NULL
3026: and not exists (select ''x'' from ra_cust_trx_types t
3027: where t.cust_trx_type_id = imm.cust_trx_type_id
3028: and t.type = ''CM'') ';
3029: execute immediate l_statement INTO l_due_date_imm;
3030:

Line 3841: FROM ra_cust_trx_types type,

3837: the BR type printing option is set to 'Y' */
3838:
3839: SELECT NVL(default_printing_option,'NOT')
3840: into l_default_printing_option
3841: FROM ra_cust_trx_types type,
3842: ra_customer_trx trx
3843: WHERE trx.customer_trx_id = l_bill_id
3844: AND trx.cust_trx_type_id = type.cust_trx_type_id;
3845:

Line 4823: ' ra_cust_trx_types type,'||

4819: to check that the transaction has not been reserved.
4820: */
4821:
4822: l_suffixe_select_statement := ' FROM ar_payment_schedules ps,'||
4823: ' ra_cust_trx_types type,'||
4824: ' ra_customer_trx trx,'||
4825: ' ar_receipt_methods pm '||
4826: 'WHERE ps.cust_trx_type_id = type.cust_trx_type_id '||
4827: 'AND (type.type IN (''INV'',''DEP'',''CB'') OR '||