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.OE_CREDIT_CHECK_RPT dependencies on HZ_CUST_PROFILE_CLASSES

Line 181: cust_prof_class_from HZ_CUST_PROFILE_CLASSES.name%TYPE;

177: v_order_date_clause VARCHAR2(1000);
178:
179: --Variables for input of dynamic sql
180: profile_org_id NUMBER;
181: cust_prof_class_from HZ_CUST_PROFILE_CLASSES.name%TYPE;
182: cust_prof_class_to HZ_CUST_PROFILE_CLASSES.name%TYPE;
183: party_name_from HZ_PARTIES.party_name%TYPE;
184: party_name_to HZ_PARTIES.party_name%TYPE;
185: cust_acct_number_from HZ_CUST_ACCOUNTS_ALL.account_number%TYPE;

Line 182: cust_prof_class_to HZ_CUST_PROFILE_CLASSES.name%TYPE;

178:
179: --Variables for input of dynamic sql
180: profile_org_id NUMBER;
181: cust_prof_class_from HZ_CUST_PROFILE_CLASSES.name%TYPE;
182: cust_prof_class_to HZ_CUST_PROFILE_CLASSES.name%TYPE;
183: party_name_from HZ_PARTIES.party_name%TYPE;
184: party_name_to HZ_PARTIES.party_name%TYPE;
185: cust_acct_number_from HZ_CUST_ACCOUNTS_ALL.account_number%TYPE;
186: cust_acct_number_to HZ_CUST_ACCOUNTS_ALL.account_number%TYPE;

Line 260: HZ_CUST_PROFILE_CLASSES HCPC

256: --14699527 appended HCP.STATUS=''A'' condition
257: v_cust_prof_class_clause := 'AND EXISTS
258: (SELECT HCP.cust_account_id
259: FROM HZ_CUSTOMER_PROFILES HCP,
260: HZ_CUST_PROFILE_CLASSES HCPC
261: WHERE HCP.profile_class_id = HCPC.profile_class_id
262: AND HCP.cust_account_id = OH.sold_to_org_id
263: AND HCP.STATUS=''A''
264: AND HCPC.name = :cust_prof_class_from) ';

Line 270: HZ_CUST_PROFILE_CLASSES HCPC

266: --14699527 appended HCP.STATUS=''A'' condition
267: v_cust_prof_class_clause := 'AND EXISTS
268: (SELECT HCP.cust_account_id
269: FROM HZ_CUSTOMER_PROFILES HCP,
270: HZ_CUST_PROFILE_CLASSES HCPC
271: WHERE HCP.profile_class_id = HCPC.profile_class_id
272: AND HCP.cust_account_id = OH.sold_to_org_id
273: AND HCP.STATUS=''A''
274: AND HCPC.name >= :cust_prof_class_from) ';

Line 280: HZ_CUST_PROFILE_CLASSES HCPC

276: --14699527 appended HCP.STATUS=''A'' condition
277: v_cust_prof_class_clause := 'AND EXISTS
278: (SELECT HCP.cust_account_id
279: FROM HZ_CUSTOMER_PROFILES HCP,
280: HZ_CUST_PROFILE_CLASSES HCPC
281: WHERE HCP.profile_class_id = HCPC.profile_class_id
282: AND HCP.cust_account_id = OH.sold_to_org_id
283: AND HCP.STATUS=''A''
284: AND HCPC.name <= :cust_prof_class_to) ';

Line 290: HZ_CUST_PROFILE_CLASSES HCPC

286: --14699527 appended HCP.STATUS=''A'' condition
287: v_cust_prof_class_clause := 'AND EXISTS
288: (SELECT HCP.cust_account_id
289: FROM HZ_CUSTOMER_PROFILES HCP,
290: HZ_CUST_PROFILE_CLASSES HCPC
291: WHERE HCP.profile_class_id = HCPC.profile_class_id
292: AND HCP.cust_account_id = OH.sold_to_org_id
293: AND HCP.STATUS=''A''
294: AND HCPC.name BETWEEN :cust_prof_class_from AND

Line 1835: --Performance issue (SQL ID-16485806 FTS on HZ_CUST_ACCOUNTS and HZ_CUST_PROFILE_CLASSES)

1831: AND p.party_id= p_party_id;
1832:
1833: ---cursor to select all eligible customers
1834: /*
1835: --Performance issue (SQL ID-16485806 FTS on HZ_CUST_ACCOUNTS and HZ_CUST_PROFILE_CLASSES)
1836: CURSOR cust_csr
1837: IS
1838: SELECT
1839: SUBSTRB(party.party_name,1,50) ||'('||c.account_number||')' Customer

Line 1852: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp

1848: AND NVL(p_customer_name_high, party.party_name)
1849: AND c.account_number BETWEEN NVL(p_cust_number_low, c.account_number )
1850: AND NVL(p_cust_number_high, c.account_number )
1851: AND c.cust_account_id IN (SELECT cp.cust_account_id
1852: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp
1853: WHERE cp.profile_class_id=cpc.profile_class_id
1854: AND cpc.name BETWEEN NVL(p_prof_class_low, cpc.name)
1855: AND NVL(p_prof_class_high, cpc.name));
1856: */

Line 3576: --Performance issue: start (SQL ID-16485806 FTS on HZ_CUST_ACCOUNTS and HZ_CUST_PROFILE_CLASSES)

3572: THEN
3573:
3574: OE_DEBUG_PUB.ADD('IN Cust Summary Report');
3575:
3576: --Performance issue: start (SQL ID-16485806 FTS on HZ_CUST_ACCOUNTS and HZ_CUST_PROFILE_CLASSES)
3577: IF (p_customer_name_low IS NOT NULL) AND (p_cust_number_low IS NOT NULL) THEN
3578: OE_DEBUG_PUB.ADD('Customer name-LOW :' || p_customer_name_low);
3579: OE_DEBUG_PUB.ADD('Customer number-LOW :' || p_cust_number_low);
3580:

Line 3596: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp

3592: AND NVL(p_customer_name_high, party.party_name)
3593: AND c.account_number BETWEEN p_cust_number_low
3594: AND NVL(p_cust_number_high, c.account_number )
3595: AND c.cust_account_id IN (SELECT cp.cust_account_id
3596: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp
3597: WHERE cp.profile_class_id=cpc.profile_class_id
3598: AND cp.STATUS='A' --14699527
3599: AND cpc.name BETWEEN NVL(p_prof_class_low, cpc.name)
3600: AND NVL(p_prof_class_high, cpc.name)) ;

Line 3619: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp

3615: AND party.party_name <= p_customer_name_high
3616: AND c.account_number BETWEEN p_cust_number_low
3617: AND NVL(p_cust_number_high, c.account_number )
3618: AND c.cust_account_id IN (SELECT cp.cust_account_id
3619: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp
3620: WHERE cp.profile_class_id=cpc.profile_class_id
3621: AND cp.STATUS='A' --14699527
3622: AND cpc.name BETWEEN NVL(p_prof_class_low, cpc.name)
3623: AND NVL(p_prof_class_high, cpc.name)) ;

Line 3642: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp

3638: AND party.party_name BETWEEN p_customer_name_low
3639: AND NVL(p_customer_name_high, party.party_name)
3640: AND c.account_number <=p_cust_number_high
3641: AND c.cust_account_id IN (SELECT cp.cust_account_id
3642: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp
3643: WHERE cp.profile_class_id=cpc.profile_class_id
3644: AND cp.STATUS='A' --14699527
3645: AND cpc.name BETWEEN NVL(p_prof_class_low, cpc.name)
3646: AND NVL(p_prof_class_high, cpc.name)) ;

Line 3664: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp

3660: AND c.party_id = party.party_id
3661: AND party.party_name <= p_customer_name_high
3662: AND c.account_number <= p_cust_number_high
3663: AND c.cust_account_id IN (SELECT cp.cust_account_id
3664: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp
3665: WHERE cp.profile_class_id=cpc.profile_class_id
3666: AND cp.STATUS='A' --14699527
3667: AND cpc.name BETWEEN NVL(p_prof_class_low, cpc.name)
3668: AND NVL(p_prof_class_high, cpc.name)) ;

Line 3685: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp

3681: AND c.party_id = party.party_id
3682: AND party.party_name BETWEEN p_customer_name_low
3683: AND NVL(p_customer_name_high, party.party_name)
3684: AND c.cust_account_id IN (SELECT cp.cust_account_id
3685: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp
3686: WHERE cp.profile_class_id=cpc.profile_class_id
3687: AND cp.STATUS='A' --14699527
3688: AND cpc.name BETWEEN NVL(p_prof_class_low, cpc.name)
3689: AND NVL(p_prof_class_high, cpc.name)) ;

Line 3705: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp

3701: WHERE c.status='A'
3702: AND c.party_id = party.party_id
3703: AND party.party_name <= p_customer_name_high
3704: AND c.cust_account_id IN (SELECT cp.cust_account_id
3705: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp
3706: WHERE cp.profile_class_id=cpc.profile_class_id
3707: AND cp.STATUS='A' --14699527
3708: AND cpc.name BETWEEN NVL(p_prof_class_low, cpc.name)
3709: AND NVL(p_prof_class_high, cpc.name)) ;

Line 3726: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp

3722: AND c.party_id = party.party_id
3723: AND c.account_number BETWEEN p_cust_number_low
3724: AND NVL(p_cust_number_high, c.account_number )
3725: AND c.cust_account_id IN (SELECT cp.cust_account_id
3726: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp
3727: WHERE cp.profile_class_id=cpc.profile_class_id
3728: AND cp.STATUS='A' --14699527
3729: AND cpc.name BETWEEN NVL(p_prof_class_low, cpc.name)
3730: AND NVL(p_prof_class_high, cpc.name)) ;

Line 3746: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp

3742: WHERE c.status='A'
3743: AND c.party_id = party.party_id
3744: AND c.account_number <= p_cust_number_high
3745: AND c.cust_account_id IN (SELECT cp.cust_account_id
3746: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp
3747: WHERE cp.profile_class_id=cpc.profile_class_id
3748: AND cp.STATUS='A' --14699527
3749: AND cpc.name BETWEEN NVL(p_prof_class_low, cpc.name)
3750: AND NVL(p_prof_class_high, cpc.name)) ;

Line 3769: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp

3765: , hz_parties party
3766: WHERE c.status='A'
3767: AND c.party_id = party.party_id
3768: AND c.cust_account_id IN (SELECT cp.cust_account_id
3769: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp
3770: WHERE cp.profile_class_id=cpc.profile_class_id
3771: AND cp.STATUS='A' --14699527
3772: AND cpc.name BETWEEN NVL(p_prof_class_low, cpc.name)
3773: AND NVL(p_prof_class_high, cpc.name)) ;

Line 3775: --Performance issue: end (SQL ID-16485806 FTS on HZ_CUST_ACCOUNTS and HZ_CUST_PROFILE_CLASSES)

3771: AND cp.STATUS='A' --14699527
3772: AND cpc.name BETWEEN NVL(p_prof_class_low, cpc.name)
3773: AND NVL(p_prof_class_high, cpc.name)) ;
3774: END IF ;
3775: --Performance issue: end (SQL ID-16485806 FTS on HZ_CUST_ACCOUNTS and HZ_CUST_PROFILE_CLASSES)
3776:
3777: ------start loop for customers
3778: LOOP
3779: FETCH cust_cur INTO cust_csr_rec;