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_SITE_USES

Line 21: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%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(
25: p_print_flag IN varchar2,

Line 62: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%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:
66:

Line 107: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%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:
111:

Line 133: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%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(
137: p_lead_days IN AR_RECEIPT_METHODS.lead_days%TYPE,

Line 149: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%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
153: PROCEDURE construct_hz(

Line 172: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%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,
176: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,

Line 194: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%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,
198: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,

Line 404: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE DEFAULT NULL) IS

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
407: l_batch_date DATE := NULL;
408: l_gl_date DATE := NULL;

Line 626: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE) IS

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;
629:
630: BEGIN

Line 744: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE) IS

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;
747: l_selection_criteria_id RA_BATCHES.selection_criteria_id%TYPE;
748:

Line 909: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%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
912: RA_BATCHES.selection_criteria_id%TYPE) IS
913: l_issue_date RA_BATCHES.issue_date%TYPE;

Line 1181: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE) IS

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: /*
1184: Bug 1808967 : added trx.customer_bank_account_id in select statement,
1185: by doing this I have made the bank account id an implicit grouping rule

Line 1940: hz_cust_site_uses site,

1936: l_trx_select_statement := l_trx_select_statement ||
1937: ' AND exists
1938: (SELECT a.cust_account_id
1939: FROM hz_cust_acct_sites a,
1940: hz_cust_site_uses site,
1941: hz_cust_account_roles acct_role
1942: WHERE a.cust_acct_site_id = site.cust_acct_site_id ';
1943:
1944: if p_customer_id is NOT NULL then

Line 1960: from hz_cust_site_uses

1956: ' AND site.primary_flag = ''Y'' ';
1957: ELSE
1958: l_trx_select_statement := l_trx_select_statement ||
1959: ' AND site.cust_acct_site_id IN (select cust_acct_site_id
1960: from hz_cust_site_uses
1961: WHERE site_use_id = ps.customer_site_use_id) ';
1962: END IF;
1963:
1964: l_trx_select_statement := l_trx_select_statement ||

Line 2030: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%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
2033:
2034: l_trx_select_statement VARCHAR2(4000) := NULL;

Line 2260: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%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,
2263: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,
2264: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,

Line 2508: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%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,
2511: p_invoice_currency_code IN RA_CUSTOMER_TRX.invoice_currency_code%TYPE,
2512: p_exchange_rate IN RA_CUSTOMER_TRX.exchange_rate%TYPE,

Line 3306: hz_cust_site_uses site_uses,

3302: Null external_bank_account_id
3303: INTO l_drawee_site_use_id, l_drawee_contact_id, l_drawee_bank_account_id
3304: FROM hz_cust_accounts cust_acct,
3305: hz_cust_acct_sites acct_site,
3306: hz_cust_site_uses site_uses,
3307: hz_cust_account_roles acct_role
3308: WHERE cust_acct.cust_account_id = l_drawee_id
3309: AND cust_acct.cust_account_id = acct_site.cust_account_id
3310: AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id

Line 3326: hz_cust_site_uses site_uses,

3322: Null external_bank_account_id
3323: INTO l_drawee_site_use_id, l_drawee_contact_id, l_drawee_bank_account_id
3324: FROM hz_cust_accounts cust_acct,
3325: hz_cust_acct_sites acct_site,
3326: hz_cust_site_uses site_uses,
3327: hz_cust_account_roles acct_role,
3328: hz_party_sites party_site
3329: WHERE cust_acct.cust_account_id = l_drawee_id
3330: AND cust_acct.cust_account_id = acct_site.cust_account_id

Line 3339: hz_cust_site_uses bsite_uses,

3335: AND party_site.location_id =
3336: (select bloc.location_id
3337: FROM hz_cust_accounts bcust_acct,
3338: hz_cust_acct_sites bacct_site,
3339: hz_cust_site_uses bsite_uses,
3340: hz_party_sites bparty_site,
3341: hz_locations bloc
3342: WHERE bcust_acct.cust_account_id = l_drawee_id
3343: AND bcust_acct.cust_account_id = bacct_site.cust_account_id

Line 3387: hz_cust_site_uses site_uses,

3383: SELECT site_uses.site_use_id, site_uses.contact_id, acct_site.cust_acct_site_id
3384: INTO l_drawee_site_use_id, l_drawee_contact_id, l_site_id
3385: FROM hz_cust_accounts cust_acct,
3386: hz_cust_acct_sites acct_site,
3387: hz_cust_site_uses site_uses,
3388: hz_cust_account_roles acct_role
3389: WHERE cust_acct.cust_account_id = l_drawee_id
3390: AND cust_acct.cust_account_id = acct_site.cust_account_id
3391: AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id

Line 3405: hz_cust_site_uses site_uses

3401: SELECT site_uses.site_use_id
3402: INTO l_bill_to_site_id
3403: FROM hz_cust_accounts cust_acct,
3404: hz_cust_acct_sites acct_site,
3405: hz_cust_site_uses site_uses
3406: WHERE cust_acct.cust_account_id = l_drawee_id
3407: AND cust_acct.cust_account_id = acct_site.cust_account_id
3408: AND acct_site.cust_acct_site_id = l_site_id
3409: AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id

Line 3465: hz_cust_site_uses site_uses,

3461: p_customer_bank_account_id
3462: INTO l_drawee_site_use_id, l_drawee_contact_id, l_drawee_bank_account_id
3463: FROM hz_cust_accounts cust_acct,
3464: hz_cust_acct_sites acct_site,
3465: hz_cust_site_uses site_uses,
3466: hz_cust_account_roles acct_role,
3467: hz_party_sites party_site
3468: WHERE cust_acct.cust_account_id = l_drawee_id
3469: AND cust_acct.cust_account_id = acct_site.cust_account_id

Line 3479: hz_cust_site_uses bsite_uses,

3475: AND party_site.location_id =
3476: (select bloc.location_id
3477: FROM hz_cust_accounts bcust_acct,
3478: hz_cust_acct_sites bacct_site,
3479: hz_cust_site_uses bsite_uses,
3480: hz_party_sites bparty_site,
3481: hz_locations bloc
3482: WHERE bcust_acct.cust_account_id = l_drawee_id
3483: AND bcust_acct.cust_account_id = bacct_site.cust_account_id