POZ_SUPP_REQUESTS
This staging table stores the information about supplier requests. This acts as the header table for storing the Supplier Change Request details.
Details
-
Schema: FUSION
-
Object owner: POZ
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
POZ_SUPP_REQUESTS_PK |
SUPP_REQUEST_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SUPP_REQUEST_ID | NUMBER | 18 | Yes | This field is the unique identifier for a supplier request. | |
| ACTION_BY_PARTY_ID | NUMBER | 18 | This field stores the party id of the supplier user who took the action (cancel, withdraw, etc) on the request. | ||
| ACTION_BY_PERSON_ID | NUMBER | 18 | This field stores the id of the person who took the action (approve, reject, cancel). | ||
| ACTION_DATE | TIMESTAMP | This field stores the date when the action (approve, reject, cancel) was taken. | |||
| ACTION_REASON | VARCHAR2 | 2000 | This field stores the reason why the action was taken. | ||
| APPROVAL_INSTANCE_ID | NUMBER | 18 | Used to track BPEL instance id for supplier profile change request process | ||
| REQUEST_SOURCE_CODE | VARCHAR2 | 30 | Yes | This field stores the source from which the request is made.Valid values are from lookup type ORA_POZ_SUP_PROF_CR_SOURCE | |
| REQUEST_STATUS_CODE | VARCHAR2 | 30 | Yes | This field stores the status of the request.Valid values are from lookup type ORA_POZ_PROFILE_CR_STATUS | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CHANGE_REQ_NUMBER | NUMBER | 18 | This field uniquely identifies the number of change request is populated by POZ_SUPP_REQUESTS_S sequence | ||
| VENDOR_ID | NUMBER | 18 | Yes | Stores the vendor id for which the change request is created. | |
| SOURCE_DOCUMENT_NUMBER | NUMBER | 18 | The field stores the source document number from which the change request is made. This could either be Questionaire Response Number or Negotiation Response Number which is identified by the REQUEST_SOURCE_CODE field. | ||
| SOURCING_BATCH_ID | NUMBER | 18 | Sourcing Batch Id of the document. This field is applicable only when change requests come from a Negotiation response. | ||
| REQUEST_BY_PERSON_ID | NUMBER | 18 | This field is used to store the requested user's person id which helps to identify who raised the request. | ||
| REQUEST_BY_PARTY_ID | NUMBER | 18 | This field is used to store the requested user's person id which helps to identify who raised the request. | ||
| CHANGED_ORG_DETAILS_FLAG | VARCHAR2 | 1 | Indicates if data related to Supplier Organization details got modified as part of the change request | ||
| CHANGED_SITES_FLAG | VARCHAR2 | 1 | Indicates if data related to sites got modified as part of the change request | ||
| CHANGED_BUS_CLASS_DETAILS_FLAG | VARCHAR2 | 1 | Indicates if data related to Supplier Business Classifications got modified as part of the change request | ||
| CHANGED_TAX_DETAILS_FLAG | VARCHAR2 | 1 | Indicates if data related to Supplier Tax Identifiers details got modified as part of the change request | ||
| CHANGED_PAYMENT_METHOD_FLAG | VARCHAR2 | 1 | Indicates if data related to Supplier Site Payment Method details got modified as part of the change request | ||
| CHANGED_CONTACTS_FLAG | VARCHAR2 | 1 | Indicates if data related to the Supplier Contacts got modified as part of the change request. | ||
| CHANGED_USER_ACCOUNT_FLAG | VARCHAR2 | 1 | Indicates if data related to the Supplier Contact User Account got modified as part of the change request. | ||
| CHANGE_REQ_SUBMISSION_DATE | TIMESTAMP | Indicates the date and time of the submission of the change request. | |||
| CHANGED_ADDRESSES_FLAG | VARCHAR2 | 1 | Indicates if data related to addresses got modified as part of the change request | ||
| CHANGED_PROD_SERV_FLAG | VARCHAR2 | 1 | Indicates if data related to Products and Services Categories got modified as part of the change request | ||
| CHANGED_BANK_ACCOUNTS_FLAG | VARCHAR2 | 1 | Indicates if data related to Bank Accounts got modified as part of the change request | ||
| CHANGE_DESCRIPTION | VARCHAR2 | 2000 | This field stores change descritpion entered by the profile change request requester | ||
| BC_NOT_APPLICABLE_OLD_FLAG | VARCHAR2 | 1 | Business Classifications not applicable flag old value | ||
| BC_NOT_APPLICABLE_NEW_FLAG | VARCHAR2 | 1 | Business Classifications not applicable flag new value | ||
| RESUBMISSION_NUM | NUMBER | 9 | This column stores a resubmssion number indicating how many times this change request is resubmitted. | ||
| PII_DATA_COPIED_FLAG | VARCHAR2 | 1 | Indicates if PII data got copied to staging table from production table. | ||
| DF_LINKED_ADDRESS_REQ_ID | NUMBER | 18 | Address identifier of Supplier address created via Datafox linking |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| POZ_SUPP_REQUESTS | poz_suppliers | VENDOR_ID |
| POZ_SUPP_REQUESTS | per_persons | REQUEST_BY_PERSON_ID |
| POZ_SUPP_REQUESTS | hz_parties | REQUEST_BY_PARTY_ID |
| poz_supp_requests_pii | poz_supp_requests | SUPP_REQUEST_ID |
| poz_supp_acct_owner_requests | poz_supp_requests | SUPP_REQUEST_ID |
| poz_supp_bus_class_requests | poz_supp_requests | SUPP_REQUEST_ID |
| poz_supp_cont_addr_requests | poz_supp_requests | SUPP_REQUEST_ID |
| poz_supp_interm_acct_requests | poz_supp_requests | SUPP_REQUEST_ID |
| poz_supp_temp_bank_requests | poz_supp_requests | SUPP_REQUEST_ID |
| poz_supp_bank_acct_requests | poz_supp_requests | SUPP_REQUEST_ID |
| poz_supp_prod_serv_requests | poz_supp_requests | SUPP_REQUEST_ID |
| poz_supp_site_requests | poz_supp_requests | SUPP_REQUEST_ID |
| poz_supp_pmt_method_requests | poz_supp_requests | SUPP_REQUEST_ID |
| poz_supp_tpp_rel_requests | poz_supp_requests | SUPP_REQUEST_ID |
| poz_supp_contact_requests | poz_supp_requests | SUPP_REQUEST_ID |
| poz_supp_org_details_requests | poz_supp_requests | SUPP_REQUEST_ID |
| poz_supp_tax_details_requests | poz_supp_requests | SUPP_REQUEST_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| POZ_SUPP_REQUESTS_N1 | Non Unique | Default | CREATION_DATE |
| POZ_SUPP_REQUESTS_N2 | Non Unique | Default | VENDOR_ID, REQUEST_STATUS_CODE |
| POZ_SUPP_REQUESTS_N3 | Non Unique | Default | REQUEST_BY_PERSON_ID |
| POZ_SUPP_REQUESTS_N4 | Non Unique | Default | REQUEST_BY_PARTY_ID |
| POZ_SUPP_REQUESTS_N5 | Non Unique | Default | CHANGE_REQ_NUMBER |
| POZ_SUPP_REQUESTS_PK1 | Unique | Default | SUPP_REQUEST_ID |