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 HZ_CUST_ACCOUNTS

Line 20: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_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:
24: PROCEDURE from_conc_request_window(

Line 61: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_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;
65:

Line 106: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_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);
110:

Line 132: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_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
136: PROCEDURE construct_suffixe_select(

Line 148: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_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:
152: -- bug 3922691 : consolidate code used in 2 procedures

Line 155: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,

151:
152: -- bug 3922691 : consolidate code used in 2 procedures
153: PROCEDURE construct_hz(
154: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
155: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
156: p_suffix_hz OUT NOCOPY varchar2);
157:
158: -- bug 3922691 : remove p_suffixe_select_statement, add p_lead_days
159: PROCEDURE select_DM_and_CM_IMM(

Line 171: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_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,
175: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,

Line 193: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_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,
197: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,

Line 391: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_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
395: l_batch_date DATE := NULL;

Line 605: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_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;
609:

Line 723: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_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;
727: l_selection_criteria_id RA_BATCHES.selection_criteria_id%TYPE;

Line 888: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_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
892: RA_BATCHES.selection_criteria_id%TYPE) IS

Line 1161: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_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: /*
1165: Bug 1808967 : added trx.customer_bank_account_id in select statement,

Line 1284: l_customer_id HZ_CUST_ACCOUNTS.cust_account_id%TYPE;

1280:
1281: c_grouping cur_typ;
1282:
1283: -- 2nd break criteria
1284: l_customer_id HZ_CUST_ACCOUNTS.cust_account_id%TYPE;
1285: l_customer_id2 HZ_CUST_ACCOUNTS.cust_account_id%TYPE;
1286: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
1287: l_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
1288: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;

Line 1285: l_customer_id2 HZ_CUST_ACCOUNTS.cust_account_id%TYPE;

1281: c_grouping cur_typ;
1282:
1283: -- 2nd break criteria
1284: l_customer_id HZ_CUST_ACCOUNTS.cust_account_id%TYPE;
1285: l_customer_id2 HZ_CUST_ACCOUNTS.cust_account_id%TYPE;
1286: l_due_date AR_PAYMENT_SCHEDULES.due_date%TYPE;
1287: l_site_use_id AR_PAYMENT_SCHEDULES.customer_site_use_id%TYPE;
1288: l_customer_trx_id AR_PAYMENT_SCHEDULES.customer_trx_id%TYPE;
1289: l_payment_schedule_id AR_PAYMENT_SCHEDULES.payment_schedule_id%TYPE;

Line 1767: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,

1763: +===========================================================================*/
1764:
1765: PROCEDURE construct_hz(
1766: p_receipt_creation_rule_code IN AR_RECEIPT_METHODS.receipt_creation_rule_code%TYPE,
1767: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_id%TYPE,
1768: p_suffix_hz OUT NOCOPY varchar2) IS
1769:
1770: l_trx_select_statement VARCHAR2(4000) := NULL;
1771:

Line 1880: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_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
1884:

Line 1917: hz_cust_accounts cust,

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
1920: WHERE trx.customer_trx_id = ps.customer_trx_id
1921: ';

Line 2118: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_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,
2122: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,

Line 2366: p_customer_id IN HZ_CUST_ACCOUNTS.cust_account_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,
2370: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,

Line 3160: FROM hz_cust_accounts cust_acct,

3156: SELECT site_uses.site_use_id,
3157: site_uses.contact_id,
3158: Null external_bank_account_id
3159: INTO l_drawee_site_use_id, l_drawee_contact_id, l_drawee_bank_account_id
3160: FROM hz_cust_accounts cust_acct,
3161: hz_cust_acct_sites acct_site,
3162: hz_cust_site_uses site_uses,
3163: hz_cust_account_roles acct_role
3164: WHERE cust_acct.cust_account_id = l_drawee_id

Line 3180: FROM hz_cust_accounts cust_acct,

3176: SELECT site_uses.site_use_id,
3177: site_uses.contact_id,
3178: Null external_bank_account_id
3179: INTO l_drawee_site_use_id, l_drawee_contact_id, l_drawee_bank_account_id
3180: FROM hz_cust_accounts cust_acct,
3181: hz_cust_acct_sites acct_site,
3182: hz_cust_site_uses site_uses,
3183: hz_cust_account_roles acct_role,
3184: hz_party_sites party_site

Line 3193: FROM hz_cust_accounts bcust_acct,

3189: AND site_uses.status = 'A'
3190: AND acct_site.party_site_id = party_site.party_site_id
3191: AND party_site.location_id =
3192: (select bloc.location_id
3193: FROM hz_cust_accounts bcust_acct,
3194: hz_cust_acct_sites bacct_site,
3195: hz_cust_site_uses bsite_uses,
3196: hz_party_sites bparty_site,
3197: hz_locations bloc

Line 3241: FROM hz_cust_accounts cust_acct,

3237: -- get site/contact information pertaining to PRIMARY drawee site
3238:
3239: SELECT site_uses.site_use_id, site_uses.contact_id, acct_site.cust_acct_site_id
3240: INTO l_drawee_site_use_id, l_drawee_contact_id, l_site_id
3241: FROM hz_cust_accounts cust_acct,
3242: hz_cust_acct_sites acct_site,
3243: hz_cust_site_uses site_uses,
3244: hz_cust_account_roles acct_role
3245: WHERE cust_acct.cust_account_id = l_drawee_id

Line 3259: FROM hz_cust_accounts cust_acct,

3255: -- the bank accounts are linked to
3256:
3257: SELECT site_uses.site_use_id
3258: INTO l_bill_to_site_id
3259: FROM hz_cust_accounts cust_acct,
3260: hz_cust_acct_sites acct_site,
3261: hz_cust_site_uses site_uses
3262: WHERE cust_acct.cust_account_id = l_drawee_id
3263: AND cust_acct.cust_account_id = acct_site.cust_account_id

Line 3319: FROM hz_cust_accounts cust_acct,

3315: SELECT site_uses.site_use_id,
3316: site_uses.contact_id,
3317: p_customer_bank_account_id
3318: INTO l_drawee_site_use_id, l_drawee_contact_id, l_drawee_bank_account_id
3319: FROM hz_cust_accounts cust_acct,
3320: hz_cust_acct_sites acct_site,
3321: hz_cust_site_uses site_uses,
3322: hz_cust_account_roles acct_role,
3323: hz_party_sites party_site

Line 3333: FROM hz_cust_accounts bcust_acct,

3329: -- following conditions ensure that this DRAWEE site is also a BILL TO site
3330: AND acct_site.party_site_id = party_site.party_site_id
3331: AND party_site.location_id =
3332: (select bloc.location_id
3333: FROM hz_cust_accounts bcust_acct,
3334: hz_cust_acct_sites bacct_site,
3335: hz_cust_site_uses bsite_uses,
3336: hz_party_sites bparty_site,
3337: hz_locations bloc