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 392: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%TYPE DEFAULT NULL) IS

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;
396: l_gl_date DATE := NULL;

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

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:
610: BEGIN

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

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;
728:

Line 889: p_site_use_id IN HZ_CUST_SITE_USES.site_use_id%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
893: l_issue_date RA_BATCHES.issue_date%TYPE;

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

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,
1166: by doing this I have made the bank account id an implicit grouping rule

Line 1791: hz_cust_site_uses site,

1787: l_trx_select_statement := l_trx_select_statement ||
1788: ' AND exists
1789: (SELECT a.cust_account_id
1790: FROM hz_cust_acct_sites a,
1791: hz_cust_site_uses site,
1792: hz_cust_account_roles acct_role
1793: WHERE a.cust_acct_site_id = site.cust_acct_site_id ';
1794:
1795: if p_customer_id is NOT NULL then

Line 1811: from hz_cust_site_uses

1807: ' AND site.primary_flag = ''Y'' ';
1808: ELSE
1809: l_trx_select_statement := l_trx_select_statement ||
1810: ' AND site.cust_acct_site_id IN (select cust_acct_site_id
1811: from hz_cust_site_uses
1812: WHERE site_use_id = ps.customer_site_use_id) ';
1813: END IF;
1814:
1815: l_trx_select_statement := l_trx_select_statement ||

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

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

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

Line 3162: hz_cust_site_uses site_uses,

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
3165: AND cust_acct.cust_account_id = acct_site.cust_account_id
3166: AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id

Line 3182: hz_cust_site_uses site_uses,

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
3185: WHERE cust_acct.cust_account_id = l_drawee_id
3186: AND cust_acct.cust_account_id = acct_site.cust_account_id

Line 3195: hz_cust_site_uses bsite_uses,

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
3198: WHERE bcust_acct.cust_account_id = l_drawee_id
3199: AND bcust_acct.cust_account_id = bacct_site.cust_account_id

Line 3243: hz_cust_site_uses site_uses,

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
3246: AND cust_acct.cust_account_id = acct_site.cust_account_id
3247: AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id

Line 3261: hz_cust_site_uses site_uses

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
3264: AND acct_site.cust_acct_site_id = l_site_id
3265: AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id

Line 3321: hz_cust_site_uses site_uses,

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
3324: WHERE cust_acct.cust_account_id = l_drawee_id
3325: AND cust_acct.cust_account_id = acct_site.cust_account_id

Line 3335: hz_cust_site_uses bsite_uses,

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
3338: WHERE bcust_acct.cust_account_id = l_drawee_id
3339: AND bcust_acct.cust_account_id = bacct_site.cust_account_id