APPS.OKS_RENEW_CONTRACT_PVT dependencies on HZ_PARTIES

Line 1108: FROM hr_locations hrl, hr_all_organization_units hr, hz_parties hz

1104: l_gen_return_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
1105:
1106: CURSOR c_vendor_details(cp_org_id IN NUMBER, cp_party_id IN NUMBER) IS
1107: SELECT hz.party_name, hrl.country, hrl.region_2
1108: FROM hr_locations hrl, hr_all_organization_units hr, hz_parties hz
1109: WHERE hrl.location_id = hr.location_id
1110: AND hr.organization_id = cp_org_id
1111: AND hz.party_id = cp_party_id;
1112:

Line 1115: FROM hz_parties hz, hz_party_sites hzs , hz_locations hzl

1111: AND hz.party_id = cp_party_id;
1112:
1113: CURSOR c_customer_details(cp_party_id IN NUMBER) IS
1114: SELECT hz.party_name, hzl.country, hzl.state
1115: FROM hz_parties hz, hz_party_sites hzs , hz_locations hzl
1116: WHERE hz.party_id = cp_party_id
1117: AND hzs.party_id = hz.party_id
1118: AND hzs.identifying_address_flag = 'Y'
1119: AND hzl.location_id = hzs.location_id;

Line 4578: FROM HZ_PARTIES P

4574: AND LCN.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
4575: UNION ALL
4576: SELECT 'OKX_PARTY' TYPE, P.PARTY_ID ID1, '#' ID2, P.PARTY_NAME NAME,
4577: P.PARTY_NUMBER DESCRIPTION, NULL INV_ORG_ID
4578: FROM HZ_PARTIES P
4579: WHERE P.PARTY_TYPE IN ( 'PERSON','ORGANIZATION')
4580: UNION ALL
4581: SELECT 'OKX_CUSTPROD' TYPE, CII.INSTANCE_ID ID1, '#' ID2, SIT.DESCRIPTION NAME,
4582: BK.CONCATENATED_SEGMENTS DESCRIPTION, BK.ORGANIZATION_ID INV_ORG_ID

Line 4586: AND CIP.PARTY_SOURCE_TABLE = 'HZ_PARTIES' AND

4582: BK.CONCATENATED_SEGMENTS DESCRIPTION, BK.ORGANIZATION_ID INV_ORG_ID
4583: FROM CSI_ITEM_INSTANCES CII, CSI_I_PARTIES CIP,
4584: MTL_SYSTEM_ITEMS_B_KFV BK, MTL_SYSTEM_ITEMS_TL SIT
4585: WHERE CII.INSTANCE_ID = CIP.INSTANCE_ID AND CIP.RELATIONSHIP_TYPE_CODE = 'OWNER'
4586: AND CIP.PARTY_SOURCE_TABLE = 'HZ_PARTIES' AND
4587: NOT EXISTS ( SELECT 1 FROM CSI_INSTALL_PARAMETERS CIPM
4588: WHERE CIPM.INTERNAL_PARTY_ID = CIP.PARTY_ID )
4589: AND BK.INVENTORY_ITEM_ID = CII.INVENTORY_ITEM_ID
4590: AND SIT.INVENTORY_ITEM_ID = BK.INVENTORY_ITEM_ID

Line 4597: FROM HZ_CUST_ACCOUNTS CA,HZ_PARTIES P

4593: UNION ALL
4594: SELECT 'OKX_CUSTACCT' TYPE, CA.CUST_ACCOUNT_ID ID1, '#' ID2,
4595: decode(CA.ACCOUNT_NAME, null, P.PARTY_NAME, CA.Account_NAME) NAME,
4596: CA.ACCOUNT_NUMBER DESCRIPTION, NULL INV_ORG_ID
4597: FROM HZ_CUST_ACCOUNTS CA,HZ_PARTIES P
4598: WHERE CA.PARTY_ID = P.PARTY_ID
4599: UNION ALL
4600: SELECT 'OKX_COUNTER' TYPE, CCT.COUNTER_ID ID1, '#' ID2, CCT.NAME NAME,
4601: CCT.DESCRIPTION DESCRIPTION, NULL INV_ORG_ID