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 AR_LOOKUPS

Line 18: p_cust_class IN AR_LOOKUPS.lookup_code%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,
18: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
19: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
20: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
21: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE);
22:

Line 19: p_cust_category IN AR_LOOKUPS.lookup_code%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,
18: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
19: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
20: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
21: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE);
22:
23:

Line 59: p_cust_class IN AR_LOOKUPS.lookup_code%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,
59: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
60: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
61: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
62: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE);
63:

Line 60: p_cust_category IN AR_LOOKUPS.lookup_code%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,
59: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
60: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
61: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
62: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE);
63:
64: PROCEDURE arbr_cr_tmp_table;

Line 104: p_cust_class IN AR_LOOKUPS.lookup_code%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,
104: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
105: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
106: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
107: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
108: p_batch_id OUT NOCOPY RA_BATCHES.batch_id%TYPE,

Line 105: p_cust_category IN AR_LOOKUPS.lookup_code%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,
104: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
105: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
106: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
107: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
108: p_batch_id OUT NOCOPY RA_BATCHES.batch_id%TYPE,
109: p_selection_criteria_id OUT NOCOPY RA_BATCHES.selection_criteria_id%TYPE);

Line 130: p_cust_class IN AR_LOOKUPS.lookup_code%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,
130: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
131: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
132: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
133: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE);
134:

Line 131: p_cust_category IN AR_LOOKUPS.lookup_code%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,
130: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
131: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
132: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
133: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE);
134:
135: -- Bug 3922691 : added additional parameters so dynamic sql can be more fine-tuned

Line 146: p_cust_class IN AR_LOOKUPS.lookup_code%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,
148: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
149: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
150: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE);

Line 147: p_cust_category IN AR_LOOKUPS.lookup_code%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,
148: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
149: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
150: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE);
151:

Line 169: p_cust_class IN AR_LOOKUPS.lookup_code%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,
171: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
172: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
173: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,

Line 170: p_cust_category IN AR_LOOKUPS.lookup_code%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,
171: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
172: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
173: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
174: p_batch_id IN RA_BATCHES.batch_id%TYPE,

Line 191: p_cust_class IN AR_LOOKUPS.lookup_code%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,
193: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
194: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
195: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,

Line 192: p_cust_category IN AR_LOOKUPS.lookup_code%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,
193: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
194: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
195: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
196: p_batch_id IN RA_BATCHES.batch_id%TYPE,

Line 401: p_cust_class IN AR_LOOKUPS.lookup_code%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,
401: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE DEFAULT NULL,
402: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE DEFAULT NULL,
403: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE DEFAULT NULL,
404: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE DEFAULT NULL) IS
405:

Line 402: p_cust_category IN AR_LOOKUPS.lookup_code%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,
401: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE DEFAULT NULL,
402: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE DEFAULT NULL,
403: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE DEFAULT NULL,
404: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE DEFAULT NULL) IS
405:
406: -- Dates

Line 623: p_cust_class IN AR_LOOKUPS.lookup_code%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,
623: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
624: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
625: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
626: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE) IS
627:

Line 624: p_cust_category IN AR_LOOKUPS.lookup_code%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,
623: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
624: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
625: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
626: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE) IS
627:
628: l_request_id NUMBER;

Line 741: p_cust_class IN AR_LOOKUPS.lookup_code%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,
741: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
742: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
743: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
744: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE) IS
745:

Line 742: p_cust_category IN AR_LOOKUPS.lookup_code%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,
741: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
742: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
743: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
744: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE) IS
745:
746: l_batch_id RA_BATCHES.batch_id%TYPE;

Line 906: p_cust_class IN AR_LOOKUPS.lookup_code%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,
906: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
907: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
908: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
909: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
910: p_batch_id OUT NOCOPY RA_BATCHES.batch_id%TYPE,

Line 907: p_cust_category IN AR_LOOKUPS.lookup_code%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,
906: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
907: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
908: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
909: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
910: p_batch_id OUT NOCOPY RA_BATCHES.batch_id%TYPE,
911: p_selection_criteria_id OUT NOCOPY

Line 1178: p_cust_class IN AR_LOOKUPS.lookup_code%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,
1178: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
1179: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
1180: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
1181: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE) IS
1182:

Line 1179: p_cust_category IN AR_LOOKUPS.lookup_code%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,
1178: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
1179: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
1180: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
1181: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE) IS
1182:
1183: /*

Line 2027: p_cust_class IN AR_LOOKUPS.lookup_code%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,
2029: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
2030: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
2031: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE

Line 2028: p_cust_category IN AR_LOOKUPS.lookup_code%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,
2029: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
2030: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
2031: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE
2032: ) IS

Line 2257: p_cust_class IN AR_LOOKUPS.lookup_code%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,
2259: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
2260: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
2261: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,

Line 2258: p_cust_category IN AR_LOOKUPS.lookup_code%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,
2259: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
2260: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
2261: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
2262: p_batch_id IN RA_BATCHES.batch_id%TYPE,

Line 2505: p_cust_class IN AR_LOOKUPS.lookup_code%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,
2507: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
2508: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
2509: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,

Line 2506: p_cust_category IN AR_LOOKUPS.lookup_code%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,
2507: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
2508: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
2509: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
2510: p_batch_id IN RA_BATCHES.batch_id%TYPE,

Line 4673: FROM AR_LOOKUPS

4669:
4670: -- parameter l_version must be 'D' for detail
4671: SELECT LOOKUP_CODE, MEANING
4672: INTO l_version, l_meaning
4673: FROM AR_LOOKUPS
4674: WHERE LOOKUP_TYPE = 'ARBRATBR_REPORT_TYPE'
4675: AND LOOKUP_CODE = 'D';
4676:
4677: FND_FILE.PUT_LINE(FND_FILE.LOG,'------------- Automatic Transactions Batch Report Parameters ---------------');