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 308: HZ_PARTIES HP

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

Line 318: HZ_PARTIES HP

314: v_party_name_clause :=
315: 'AND EXISTS (
316: SELECT HCA.cust_account_id
317: FROM HZ_CUST_ACCOUNTS HCA,
318: HZ_PARTIES HP
319: WHERE HCA.party_id = HP.party_id
320: AND HCA.cust_account_id = OH.sold_to_org_id
321: AND HP.party_name >= :party_name_from
322: ) ';

Line 328: HZ_PARTIES HP

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

Line 338: HZ_PARTIES HP

334: v_party_name_clause :=
335: 'AND EXISTS (
336: SELECT HCA.cust_account_id
337: FROM HZ_CUST_ACCOUNTS HCA,
338: HZ_PARTIES HP
339: WHERE HCA.party_id = HP.party_id
340: AND HCA.cust_account_id = OH.sold_to_org_id
341: AND HP.party_name BETWEEN :party_name_from AND :party_name_to
342: ) ';

Line 1668: hz_parties p

1664: p.party_name||'('||p.party_number||')' Party
1665: , p.party_id
1666: , p.party_number
1667: FROM
1668: hz_parties p
1669: WHERE party_type IN ('ORGANIZATION','PERSON')
1670: AND party_name BETWEEN p_party_name_low
1671: AND NVL(p_party_name_high, party_name)
1672: AND party_number BETWEEN NVL(p_party_number_low, party_number )

Line 1681: hz_parties p

1677: p.party_name||'('||p.party_number||')' Party
1678: , p.party_id
1679: , p.party_number
1680: FROM
1681: hz_parties p
1682: WHERE party_type IN ('ORGANIZATION','PERSON')
1683: AND party_name <= p_party_name_high
1684: AND party_number BETWEEN NVL(p_party_number_low, party_number )
1685: AND NVL(p_party_number_high, party_number )

Line 1693: hz_parties p

1689: p.party_name||'('||p.party_number||')' Party
1690: , p.party_id
1691: , p.party_number
1692: FROM
1693: hz_parties p
1694: WHERE party_type IN ('ORGANIZATION','PERSON')
1695: AND party_number BETWEEN p_party_number_low
1696: AND NVL(p_party_number_high, party_number )
1697: AND l_input = 3

Line 1704: hz_parties p

1700: p.party_name||'('||p.party_number||')' Party
1701: , p.party_id
1702: , p.party_number
1703: FROM
1704: hz_parties p
1705: WHERE party_type IN ('ORGANIZATION','PERSON')
1706: AND party_number <= p_party_number_high
1707: AND l_input = 4
1708: ; */

Line 1719: hz_parties p

1715: p.party_name||'('||p.party_number||')' Party
1716: , p.party_id
1717: , p.party_number
1718: FROM
1719: hz_parties p
1720: WHERE party_type IN ('ORGANIZATION','PERSON')
1721: AND party_name BETWEEN p_party_name_low
1722: AND NVL(p_party_name_high, party_name)
1723: AND party_number BETWEEN NVL(p_party_number_low, party_number )

Line 1733: hz_parties p

1729: p.party_name||'('||p.party_number||')' Party
1730: , p.party_id
1731: , p.party_number
1732: FROM
1733: hz_parties p
1734: WHERE party_type IN ('ORGANIZATION','PERSON')
1735: AND party_name <= p_party_name_high
1736: AND party_number BETWEEN NVL(p_party_number_low, party_number )
1737: AND NVL(p_party_number_high, party_number )

Line 1746: hz_parties p

1742: p.party_name||'('||p.party_number||')' Party
1743: , p.party_id
1744: , p.party_number
1745: FROM
1746: hz_parties p
1747: WHERE party_type IN ('ORGANIZATION','PERSON')
1748: AND party_number BETWEEN p_party_number_low
1749: AND NVL(p_party_number_high, party_number )
1750: AND l_input = 3;

Line 1758: hz_parties p

1754: p.party_name||'('||p.party_number||')' Party
1755: , p.party_id
1756: , p.party_number
1757: FROM
1758: hz_parties p
1759: WHERE party_type IN ('ORGANIZATION','PERSON')
1760: AND party_number <= p_party_number_high
1761: AND l_input = 4;
1762:

Line 1778: hz_parties p, hz_hierarchy_nodes n

1774: , n.child_id party_id
1775: , p.party_number party_number
1776: , NVL(n.level_number,0) level_number
1777: FROM
1778: hz_parties p, hz_hierarchy_nodes n
1779: WHERE p.party_id=n.child_id
1780: AND n.parent_object_type = 'ORGANIZATION'
1781: AND n.parent_table_name = 'HZ_PARTIES'
1782: AND n.child_object_type = 'ORGANIZATION'

Line 1781: AND n.parent_table_name = 'HZ_PARTIES'

1777: FROM
1778: hz_parties p, hz_hierarchy_nodes n
1779: WHERE p.party_id=n.child_id
1780: AND n.parent_object_type = 'ORGANIZATION'
1781: AND n.parent_table_name = 'HZ_PARTIES'
1782: AND n.child_object_type = 'ORGANIZATION'
1783: AND n.effective_start_date <= SYSDATE
1784: AND n.effective_end_date >= SYSDATE
1785: AND n.hierarchy_type

Line 1799: hz_parties p

1795: p.party_name||'('||p.party_number||')' Party
1796: , p.party_id
1797: , p.party_number party_number
1798: FROM
1799: hz_parties p
1800: WHERE p.party_id=NVL(p_specific_party_id,p_spec_party_num_id);
1801:
1802:
1803: ----cursor to select all credit profiles for the given party

Line 1828: , hz_parties p

1824: , c.cust_account_id customer_id
1825: , c.account_number customer_number
1826: FROM
1827: hz_cust_accounts c
1828: , hz_parties p
1829: WHERE c.status='A'
1830: AND c.party_id = p.party_id
1831: AND p.party_id= p_party_id;
1832:

Line 1844: , hz_parties party

1840: , c.cust_account_id customer_id
1841: , c.account_number customer_number
1842: FROM
1843: hz_cust_accounts c
1844: , hz_parties party
1845: WHERE c.status='A'
1846: AND c.party_id = party.party_id
1847: AND party.party_name BETWEEN NVL(p_customer_name_low, party.party_name )
1848: AND NVL(p_customer_name_high, party.party_name)

Line 3588: , hz_parties party

3584: , c.cust_account_id customer_id
3585: , c.account_number customer_number
3586: FROM
3587: hz_cust_accounts c
3588: , hz_parties party
3589: WHERE c.status='A'
3590: AND c.party_id = party.party_id
3591: AND party.party_name BETWEEN p_customer_name_low
3592: AND NVL(p_customer_name_high, party.party_name)

Line 3612: , hz_parties party

3608: , c.cust_account_id customer_id
3609: , c.account_number customer_number
3610: FROM
3611: hz_cust_accounts c
3612: , hz_parties party
3613: WHERE c.status='A'
3614: AND c.party_id = party.party_id
3615: AND party.party_name <= p_customer_name_high
3616: AND c.account_number BETWEEN p_cust_number_low

Line 3635: , hz_parties party

3631: , c.cust_account_id customer_id
3632: , c.account_number customer_number
3633: FROM
3634: hz_cust_accounts c
3635: , hz_parties party
3636: WHERE c.status='A'
3637: AND c.party_id = party.party_id
3638: AND party.party_name BETWEEN p_customer_name_low
3639: AND NVL(p_customer_name_high, party.party_name)

Line 3658: , hz_parties party

3654: , c.cust_account_id customer_id
3655: , c.account_number customer_number
3656: FROM
3657: hz_cust_accounts c
3658: , hz_parties party
3659: WHERE c.status='A'
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

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 BETWEEN p_customer_name_low
3683: AND NVL(p_customer_name_high, party.party_name)

Line 3700: , hz_parties party

3696: , c.cust_account_id customer_id
3697: , c.account_number customer_number
3698: FROM
3699: hz_cust_accounts c
3700: , hz_parties party
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

Line 3720: , hz_parties party

3716: , c.cust_account_id customer_id
3717: , c.account_number customer_number
3718: FROM
3719: hz_cust_accounts c
3720: , hz_parties party
3721: WHERE c.status='A'
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 )

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.account_number <= p_cust_number_high
3745: AND c.cust_account_id IN (SELECT cp.cust_account_id

Line 3765: , hz_parties party

3761: , c.cust_account_id customer_id
3762: , c.account_number customer_number
3763: FROM
3764: hz_cust_accounts c
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