Constraints, indexes, Table Structure

HZ_PARTY_SITES: Table Structure, Index, Constraints

HZ_PARTY_SITES: table used to store the site information in Oracle TCA ( trading community architecture) structure. Below is the table structure, index and constraints of the table.

By the way, Here ( India) or Here ( Other Geographies) are few UNCONVENTIONAL tricks which I have learnt to improve the performance of BI reports or SQL queries. Try them only when nothing else works.. kind of SOS...
https://www.amazon.in/gp/product/B093CC1CLD?ie=UTF8&tag=oraclebytes-21&camp=3638&linkCode=xm2&creativeASIN=B093CC1CLD

HZ_PARTY_SITES Table Structure

COLUMN_NAMEDATA_TYPENULLABLE
 PARTY_SITE_IDNUMBER
 PARTY_IDNUMBER
 LOCATION_IDNUMBER
 LAST_UPDATE_DATETIMESTAMP(6)
 LAST_UPDATED_BYVARCHAR2(256)
 CREATION_DATETIMESTAMP(6)
 CREATED_BYVARCHAR2(256)
 LAST_UPDATE_LOGINVARCHAR2(128)
 REQUEST_IDNUMBER
 JOB_DEFINITION_NAMEVARCHAR2(400)
 JOB_DEFINITION_PACKAGEVARCHAR2(3600)
 ATTRIBUTE_CATEGORYVARCHAR2(120)
 CURRENCY_CODEVARCHAR2(60)
 CORP_CURRENCY_CODEVARCHAR2(60)
 CURCY_CONV_RATE_TYPEVARCHAR2(120)
 ATTRIBUTE1-30VARCHAR2(600)
 ORIG_SYSTEM_REFERENCEVARCHAR2(960)
 START_DATE_ACTIVEDATE
 END_DATE_ACTIVEDATE
 PARTY_SITE_NUMBERVARCHAR2(120)
 MAILSTOPVARCHAR2(240)
 IDENTIFYING_ADDRESS_FLAGVARCHAR2(4)
 STATUSVARCHAR2(4)
 PARTY_SITE_NAMEVARCHAR2(960)
 ADDRESSEEVARCHAR2(1440)
 OBJECT_VERSION_NUMBERNUMBER
 CREATED_BY_MODULEVARCHAR2(120)
 ACTUAL_CONTENT_SOURCEVARCHAR2(120)
 GLOBAL_LOCATION_NUMBERVARCHAR2(160)
 DUNS_NUMBER_CVARCHAR2(120)
 PARTY_NAME_LEGALVARCHAR2(1440)
 PARTY_NAME_DBAVARCHAR2(1440)
 PARTY_NAME_DIVISIONVARCHAR2(1440)
 RELATIONSHIP_IDNUMBER
 PARTY_USAGE_CODEVARCHAR2(120)
 PARTY_SITE_TYPEVARCHAR2(120)
 COMMENTSVARCHAR2(4000)
 CONFLICT_IDNUMBER
 USER_LAST_UPDATE_DATETIMESTAMP(6)
 CPDRF_VER_SORNUMBER
 CPDRF_VER_PILLARNUMBER
 CPDRF_LAST_UPDVARCHAR2(60)
 ATTRIBUTE_NUMBER1-ATTRIBUTE_NUMBER12NUMBER
 ATTRIBUTE_DATE1- ATTRIBUTE_DATE12DATE
 PARTY_SITE_LANGUAGEVARCHAR2(16)
 OVERALL_PRIMARY_FLAGVARCHAR2(4)
 PERSONAL_ADDRESS_FLAGVARCHAR2(4)
 EXTN_ATTRIBUTE_TIMESTAMP001 –  EXTN_ATTRIBUTE_TIMESTAMP050TIMESTAMP(6)
 EXTN_ATTRIBUTE_NUMBER001 –  EXTN_ATTRIBUTE_NUMBER200NUMBER
 EXTN_ATTRIBUTE_CHAR001 – EXTN_ATTRIBUTE_CHAR350VARCHAR2(4000)
HZ_PARTY_SITES Table Structure

Index :

index type N stands for Normal, F for Function Based

INDEX_NAMEINDEX_TYPEUNIQUENESSCOLUMN_NAME
 HZ_PARTY_SITES_N1NNORIG_SYSTEM_REFERENCE
 HZ_PARTY_SITES_N2NNPARTY_ID
 HZ_PARTY_SITES_N2NNIDENTIFYING_ADDRESS_FLAG
 HZ_PARTY_SITES_N2NNSTART_DATE_ACTIVE
 HZ_PARTY_SITES_N2NNOVERALL_PRIMARY_FLAG
 HZ_PARTY_SITES_N3NNGLOBAL_LOCATION_NUMBER
 HZ_PARTY_SITES_N4FNSYS_NC00724$
 HZ_PARTY_SITES_N4FNPARTY_SITE_ID
 HZ_PARTY_SITES_N5NNLOCATION_ID
 HZ_PARTY_SITES_N6NNRELATIONSHIP_ID
 HZ_PARTY_SITES_N6NNPARTY_ID
 HZ_PARTY_SITES_N6NNLOCATION_ID
 HZ_PARTY_SITES_N6NNSTART_DATE_ACTIVE
 HZ_PARTY_SITES_N6NNIDENTIFYING_ADDRESS_FLAG
 HZ_PARTY_SITES_N6NNOVERALL_PRIMARY_FLAG
 HZ_PARTY_SITES_N7FNSYS_NC00725$
 HZ_PARTY_SITES_N8NNREQUEST_ID
 HZ_PARTY_SITES_PKNYPARTY_SITE_ID
 HZ_PARTY_SITES_U1NYPARTY_SITE_NUMBER
 HZ_PARTY_SITES_U1NYCONFLICT_ID
 HZ_PARTY_SITES_X01NNEXTN_ATTRIBUTE_NUMBER001
 HZ_PARTY_SITES_X02NNEXTN_ATTRIBUTE_NUMBER002
 HZ_PARTY_SITES_X03NNEXTN_ATTRIBUTE_NUMBER003
 HZ_PARTY_SITES_X04NNEXTN_ATTRIBUTE_CHAR001
 HZ_PARTY_SITES_X05NNEXTN_ATTRIBUTE_CHAR002
 HZ_PARTY_SITES_X06NNEXTN_ATTRIBUTE_NUMBER015
 HZ_PARTY_SITES_X07NNEXTN_ATTRIBUTE_NUMBER016
 HZ_PARTY_SITES_X08NNEXTN_ATTRIBUTE_CHAR026
 HZ_PARTY_SITES_X09NNEXTN_ATTRIBUTE_CHAR027
 HZ_PARTY_SITES_X10NNEXTN_ATTRIBUTE_CHAR028
 HZ_PARTY_SITES_X11NNEXTN_ATTRIBUTE_NUMBER023
 HZ_PARTY_SITES_X12NNEXTN_ATTRIBUTE_NUMBER024
 HZ_PARTY_SITES_X13NNEXTN_ATTRIBUTE_CHAR040
 HZ_PARTY_SITES_X14NNEXTN_ATTRIBUTE_CHAR041
 HZ_PARTY_SITES_X15NNEXTN_ATTRIBUTE_CHAR042
 HZ_PARTY_SITES_X16NNEXTN_ATTRIBUTE_NUMBER030
 HZ_PARTY_SITES_X17NNEXTN_ATTRIBUTE_NUMBER031
 HZ_PARTY_SITES_X18NNEXTN_ATTRIBUTE_NUMBER032
 HZ_PARTY_SITES_X19NNEXTN_ATTRIBUTE_CHAR043
 HZ_PARTY_SITES_X20NNEXTN_ATTRIBUTE_CHAR044

Constraints

CONSTRAINT NAMECONSTRAINT TYPESEARCH_CONDITION_VC
 SYS_C00125510C“CREATED_BY” IS NOT NULL 
 SYS_C00125513C“STATUS” IS NOT NULL 
 SYS_C00125515C“CONFLICT_ID” IS NOT NULL 
 SYS_C00125504C“PARTY_SITE_ID” IS NOT NULL 
 SYS_C00125511C“PARTY_SITE_NUMBER” IS NOT NULL 
 SYS_C00125509C“CREATION_DATE” IS NOT NULL 
 SYS_C00125512C“IDENTIFYING_ADDRESS_FLAG” IS NOT NULL 
 HZ_PARTY_SITES_PKP 
 SYS_C00125506C“LOCATION_ID” IS NOT NULL 
 SYS_C00125514C“OBJECT_VERSION_NUMBER” IS NOT NULL 
 SYS_C00125507C“LAST_UPDATE_DATE” IS NOT NULL 
 SYS_C00125508C“LAST_UPDATED_BY” IS NOT NULL 
 SYS_C00125505C“PARTY_ID” IS NOT NULL 

Related Posts

Supplier Details Query in Oracle Fusion – POZ_SUPPLIERS
Vendor Site – Invoicing & Payments Query
Query to get the Vendor Fiscal Classification

Feedback:
Hope the article helped you. If it did, please rate the post. In case it didn’t, do leave a comment to let us know what did we miss.

Reference:
support.oracle.com

Check out the Amazon Deals of the day based on your interests..

How useful was this post?

Click on a star to rate it!

Average rating 5 / 5. Vote count: 1

No votes so far! Be the first to rate this post.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?