POZ_SUPPLIER_MAPPINGS

This table stores references to supplier requests and/or their corresponding supplier parties in TCA. Other supplier profile request tables can utilize the references to find out their associated supplier party or supplier registration.

Details

• Schema: FUSION

• Object owner: POZ

• Object type: TABLE

• Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
POZ_SUPPLIER_MAPPINGS_PK	MAPPING_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
MAPPING_ID	NUMBER		18	Yes	Mapping identifier
PARTY_ID	NUMBER		18		Party identifier of the supplier party
VENDOR_ID	NUMBER		18		Supplier identifer
SUPPLIER_REG_ID	NUMBER		18		Registration identifier of the supplier registration or request
PON_RESPONSE_ID	NUMBER		18		Identifier for Sourcing response. This field will be populated only if the record pertains to Sourcing.
PON_RESPONSE_HDR_ID	NUMBER		18		Identifier for Sourcing response header. This field will be populated only if the record pertains to Sourcing.
POQ_QUESTNAIRE_RESPONSE_ID	NUMBER		18		Identifier for POQ Questionnaire response. This field will be populated only if the record pertains to a POQ response record.
POQ_QUESTNAIRE_RESPONSE_HDR_ID	NUMBER		18		Identifier for POQ Questionnaire response header. This field will be populated only if the record pertains to a POQ response record.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
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.

Foreign Keys

Table	Foreign Table	Foreign Key Column
POZ_SUPPLIER_MAPPINGS	hz_parties	PARTY_ID
POZ_SUPPLIER_MAPPINGS	poz_suppliers	VENDOR_ID
POZ_SUPPLIER_MAPPINGS	poz_supplier_registrations	SUPPLIER_REG_ID
POZ_SUPPLIER_MAPPINGS	poq_questnaire_responses	POQ_QUESTNAIRE_RESPONSE_ID
POZ_SUPPLIER_MAPPINGS	pon_bid_requirements	PON_RESPONSE_HDR_ID, PON_RESPONSE_ID
poz_contact_requests	poz_supplier_mappings	MAPPING_ID
poz_acnt_gen_reqs	poz_supplier_mappings	MAPPING_ID
poz_product_service_requests	poz_supplier_mappings	MAPPING_ID
poz_cont_addr_requests	poz_supplier_mappings	MAPPING_ID
poz_address_requests	poz_supplier_mappings	MAPPING_ID
poz_acnt_addr_reqs	poz_supplier_mappings	MAPPING_ID
poz_bus_class_reqs	poz_supplier_mappings	MAPPING_ID

Indexes

Index	Uniqueness	Tablespace	Columns
POZ_SUPPLIER_MAPPINGS_N1	Non Unique	Default	PARTY_ID
POZ_SUPPLIER_MAPPINGS_N2	Non Unique	Default	VENDOR_ID
POZ_SUPPLIER_MAPPINGS_N3	Non Unique	Default	POQ_QUESTNAIRE_RESPONSE_HDR_ID
POZ_SUPPLIER_MAPPINGS_U1	Unique	Default	MAPPING_ID
POZ_SUPPLIER_MAPPINGS_U2	Unique	Default	SUPPLIER_REG_ID
POZ_SUPPLIER_MAPPINGS_U3	Unique	Default	POQ_QUESTNAIRE_RESPONSE_ID
POZ_SUPPLIER_MAPPINGS_U4	Unique	Default	PON_RESPONSE_HDR_ID, PON_RESPONSE_ID