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_PARTIES

Line 54: HZ_PARTIES HP

50: HCA.ACCOUNT_NUMBER
51: INTO l_party_name,
52: l_account_number
53: FROM HZ_CUST_ACCOUNTS HCA,
54: HZ_PARTIES HP
55: WHERE HCA.PARTY_ID = HP.PARTY_ID
56: AND HCA.CUST_ACCOUNT_ID = l_header_rec.sold_to_org_id;
57: OE_DEBUG_PUB.ADD('Customer Name/Number = '||l_party_name||'/'||l_account_number);
58: EXCEPTION

Line 183: party_name_from HZ_PARTIES.party_name%TYPE;

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;
187: order_date_from DATE;

Line 184: party_name_to HZ_PARTIES.party_name%TYPE;

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;
187: order_date_from DATE;
188: order_date_to DATE;

Line 300: HZ_PARTIES HP

296: v_party_name_clause :=
297: 'AND EXISTS (
298: SELECT HCA.cust_account_id
299: FROM HZ_CUST_ACCOUNTS HCA,
300: HZ_PARTIES HP
301: WHERE HCA.party_id = HP.party_id
302: AND HCA.cust_account_id = OH.sold_to_org_id
303: AND HP.party_name = :party_name_from
304: ) ';

Line 310: HZ_PARTIES HP

306: v_party_name_clause :=
307: 'AND EXISTS (
308: SELECT HCA.cust_account_id
309: FROM HZ_CUST_ACCOUNTS HCA,
310: HZ_PARTIES HP
311: WHERE HCA.party_id = HP.party_id
312: AND HCA.cust_account_id = OH.sold_to_org_id
313: AND HP.party_name >= :party_name_from
314: ) ';

Line 320: HZ_PARTIES HP

316: v_party_name_clause :=
317: 'AND EXISTS (
318: SELECT HCA.cust_account_id
319: FROM HZ_CUST_ACCOUNTS HCA,
320: HZ_PARTIES HP
321: WHERE HCA.party_id = HP.party_id
322: AND HCA.cust_account_id = OH.sold_to_org_id
323: AND HP.party_name <= :party_name_to
324: ) ';

Line 330: HZ_PARTIES HP

326: v_party_name_clause :=
327: 'AND EXISTS (
328: SELECT HCA.cust_account_id
329: FROM HZ_CUST_ACCOUNTS HCA,
330: HZ_PARTIES HP
331: WHERE HCA.party_id = HP.party_id
332: AND HCA.cust_account_id = OH.sold_to_org_id
333: AND HP.party_name BETWEEN :party_name_from AND :party_name_to
334: ) ';

Line 1660: hz_parties p

1656: p.party_name||'('||p.party_number||')' Party
1657: , p.party_id
1658: , p.party_number
1659: FROM
1660: hz_parties p
1661: WHERE party_type IN ('ORGANIZATION','PERSON')
1662: AND party_name BETWEEN p_party_name_low
1663: AND NVL(p_party_name_high, party_name)
1664: AND party_number BETWEEN NVL(p_party_number_low, party_number )

Line 1673: hz_parties p

1669: p.party_name||'('||p.party_number||')' Party
1670: , p.party_id
1671: , p.party_number
1672: FROM
1673: hz_parties p
1674: WHERE party_type IN ('ORGANIZATION','PERSON')
1675: AND party_name <= p_party_name_high
1676: AND party_number BETWEEN NVL(p_party_number_low, party_number )
1677: AND NVL(p_party_number_high, party_number )

Line 1685: hz_parties p

1681: p.party_name||'('||p.party_number||')' Party
1682: , p.party_id
1683: , p.party_number
1684: FROM
1685: hz_parties p
1686: WHERE party_type IN ('ORGANIZATION','PERSON')
1687: AND party_number BETWEEN p_party_number_low
1688: AND NVL(p_party_number_high, party_number )
1689: AND l_input = 3

Line 1696: hz_parties p

1692: p.party_name||'('||p.party_number||')' Party
1693: , p.party_id
1694: , p.party_number
1695: FROM
1696: hz_parties p
1697: WHERE party_type IN ('ORGANIZATION','PERSON')
1698: AND party_number <= p_party_number_high
1699: AND l_input = 4
1700: ; */

Line 1711: hz_parties p

1707: p.party_name||'('||p.party_number||')' Party
1708: , p.party_id
1709: , p.party_number
1710: FROM
1711: hz_parties p
1712: WHERE party_type IN ('ORGANIZATION','PERSON')
1713: AND party_name BETWEEN p_party_name_low
1714: AND NVL(p_party_name_high, party_name)
1715: AND party_number BETWEEN NVL(p_party_number_low, party_number )

Line 1725: hz_parties p

1721: p.party_name||'('||p.party_number||')' Party
1722: , p.party_id
1723: , p.party_number
1724: FROM
1725: hz_parties p
1726: WHERE party_type IN ('ORGANIZATION','PERSON')
1727: AND party_name <= p_party_name_high
1728: AND party_number BETWEEN NVL(p_party_number_low, party_number )
1729: AND NVL(p_party_number_high, party_number )

Line 1738: hz_parties p

1734: p.party_name||'('||p.party_number||')' Party
1735: , p.party_id
1736: , p.party_number
1737: FROM
1738: hz_parties p
1739: WHERE party_type IN ('ORGANIZATION','PERSON')
1740: AND party_number BETWEEN p_party_number_low
1741: AND NVL(p_party_number_high, party_number )
1742: AND l_input = 3;

Line 1750: hz_parties p

1746: p.party_name||'('||p.party_number||')' Party
1747: , p.party_id
1748: , p.party_number
1749: FROM
1750: hz_parties p
1751: WHERE party_type IN ('ORGANIZATION','PERSON')
1752: AND party_number <= p_party_number_high
1753: AND l_input = 4;
1754:

Line 1770: hz_parties p, hz_hierarchy_nodes n

1766: , n.child_id party_id
1767: , p.party_number party_number
1768: , NVL(n.level_number,0) level_number
1769: FROM
1770: hz_parties p, hz_hierarchy_nodes n
1771: WHERE p.party_id=n.child_id
1772: AND n.parent_object_type = 'ORGANIZATION'
1773: AND n.parent_table_name = 'HZ_PARTIES'
1774: AND n.child_object_type = 'ORGANIZATION'

Line 1773: AND n.parent_table_name = 'HZ_PARTIES'

1769: FROM
1770: hz_parties p, hz_hierarchy_nodes n
1771: WHERE p.party_id=n.child_id
1772: AND n.parent_object_type = 'ORGANIZATION'
1773: AND n.parent_table_name = 'HZ_PARTIES'
1774: AND n.child_object_type = 'ORGANIZATION'
1775: AND n.effective_start_date <= SYSDATE
1776: AND n.effective_end_date >= SYSDATE
1777: AND n.hierarchy_type

Line 1791: hz_parties p

1787: p.party_name||'('||p.party_number||')' Party
1788: , p.party_id
1789: , p.party_number party_number
1790: FROM
1791: hz_parties p
1792: WHERE p.party_id=NVL(p_specific_party_id,p_spec_party_num_id);
1793:
1794:
1795: ----cursor to select all credit profiles for the given party

Line 1819: , hz_parties p

1815: , c.cust_account_id customer_id
1816: , c.account_number customer_number
1817: FROM
1818: hz_cust_accounts c
1819: , hz_parties p
1820: WHERE c.status='A'
1821: AND c.party_id = p.party_id
1822: AND p.party_id= p_party_id;
1823:

Line 1835: , hz_parties party

1831: , c.cust_account_id customer_id
1832: , c.account_number customer_number
1833: FROM
1834: hz_cust_accounts c
1835: , hz_parties party
1836: WHERE c.status='A'
1837: AND c.party_id = party.party_id
1838: AND party.party_name BETWEEN NVL(p_customer_name_low, party.party_name )
1839: AND NVL(p_customer_name_high, party.party_name)

Line 3572: , hz_parties party

3568: , c.cust_account_id customer_id
3569: , c.account_number customer_number
3570: FROM
3571: hz_cust_accounts c
3572: , hz_parties party
3573: WHERE c.status='A'
3574: AND c.party_id = party.party_id
3575: AND party.party_name BETWEEN p_customer_name_low
3576: AND NVL(p_customer_name_high, party.party_name)

Line 3595: , hz_parties party

3591: , c.cust_account_id customer_id
3592: , c.account_number customer_number
3593: FROM
3594: hz_cust_accounts c
3595: , hz_parties party
3596: WHERE c.status='A'
3597: AND c.party_id = party.party_id
3598: AND party.party_name <= p_customer_name_high
3599: AND c.account_number BETWEEN p_cust_number_low

Line 3617: , hz_parties party

3613: , c.cust_account_id customer_id
3614: , c.account_number customer_number
3615: FROM
3616: hz_cust_accounts c
3617: , hz_parties party
3618: WHERE c.status='A'
3619: AND c.party_id = party.party_id
3620: AND party.party_name BETWEEN p_customer_name_low
3621: AND NVL(p_customer_name_high, party.party_name)

Line 3639: , hz_parties party

3635: , c.cust_account_id customer_id
3636: , c.account_number customer_number
3637: FROM
3638: hz_cust_accounts c
3639: , hz_parties party
3640: WHERE c.status='A'
3641: AND c.party_id = party.party_id
3642: AND party.party_name <= p_customer_name_high
3643: AND c.account_number <= p_cust_number_high

Line 3659: , hz_parties party

3655: , c.cust_account_id customer_id
3656: , c.account_number customer_number
3657: FROM
3658: hz_cust_accounts c
3659: , hz_parties party
3660: WHERE c.status='A'
3661: AND c.party_id = party.party_id
3662: AND party.party_name BETWEEN p_customer_name_low
3663: AND NVL(p_customer_name_high, party.party_name)

Line 3679: , hz_parties party

3675: , c.cust_account_id customer_id
3676: , c.account_number customer_number
3677: FROM
3678: hz_cust_accounts c
3679: , hz_parties party
3680: WHERE c.status='A'
3681: AND c.party_id = party.party_id
3682: AND party.party_name <= p_customer_name_high
3683: AND c.cust_account_id IN (SELECT cp.cust_account_id

Line 3698: , hz_parties party

3694: , c.cust_account_id customer_id
3695: , c.account_number customer_number
3696: FROM
3697: hz_cust_accounts c
3698: , hz_parties party
3699: WHERE c.status='A'
3700: AND c.party_id = party.party_id
3701: AND c.account_number BETWEEN p_cust_number_low
3702: AND NVL(p_cust_number_high, c.account_number )

Line 3718: , hz_parties party

3714: , c.cust_account_id customer_id
3715: , c.account_number customer_number
3716: FROM
3717: hz_cust_accounts c
3718: , hz_parties party
3719: WHERE c.status='A'
3720: AND c.party_id = party.party_id
3721: AND c.account_number <= p_cust_number_high
3722: AND c.cust_account_id IN (SELECT cp.cust_account_id

Line 3741: , hz_parties party

3737: , c.cust_account_id customer_id
3738: , c.account_number customer_number
3739: FROM
3740: hz_cust_accounts c
3741: , hz_parties party
3742: WHERE c.status='A'
3743: AND c.party_id = party.party_id
3744: AND c.cust_account_id IN (SELECT cp.cust_account_id
3745: FROM hz_cust_profile_classes cpc,hz_customer_profiles cp