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 389: p_cust_class IN AR_LOOKUPS.lookup_code%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,
389: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE DEFAULT NULL,
390: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE DEFAULT NULL,
391: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE DEFAULT NULL,
392: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE DEFAULT NULL) IS
393:

Line 390: p_cust_category IN AR_LOOKUPS.lookup_code%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,
389: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE DEFAULT NULL,
390: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE DEFAULT NULL,
391: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE DEFAULT NULL,
392: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE DEFAULT NULL) IS
393:
394: -- Dates

Line 603: p_cust_class IN AR_LOOKUPS.lookup_code%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,
603: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
604: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
605: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
606: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE) IS
607:

Line 604: p_cust_category IN AR_LOOKUPS.lookup_code%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,
603: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
604: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
605: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
606: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE) IS
607:
608: l_request_id NUMBER;

Line 721: p_cust_class IN AR_LOOKUPS.lookup_code%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,
721: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
722: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
723: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
724: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE) IS
725:

Line 722: p_cust_category IN AR_LOOKUPS.lookup_code%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,
721: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
722: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
723: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
724: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE) IS
725:
726: l_batch_id RA_BATCHES.batch_id%TYPE;

Line 886: p_cust_class IN AR_LOOKUPS.lookup_code%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,
886: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
887: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
888: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
889: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
890: p_batch_id OUT NOCOPY RA_BATCHES.batch_id%TYPE,

Line 887: p_cust_category IN AR_LOOKUPS.lookup_code%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,
886: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
887: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
888: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
889: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
890: p_batch_id OUT NOCOPY RA_BATCHES.batch_id%TYPE,
891: p_selection_criteria_id OUT NOCOPY

Line 1159: p_cust_class IN AR_LOOKUPS.lookup_code%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,
1159: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
1160: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
1161: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
1162: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE) IS
1163:

Line 1160: p_cust_category IN AR_LOOKUPS.lookup_code%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,
1159: p_cust_class IN AR_LOOKUPS.lookup_code%TYPE,
1160: p_cust_category IN AR_LOOKUPS.lookup_code%TYPE,
1161: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
1162: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE) IS
1163:
1164: /*

Line 1878: p_cust_class IN AR_LOOKUPS.lookup_code%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,
1880: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
1881: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
1882: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE

Line 1879: p_cust_category IN AR_LOOKUPS.lookup_code%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,
1880: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
1881: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
1882: p_le_id IN RA_CUSTOMER_TRX.legal_entity_id%TYPE
1883: ) IS

Line 2116: p_cust_class IN AR_LOOKUPS.lookup_code%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,
2118: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
2119: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
2120: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,

Line 2117: p_cust_category IN AR_LOOKUPS.lookup_code%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,
2118: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
2119: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
2120: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
2121: p_batch_id IN RA_BATCHES.batch_id%TYPE,

Line 2364: p_cust_class IN AR_LOOKUPS.lookup_code%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,
2366: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
2367: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
2368: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,

Line 2365: p_cust_category IN AR_LOOKUPS.lookup_code%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,
2366: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
2367: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE,
2368: p_receipt_method_id IN AR_RECEIPT_METHODS.receipt_method_id%TYPE,
2369: p_batch_id IN RA_BATCHES.batch_id%TYPE,

Line 4514: FROM AR_LOOKUPS

4510:
4511: -- parameter l_version must be 'D' for detail
4512: SELECT LOOKUP_CODE, MEANING
4513: INTO l_version, l_meaning
4514: FROM AR_LOOKUPS
4515: WHERE LOOKUP_TYPE = 'ARBRATBR_REPORT_TYPE'
4516: AND LOOKUP_CODE = 'D';
4517:
4518: FND_FILE.PUT_LINE(FND_FILE.LOG,'------------- Automatic Transactions Batch Report Parameters ---------------');