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.ASO_VALIDATE_PVT dependencies on HZ_PARTIES

Line 161: SELECT status FROM HZ_PARTIES

157: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
158: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
159: IS
160: CURSOR C_Party IS
161: SELECT status FROM HZ_PARTIES
162: WHERE party_id = p_party_id;
163: l_party_status VARCHAR2(1);
164:
165: BEGIN

Line 1929: FROM HZ_PARTIES

1925: AND a.party_relationship_id = b.relationship_id;
1926:
1927: CURSOR C_Party_Cust(l_party_id NUMBER) IS
1928: SELECT status, party_type
1929: FROM HZ_PARTIES
1930: WHERE party_id= l_party_id;
1931:
1932: l_party_relationship_id NUMBER;
1933: l_subject_id NUMBER;

Line 2000: SELECT status FROM HZ_PARTIES

1996: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1997: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
1998: IS
1999: CURSOR C_Party(l_pty_id NUMBER) IS
2000: SELECT status FROM HZ_PARTIES
2001: WHERE party_id = l_pty_id and party_type in
2002: ('PERSON','PARTY_RELATIONSHIP','ORGANIZATION');
2003:
2004: l_party_status VARCHAR2(1);

Line 2053: SELECT status FROM HZ_PARTIES

2049: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
2050: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
2051: IS
2052: CURSOR C_Party(l_pty_id NUMBER) IS
2053: SELECT status FROM HZ_PARTIES
2054: WHERE party_id = l_pty_id AND party_type ='PARTY_RELATIONSHIP';
2055:
2056: l_party_status VARCHAR2(1);
2057:

Line 2209: SELECT party_type FROM HZ_PARTIES

2205: WHERE party_id = p_party_id AND cust_account_id = p_cust_account_id
2206: AND role_type ='ACCOUNT_USER';
2207:
2208: CURSOR C_party(l_pty_id NUMBER) IS
2209: SELECT party_type FROM HZ_PARTIES
2210: WHERE party_id= l_pty_id;
2211:
2212: CURSOR C_relation IS
2213: SELECT 'x' FROM

Line 2367: AND exists (select 'y' from HZ_PARTIES d

2363: WHERE
2364: a.party_id = p_inv_party_id
2365: AND a.object_id = lc_party_id
2366: AND b.party_relationship_id = a.relationship_id
2367: AND exists (select 'y' from HZ_PARTIES d
2368: where d.party_type ='PERSON' and
2369: d.party_id= a.subject_id);
2370:
2371:

Line 2379: from hz_parties

2375: where
2376: cust_account_id = l_cust_acct_id;
2377: CURSOR C_party_type IS
2378: select party_type
2379: from hz_parties
2380: where party_id = p_party_id;
2381:
2382: CURSOR C_relation_object IS
2383: select object_id

Line 2388: and subject_table_name = 'HZ_PARTIES'

2384: from
2385: hz_relationships
2386: where party_id = p_party_id
2387: and subject_type ='PERSON'
2388: and subject_table_name = 'HZ_PARTIES'
2389: and object_type = 'ORGANIZATION'
2390: and object_table_name = 'HZ_PARTIES';
2391:
2392: CURSOR C_Person_Reltn (l_party NUMBER) IS

Line 2390: and object_table_name = 'HZ_PARTIES';

2386: where party_id = p_party_id
2387: and subject_type ='PERSON'
2388: and subject_table_name = 'HZ_PARTIES'
2389: and object_type = 'ORGANIZATION'
2390: and object_table_name = 'HZ_PARTIES';
2391:
2392: CURSOR C_Person_Reltn (l_party NUMBER) IS
2393: SELECT 'X'
2394: FROM HZ_RELATIONSHIPS

Line 2544: SELECT b.party_id,a.party_type FROM HZ_PARTIES a,HZ_PARTY_SITES b

2540: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
2541: IS
2542:
2543: CURSOR c_party_site( l_party_site_id NUMBER) IS
2544: SELECT b.party_id,a.party_type FROM HZ_PARTIES a,HZ_PARTY_SITES b
2545: WHERE a.party_id = b.party_id
2546: AND b.party_site_id = l_party_site_id;
2547:
2548: CURSOR C_Cust_party_id(l_cust_acct_id number) IS

Line 2555: from hz_parties

2551: where
2552: cust_account_id = l_cust_acct_id;
2553: CURSOR C_party_type IS
2554: select party_type
2555: from hz_parties
2556: where party_id = p_party_id;
2557:
2558: CURSOR C_relation_object(px_party_id number) IS
2559: select object_id

Line 2564: and subject_table_name = 'HZ_PARTIES'

2560: from
2561: hz_relationships
2562: where party_id = px_party_id
2563: and subject_type ='PERSON'
2564: and subject_table_name = 'HZ_PARTIES'
2565: and object_type = 'ORGANIZATION'
2566: and object_table_name = 'HZ_PARTIES';
2567:
2568:

Line 2566: and object_table_name = 'HZ_PARTIES';

2562: where party_id = px_party_id
2563: and subject_type ='PERSON'
2564: and subject_table_name = 'HZ_PARTIES'
2565: and object_type = 'ORGANIZATION'
2566: and object_table_name = 'HZ_PARTIES';
2567:
2568:
2569: l_party_type VARCHAR2(30);
2570: l_party_id NUMBER;

Line 2720: SELECT status from HZ_PARTIES a

2716: HZ_RELATIONSHIPS b
2717: WHERE org_contact_id = p_contact_id
2718: and a.party_relationship_id = b.relationship_id;
2719: CURSOR C_Party(l_party_id NUMBER) IS
2720: SELECT status from HZ_PARTIES a
2721: WHERE a.party_id=l_party_id and a.party_id=p_party_id
2722: AND Party_type in('ORGANIZATION','PARTY_RELATIONSHIP');
2723:
2724:

Line 5799: HZ_PARTIES hp

5795: SELECT 1 FROM DUAL WHERE EXISTS
5796: (
5797: SELECT phone.contact_point_id
5798: FROM HZ_CONTACT_POINTS phone,
5799: HZ_PARTIES hp
5800: WHERE HP.party_id = p_party_id --When contact is specified
5801: AND phone.owner_table_id = hp.party_id
5802: AND hp.status = 'A'
5803: AND phone.status = 'A'

Line 5804: AND phone.owner_table_name = 'HZ_PARTIES'

5800: WHERE HP.party_id = p_party_id --When contact is specified
5801: AND phone.owner_table_id = hp.party_id
5802: AND hp.status = 'A'
5803: AND phone.status = 'A'
5804: AND phone.owner_table_name = 'HZ_PARTIES'
5805: AND phone.contact_point_type = 'PHONE'
5806: AND phone.contact_point_id = p_phone_id
5807: );
5808:

Line 5816: HZ_PARTIES hp

5812: (
5813:
5814: SELECT phone.contact_point_id
5815: FROM HZ_CONTACT_POINTS phone,
5816: HZ_PARTIES hp
5817: WHERE HP.party_id = p_cust_party_id
5818: AND phone.owner_table_id = hp.party_id
5819: AND hp.status = 'A'
5820: AND phone.status = 'A'

Line 5821: AND phone.owner_table_name = 'HZ_PARTIES'

5817: WHERE HP.party_id = p_cust_party_id
5818: AND phone.owner_table_id = hp.party_id
5819: AND hp.status = 'A'
5820: AND phone.status = 'A'
5821: AND phone.owner_table_name = 'HZ_PARTIES'
5822: AND phone.contact_point_type = 'PHONE'
5823: AND phone.contact_point_id = p_phone_id
5824: );
5825:

Line 5831: SELECT PARTY_TYPE --Selecting the party type from HZ_PARTIES

5827: l_cust_party_type varchar(20);
5828:
5829: BEGIN
5830:
5831: SELECT PARTY_TYPE --Selecting the party type from HZ_PARTIES
5832: INTO l_cust_party_type
5833: FROM HZ_PARTIES
5834: WHERE PARTY_ID = nvl(p_party_id,p_cust_party_id);
5835:

Line 5833: FROM HZ_PARTIES

5829: BEGIN
5830:
5831: SELECT PARTY_TYPE --Selecting the party type from HZ_PARTIES
5832: INTO l_cust_party_type
5833: FROM HZ_PARTIES
5834: WHERE PARTY_ID = nvl(p_party_id,p_cust_party_id);
5835:
5836: --When contact is specified
5837: IF p_party_id is not null then

Line 5904: FROM HZ_PARTIES HP

5900: CURSOR C_CUST_PARTY IS
5901: SELECT 1 FROM DUAL WHERE EXISTS
5902: (
5903: SELECT hp.party_name --(Base Query)
5904: FROM HZ_PARTIES HP
5905: WHERE hp.party_type in ('PERSON','ORGANIZATION')
5906: AND hp.status = 'A'
5907: AND HP.PARTY_ID = p_cust_party_id
5908: );

Line 5916: from HZ_PARTIES P

5912: CURSOR C_CUST_PARTY_MANAGER IS
5913: SELECT 1 FROM DUAL WHERE EXISTS
5914: (
5915: select null
5916: from HZ_PARTIES P
5917: where P.status = 'A'
5918: AND p.party_type in ('PERSON','ORGANIZATION')
5919: AND P.party_id = p_cust_party_id
5920: AND EXISTS ( SELECT null

Line 5948: HZ_PARTIES P

5944: AND secu.sales_lead_id IS NULL )
5945: UNION ALL
5946: SELECT null
5947: FROM as_accesses_all_all secu,
5948: HZ_PARTIES P
5949: WHERE secu.customer_id = P.party_id
5950: AND secu.lead_id IS NULL
5951: AND secu.sales_lead_id IS NULL
5952: AND secu.delete_flag is NULL

Line 5964: from HZ_PARTIES P

5960: SELECT 1 FROM DUAL WHERE EXISTS
5961: (
5962:
5963: select P.party_name
5964: from HZ_PARTIES P
5965: where P.status = 'A'
5966: AND P.party_id = p_cust_party_id
5967: AND p.party_type in ('PERSON','ORGANIZATION')
5968: AND (exists (SELECT null

Line 6210: FROM HZ_PARTIES hp_contact,

6206: CURSOR C_CONTACT_NAME IS
6207: SELECT 1 FROM DUAL WHERE EXISTS
6208: (
6209: SELECT hp_contact.party_name
6210: FROM HZ_PARTIES hp_contact,
6211: HZ_RELATIONSHIPS hp_rltn
6212: WHERE hp_rltn.object_id = p_cust_party_id --lv_cust_party_id
6213: AND hp_rltn.party_id = p_party_id
6214: AND hp_contact.party_id = hp_rltn.subject_id

Line 6382: FROM HZ_PARTIES hp

6378: --p_quote_header_rec.cust_account_id-->p_cust_acct_id
6379: SELECT 1 FROM DUAL WHERE EXISTS
6380: (
6381: SELECT hp.party_id --Removed HZ_CUST_ACCOUNTS ca
6382: FROM HZ_PARTIES hp
6383: WHERE hp.party_type in ('PERSON','ORGANIZATION')
6384: AND hp.party_id = p_cust_party_id
6385: AND hp.status = 'A'
6386: UNION

Line 6388: FROM HZ_PARTIES hp,

6384: AND hp.party_id = p_cust_party_id
6385: AND hp.status = 'A'
6386: UNION
6387: SELECT hp.party_id
6388: FROM HZ_PARTIES hp,
6389: HZ_CUST_ACCT_RELATE car
6390: WHERE car.related_cust_account_id = p_cust_acct_id
6391: AND car.relationship_type = 'ALL'
6392: AND car.bill_to_flag = 'Y'

Line 6406: FROM HZ_PARTIES hp

6402: --p_quote_header_rec.cust_account_id-->p_cust_acct_id
6403: SELECT 1 FROM DUAL WHERE EXISTS
6404: (
6405: SELECT hp.party_id
6406: FROM HZ_PARTIES hp
6407: WHERE hp.party_id = p_cust_party_id
6408: AND hp.status = 'A'
6409: AND hp.party_type in ('PERSON','ORGANIZATION')
6410: UNION

Line 6412: FROM HZ_PARTIES hp,

6408: AND hp.status = 'A'
6409: AND hp.party_type in ('PERSON','ORGANIZATION')
6410: UNION
6411: SELECT hp.party_id
6412: FROM HZ_PARTIES hp,
6413: HZ_CUST_ACCT_RELATE car
6414: WHERE car.related_cust_account_id = p_cust_acct_id
6415: AND car.relationship_type = 'ALL'
6416: AND car.ship_to_flag = 'Y'

Line 6429: FROM HZ_PARTIES hp

6425: CURSOR C_CUSTOMER IS
6426: SELECT 1 FROM DUAL WHERE EXISTS
6427: (
6428: SELECT hp.party_id
6429: FROM HZ_PARTIES hp
6430: WHERE hp.party_type in ('PERSON','ORGANIZATION')
6431: AND hp.status = 'A'
6432: AND hp.party_id = p_cust_party_id --:QOTHDDET_MAIN.sold_to_cust_party_id
6433: ) ;

Line 6441: from HZ_PARTIES P

6437: CURSOR C_CUSTOMER_MANAGER IS
6438: SELECT 1 FROM DUAL WHERE EXISTS
6439: (
6440: select P.party_id
6441: from HZ_PARTIES P
6442: where P.status = 'A'
6443: AND P.party_id = p_cust_party_id
6444: AND EXISTS ( SELECT null
6445: FROM as_accesses_all secu

Line 6485: from HZ_PARTIES P

6481: SELECT 1 FROM DUAL WHERE EXISTS
6482: (
6483:
6484: select P.status
6485: from HZ_PARTIES P
6486: where P.status = 'A'
6487: AND P.party_id = p_cust_party_id
6488: AND (exists (SELECT null
6489: FROM as_accesses_all secu

Line 6824: -- FROM HZ_PARTIES hp,

6820: --p_quote_header_rec.cust_account_id-->p_cust_acct_id
6821: --SELECT 1 FROM DUAL WHERE EXISTS
6822: --(
6823: -- SELECT ca.account_number
6824: -- FROM HZ_PARTIES hp,
6825: -- HZ_CUST_ACCOUNTS ca,
6826: -- HZ_CUST_ACCT_RELATE car
6827: -- WHERE hp.party_id = ca.party_id
6828: -- AND ((car.related_cust_account_id = p_sold_to_cust_acct_id

Line 6845: FROM HZ_PARTIES hp,

6841: --) ;
6842: SELECT 1 FROM DUAL WHERE EXISTS
6843: (
6844: SELECT ca.account_number
6845: FROM HZ_PARTIES hp,
6846: HZ_CUST_ACCOUNTS ca,
6847: HZ_CUST_ACCT_RELATE car
6848: WHERE hp.party_id = ca.party_id
6849: AND car.related_cust_account_id = p_sold_to_cust_acct_id

Line 6863: FROM HZ_PARTIES hp,

6859: AND trunc(nvl(ca.account_termination_date,sysdate)) >= trunc(sysdate)
6860: AND car.status = 'A'
6861: UNION
6862: SELECT ca.account_number
6863: FROM HZ_PARTIES hp,
6864: HZ_CUST_ACCOUNTS ca
6865: WHERE hp.party_id = ca.party_id
6866: AND ca.cust_account_id = p_sold_to_cust_acct_id
6867: AND hp.party_id = p_cust_party_id

Line 6883: -- FROM HZ_PARTIES hp,

6879: --p_quote_header_rec.cust_account_id-->p_cust_acct_id
6880: --SELECT 1 FROM DUAL WHERE EXISTS
6881: --(
6882: -- SELECT ca.account_number
6883: -- FROM HZ_PARTIES hp,
6884: -- HZ_CUST_ACCOUNTS ca,
6885: -- HZ_CUST_ACCT_RELATE car
6886: -- WHERE hp.party_id = ca.party_id
6887: -- AND ((car.related_cust_account_id = p_sold_to_cust_acct_id

Line 6902: FROM HZ_PARTIES hp,

6898: -- AND trunc(nvl(ca.account_termination_date,sysdate)) >= trunc(sysdate)
6899: -- AND car.status = 'A'
6900: --) ;
6901: SELECT ca.account_number
6902: FROM HZ_PARTIES hp,
6903: HZ_CUST_ACCOUNTS ca,
6904: HZ_CUST_ACCT_RELATE car
6905: WHERE hp.party_id = ca.party_id
6906: AND car.related_cust_account_id = p_sold_to_cust_acct_id

Line 6918: FROM HZ_PARTIES hp,

6914: AND hp.status = 'A'
6915: AND ca.status = 'A'
6916: UNION
6917: SELECT ca.account_number
6918: FROM HZ_PARTIES hp,
6919: HZ_CUST_ACCOUNTS ca
6920: WHERE hp.party_id = ca.party_id
6921: AND ca.cust_account_id = p_sold_to_cust_acct_id
6922: AND hp.party_id = p_cust_party_id

Line 6936: FROM HZ_PARTIES hp,

6932: CURSOR C_CUST_ACCOUNT IS
6933: SELECT 1 FROM DUAL WHERE EXISTS
6934: (
6935: SELECT ca.account_number
6936: FROM HZ_PARTIES hp,
6937: HZ_CUST_ACCOUNTS ca
6938: WHERE hp.party_id = ca.party_id
6939: AND hp.party_type in ('PERSON','ORGANIZATION')
6940: AND hp.status = 'A'

Line 6954: from HZ_PARTIES P

6950: CURSOR C_CUST_ACCOUNT_MANAGER IS
6951: SELECT 1 FROM DUAL WHERE EXISTS
6952: (
6953: select null
6954: from HZ_PARTIES P
6955: ,HZ_CUST_ACCOUNTS CA
6956: where CA.status = 'A'
6957: AND p.party_type in ('PERSON','ORGANIZATION')
6958: AND P.party_id = p_cust_party_id

Line 6990: HZ_PARTIES P

6986: AND jrgu.usage in ('SALES', 'PRM')))
6987: UNION ALL
6988: SELECT null
6989: FROM as_accesses_all_all secu,
6990: HZ_PARTIES P
6991: WHERE secu.customer_id = P.party_id
6992: AND secu.lead_id IS NULL
6993: AND secu.sales_lead_id IS NULL
6994: AND secu.delete_flag is NULL

Line 7006: from HZ_PARTIES HP ,

7002: SELECT 1 FROM DUAL WHERE EXISTS
7003: (
7004:
7005: select CA.account_number
7006: from HZ_PARTIES HP ,
7007: HZ_CUST_ACCOUNTS CA
7008: where CA.status = 'A'
7009: AND trunc(nvl(CA.account_activation_date, SYSDATE)) <= trunc(SYSDATE)
7010: AND trunc(nvl(CA.account_termination_date, SYSDATE)) >= trunc(SYSDATE)

Line 7317: FROM HZ_PARTIES hp,

7313: CURSOR C_PARTY_ADDRESS IS
7314: SELECT 1 FROM DUAL WHERE EXISTS
7315: (
7316: SELECT site.party_site_id
7317: FROM HZ_PARTIES hp,
7318: HZ_PARTY_SITES site
7319: WHERE site.party_id = hp.party_id
7320: AND site.PARTY_SITE_ID = p_party_site_id --Added join for party_site_id
7321: AND hp.status = 'A'

Line 7331: FROM HZ_PARTIES hp,

7327: CURSOR C_CUST_PARTY_ADDRESS_NOT_NULL IS
7328: SELECT 1 FROM DUAL WHERE EXISTS
7329: (
7330: SELECT site.party_site_id
7331: FROM HZ_PARTIES hp,
7332: HZ_PARTY_SITES site
7333: WHERE site.party_id = hp.party_id
7334: AND site.PARTY_SITE_ID = p_party_site_id --Added join for party_site_id
7335: AND hp.status = 'A'

Line 7346: FROM HZ_PARTIES hp,

7342: SELECT 1 FROM DUAL WHERE EXISTS
7343: (
7344:
7345: SELECT site.party_site_id
7346: FROM HZ_PARTIES hp,
7347: HZ_PARTY_SITES site
7348: WHERE site.party_id = hp.party_id
7349: AND site.PARTY_SITE_ID = p_party_site_id --Added join for party_site_id
7350: AND hp.status = 'A'

Line 7703: FROM HZ_PARTIES HP,

7699: CURSOR C_SOLD_TO_ACCOUNT IS
7700: SELECT 1 FROM DUAL WHERE EXISTS
7701: (
7702: SELECT ca.account_number
7703: FROM HZ_PARTIES HP,
7704: HZ_CUST_ACCOUNTS CA
7705: WHERE hp.party_id = ca.party_id
7706: AND hp.status = 'A'
7707: AND ca.status = 'A'

Line 7718: from HZ_PARTIES P

7714: CURSOR C_SOLD_TO_ACCOUNT_NO_MANAGER IS
7715: SELECT 1 FROM DUAL WHERE EXISTS
7716: (
7717: select ca.account_number
7718: from HZ_PARTIES P
7719: , HZ_CUST_ACCOUNTS CA
7720: where CA.status = 'A'
7721: AND trunc(nvl(CA.account_activation_date, SYSDATE)) <= trunc(SYSDATE)
7722: AND trunc(nvl(CA.account_termination_date, SYSDATE)) >= trunc(SYSDATE)

Line 7742: from HZ_PARTIES P

7738: SELECT 1 FROM DUAL WHERE EXISTS
7739: (
7740:
7741: select null
7742: from HZ_PARTIES P
7743: ,HZ_CUST_ACCOUNTS CA
7744: where CA.status = 'A'
7745: AND P.status = 'A'
7746: AND P.party_id = CA.party_id

Line 7775: FROM as_accesses_all_all secu,HZ_PARTIES P

7771: AND jrgu.group_id = jrgd.group_id
7772: AND jrgu.usage in ('SALES', 'PRM')) )
7773: UNION ALL
7774: SELECT null
7775: FROM as_accesses_all_all secu,HZ_PARTIES P
7776: WHERE secu.customer_id = P.party_id
7777: AND secu.lead_id IS NULL
7778: AND secu.sales_lead_id IS NULL
7779: AND secu.delete_flag is NULL