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 1931: FROM HZ_PARTIES

1927:
1928:
1929: CURSOR C_Party_Cust(l_party_id NUMBER) IS
1930: SELECT status, party_type
1931: FROM HZ_PARTIES
1932: WHERE party_id= l_party_id;
1933:
1934: l_party_relationship_id NUMBER;
1935: l_subject_id NUMBER;

Line 2002: SELECT status FROM HZ_PARTIES

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

Line 2055: SELECT status FROM HZ_PARTIES

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

Line 2211: SELECT party_type FROM HZ_PARTIES

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

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

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

Line 2381: from hz_parties

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

Line 2390: and subject_table_name = 'HZ_PARTIES'

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

Line 2392: and object_table_name = 'HZ_PARTIES';

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

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

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

Line 2557: from hz_parties

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

Line 2566: and subject_table_name = 'HZ_PARTIES'

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

Line 2568: and object_table_name = 'HZ_PARTIES';

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

Line 2723: SELECT status from HZ_PARTIES a

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

Line 5815: HZ_PARTIES hp

5811: SELECT 1 FROM DUAL WHERE EXISTS
5812: (
5813: SELECT phone.contact_point_id
5814: FROM HZ_CONTACT_POINTS phone,
5815: HZ_PARTIES hp
5816: WHERE HP.party_id = p_party_id --When contact is specified
5817: AND phone.owner_table_id = hp.party_id
5818: AND hp.status = 'A'
5819: AND phone.status = 'A'

Line 5820: AND phone.owner_table_name = 'HZ_PARTIES'

5816: WHERE HP.party_id = p_party_id --When contact is specified
5817: AND phone.owner_table_id = hp.party_id
5818: AND hp.status = 'A'
5819: AND phone.status = 'A'
5820: AND phone.owner_table_name = 'HZ_PARTIES'
5821: AND phone.contact_point_type = 'PHONE'
5822: AND phone.contact_point_id = p_phone_id
5823: );
5824:

Line 5832: HZ_PARTIES hp

5828: (
5829:
5830: SELECT phone.contact_point_id
5831: FROM HZ_CONTACT_POINTS phone,
5832: HZ_PARTIES hp
5833: WHERE HP.party_id = p_cust_party_id
5834: AND phone.owner_table_id = hp.party_id
5835: AND hp.status = 'A'
5836: AND phone.status = 'A'

Line 5837: AND phone.owner_table_name = 'HZ_PARTIES'

5833: WHERE HP.party_id = p_cust_party_id
5834: AND phone.owner_table_id = hp.party_id
5835: AND hp.status = 'A'
5836: AND phone.status = 'A'
5837: AND phone.owner_table_name = 'HZ_PARTIES'
5838: AND phone.contact_point_type = 'PHONE'
5839: AND phone.contact_point_id = p_phone_id
5840: );
5841:

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

5843: l_cust_party_type varchar(20);
5844:
5845: BEGIN
5846:
5847: SELECT PARTY_TYPE --Selecting the party type from HZ_PARTIES
5848: INTO l_cust_party_type
5849: FROM HZ_PARTIES
5850: WHERE PARTY_ID = nvl(p_party_id,p_cust_party_id);
5851:

Line 5849: FROM HZ_PARTIES

5845: BEGIN
5846:
5847: SELECT PARTY_TYPE --Selecting the party type from HZ_PARTIES
5848: INTO l_cust_party_type
5849: FROM HZ_PARTIES
5850: WHERE PARTY_ID = nvl(p_party_id,p_cust_party_id);
5851:
5852: --When contact is specified
5853: IF p_party_id is not null then

Line 5920: FROM HZ_PARTIES HP

5916: CURSOR C_CUST_PARTY IS
5917: SELECT 1 FROM DUAL WHERE EXISTS
5918: (
5919: SELECT hp.party_name --(Base Query)
5920: FROM HZ_PARTIES HP
5921: WHERE hp.party_type in ('PERSON','ORGANIZATION')
5922: AND hp.status = 'A'
5923: AND HP.PARTY_ID = p_cust_party_id
5924: );

Line 5932: from HZ_PARTIES P

5928: CURSOR C_CUST_PARTY_MANAGER IS
5929: SELECT 1 FROM DUAL WHERE EXISTS
5930: (
5931: select null
5932: from HZ_PARTIES P
5933: where P.status = 'A'
5934: AND p.party_type in ('PERSON','ORGANIZATION')
5935: AND P.party_id = p_cust_party_id
5936: AND EXISTS ( SELECT null

Line 5964: HZ_PARTIES P

5960: AND secu.sales_lead_id IS NULL )
5961: UNION ALL
5962: SELECT null
5963: FROM as_accesses_all_all secu,
5964: HZ_PARTIES P
5965: WHERE secu.customer_id = P.party_id
5966: AND secu.lead_id IS NULL
5967: AND secu.sales_lead_id IS NULL
5968: AND secu.delete_flag is NULL

Line 5980: from HZ_PARTIES P

5976: SELECT 1 FROM DUAL WHERE EXISTS
5977: (
5978:
5979: select P.party_name
5980: from HZ_PARTIES P
5981: where P.status = 'A'
5982: AND P.party_id = p_cust_party_id
5983: AND p.party_type in ('PERSON','ORGANIZATION')
5984: AND (exists (SELECT null

Line 6226: FROM HZ_PARTIES hp_contact,

6222: CURSOR C_CONTACT_NAME IS
6223: SELECT 1 FROM DUAL WHERE EXISTS
6224: (
6225: SELECT hp_contact.party_name
6226: FROM HZ_PARTIES hp_contact,
6227: HZ_RELATIONSHIPS hp_rltn
6228: WHERE hp_rltn.object_id = p_cust_party_id --lv_cust_party_id
6229: AND hp_rltn.party_id = p_party_id
6230: AND hp_contact.party_id = hp_rltn.subject_id

Line 6398: FROM HZ_PARTIES hp

6394: --p_quote_header_rec.cust_account_id-->p_cust_acct_id
6395: SELECT 1 FROM DUAL WHERE EXISTS
6396: (
6397: SELECT hp.party_id --Removed HZ_CUST_ACCOUNTS ca
6398: FROM HZ_PARTIES hp
6399: WHERE hp.party_type in ('PERSON','ORGANIZATION')
6400: AND hp.party_id = p_cust_party_id
6401: AND hp.status = 'A'
6402: UNION

Line 6404: FROM HZ_PARTIES hp,

6400: AND hp.party_id = p_cust_party_id
6401: AND hp.status = 'A'
6402: UNION
6403: SELECT hp.party_id
6404: FROM HZ_PARTIES hp,
6405: HZ_CUST_ACCT_RELATE car
6406: WHERE car.related_cust_account_id = p_cust_acct_id
6407: AND car.relationship_type = 'ALL'
6408: AND car.bill_to_flag = 'Y'

Line 6422: FROM HZ_PARTIES hp

6418: --p_quote_header_rec.cust_account_id-->p_cust_acct_id
6419: SELECT 1 FROM DUAL WHERE EXISTS
6420: (
6421: SELECT hp.party_id
6422: FROM HZ_PARTIES hp
6423: WHERE hp.party_id = p_cust_party_id
6424: AND hp.status = 'A'
6425: AND hp.party_type in ('PERSON','ORGANIZATION')
6426: UNION

Line 6428: FROM HZ_PARTIES hp,

6424: AND hp.status = 'A'
6425: AND hp.party_type in ('PERSON','ORGANIZATION')
6426: UNION
6427: SELECT hp.party_id
6428: FROM HZ_PARTIES hp,
6429: HZ_CUST_ACCT_RELATE car
6430: WHERE car.related_cust_account_id = p_cust_acct_id
6431: AND car.relationship_type = 'ALL'
6432: AND car.ship_to_flag = 'Y'

Line 6445: FROM HZ_PARTIES hp

6441: CURSOR C_CUSTOMER IS
6442: SELECT 1 FROM DUAL WHERE EXISTS
6443: (
6444: SELECT hp.party_id
6445: FROM HZ_PARTIES hp
6446: WHERE hp.party_type in ('PERSON','ORGANIZATION')
6447: AND hp.status = 'A'
6448: AND hp.party_id = p_cust_party_id --:QOTHDDET_MAIN.sold_to_cust_party_id
6449: ) ;

Line 6457: from HZ_PARTIES P

6453: CURSOR C_CUSTOMER_MANAGER IS
6454: SELECT 1 FROM DUAL WHERE EXISTS
6455: (
6456: select P.party_id
6457: from HZ_PARTIES P
6458: where P.status = 'A'
6459: AND P.party_id = p_cust_party_id
6460: AND EXISTS ( SELECT null
6461: FROM as_accesses_all secu

Line 6501: from HZ_PARTIES P

6497: SELECT 1 FROM DUAL WHERE EXISTS
6498: (
6499:
6500: select P.status
6501: from HZ_PARTIES P
6502: where P.status = 'A'
6503: AND P.party_id = p_cust_party_id
6504: AND (exists (SELECT null
6505: FROM as_accesses_all secu

Line 6840: -- FROM HZ_PARTIES hp,

6836: --p_quote_header_rec.cust_account_id-->p_cust_acct_id
6837: --SELECT 1 FROM DUAL WHERE EXISTS
6838: --(
6839: -- SELECT ca.account_number
6840: -- FROM HZ_PARTIES hp,
6841: -- HZ_CUST_ACCOUNTS ca,
6842: -- HZ_CUST_ACCT_RELATE car
6843: -- WHERE hp.party_id = ca.party_id
6844: -- AND ((car.related_cust_account_id = p_sold_to_cust_acct_id

Line 6861: FROM HZ_PARTIES hp,

6857: --) ;
6858: SELECT 1 FROM DUAL WHERE EXISTS
6859: (
6860: SELECT ca.account_number
6861: FROM HZ_PARTIES hp,
6862: HZ_CUST_ACCOUNTS ca,
6863: HZ_CUST_ACCT_RELATE car
6864: WHERE hp.party_id = ca.party_id
6865: AND car.related_cust_account_id = p_sold_to_cust_acct_id

Line 6879: FROM HZ_PARTIES hp,

6875: AND trunc(nvl(ca.account_termination_date,sysdate)) >= trunc(sysdate)
6876: AND car.status = 'A'
6877: UNION
6878: SELECT ca.account_number
6879: FROM HZ_PARTIES hp,
6880: HZ_CUST_ACCOUNTS ca
6881: WHERE hp.party_id = ca.party_id
6882: AND ca.cust_account_id = p_sold_to_cust_acct_id
6883: AND hp.party_id = p_cust_party_id

Line 6899: -- FROM HZ_PARTIES hp,

6895: --p_quote_header_rec.cust_account_id-->p_cust_acct_id
6896: --SELECT 1 FROM DUAL WHERE EXISTS
6897: --(
6898: -- SELECT ca.account_number
6899: -- FROM HZ_PARTIES hp,
6900: -- HZ_CUST_ACCOUNTS ca,
6901: -- HZ_CUST_ACCT_RELATE car
6902: -- WHERE hp.party_id = ca.party_id
6903: -- AND ((car.related_cust_account_id = p_sold_to_cust_acct_id

Line 6918: FROM HZ_PARTIES hp,

6914: -- AND trunc(nvl(ca.account_termination_date,sysdate)) >= trunc(sysdate)
6915: -- AND car.status = 'A'
6916: --) ;
6917: SELECT ca.account_number
6918: FROM HZ_PARTIES hp,
6919: HZ_CUST_ACCOUNTS ca,
6920: HZ_CUST_ACCT_RELATE car
6921: WHERE hp.party_id = ca.party_id
6922: AND car.related_cust_account_id = p_sold_to_cust_acct_id

Line 6934: FROM HZ_PARTIES hp,

6930: AND hp.status = 'A'
6931: AND ca.status = 'A'
6932: UNION
6933: SELECT ca.account_number
6934: FROM HZ_PARTIES hp,
6935: HZ_CUST_ACCOUNTS ca
6936: WHERE hp.party_id = ca.party_id
6937: AND ca.cust_account_id = p_sold_to_cust_acct_id
6938: AND hp.party_id = p_cust_party_id

Line 6952: FROM HZ_PARTIES hp,

6948: CURSOR C_CUST_ACCOUNT IS
6949: SELECT 1 FROM DUAL WHERE EXISTS
6950: (
6951: SELECT ca.account_number
6952: FROM HZ_PARTIES hp,
6953: HZ_CUST_ACCOUNTS ca
6954: WHERE hp.party_id = ca.party_id
6955: AND hp.party_type in ('PERSON','ORGANIZATION')
6956: AND hp.status = 'A'

Line 6970: from HZ_PARTIES P

6966: CURSOR C_CUST_ACCOUNT_MANAGER IS
6967: SELECT 1 FROM DUAL WHERE EXISTS
6968: (
6969: select null
6970: from HZ_PARTIES P
6971: ,HZ_CUST_ACCOUNTS CA
6972: where CA.status = 'A'
6973: AND p.party_type in ('PERSON','ORGANIZATION')
6974: AND P.party_id = p_cust_party_id

Line 7006: HZ_PARTIES P

7002: AND jrgu.usage in ('SALES', 'PRM')))
7003: UNION ALL
7004: SELECT null
7005: FROM as_accesses_all_all secu,
7006: HZ_PARTIES P
7007: WHERE secu.customer_id = P.party_id
7008: AND secu.lead_id IS NULL
7009: AND secu.sales_lead_id IS NULL
7010: AND secu.delete_flag is NULL

Line 7022: from HZ_PARTIES HP ,

7018: SELECT 1 FROM DUAL WHERE EXISTS
7019: (
7020:
7021: select CA.account_number
7022: from HZ_PARTIES HP ,
7023: HZ_CUST_ACCOUNTS CA
7024: where CA.status = 'A'
7025: AND trunc(nvl(CA.account_activation_date, SYSDATE)) <= trunc(SYSDATE)
7026: AND trunc(nvl(CA.account_termination_date, SYSDATE)) >= trunc(SYSDATE)

Line 7333: FROM HZ_PARTIES hp,

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

Line 7347: FROM HZ_PARTIES hp,

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

Line 7362: FROM HZ_PARTIES hp,

7358: SELECT 1 FROM DUAL WHERE EXISTS
7359: (
7360:
7361: SELECT site.party_site_id
7362: FROM HZ_PARTIES hp,
7363: HZ_PARTY_SITES site
7364: WHERE site.party_id = hp.party_id
7365: AND site.PARTY_SITE_ID = p_party_site_id --Added join for party_site_id
7366: AND hp.status = 'A'

Line 7719: FROM HZ_PARTIES HP,

7715: CURSOR C_SOLD_TO_ACCOUNT IS
7716: SELECT 1 FROM DUAL WHERE EXISTS
7717: (
7718: SELECT ca.account_number
7719: FROM HZ_PARTIES HP,
7720: HZ_CUST_ACCOUNTS CA
7721: WHERE hp.party_id = ca.party_id
7722: AND hp.status = 'A'
7723: AND ca.status = 'A'

Line 7734: from HZ_PARTIES P

7730: CURSOR C_SOLD_TO_ACCOUNT_NO_MANAGER IS
7731: SELECT 1 FROM DUAL WHERE EXISTS
7732: (
7733: select ca.account_number
7734: from HZ_PARTIES P
7735: , HZ_CUST_ACCOUNTS CA
7736: where CA.status = 'A'
7737: AND trunc(nvl(CA.account_activation_date, SYSDATE)) <= trunc(SYSDATE)
7738: AND trunc(nvl(CA.account_termination_date, SYSDATE)) >= trunc(SYSDATE)

Line 7758: from HZ_PARTIES P

7754: SELECT 1 FROM DUAL WHERE EXISTS
7755: (
7756:
7757: select null
7758: from HZ_PARTIES P
7759: ,HZ_CUST_ACCOUNTS CA
7760: where CA.status = 'A'
7761: AND P.status = 'A'
7762: AND P.party_id = CA.party_id

Line 7791: FROM as_accesses_all_all secu,HZ_PARTIES P

7787: AND jrgu.group_id = jrgd.group_id
7788: AND jrgu.usage in ('SALES', 'PRM')) )
7789: UNION ALL
7790: SELECT null
7791: FROM as_accesses_all_all secu,HZ_PARTIES P
7792: WHERE secu.customer_id = P.party_id
7793: AND secu.lead_id IS NULL
7794: AND secu.sales_lead_id IS NULL
7795: AND secu.delete_flag is NULL