DBA Data[Home] [Help] [Dependency Information]

TABLE: POS.POS_SURVEY_TRANSACTIONS

Object Details
Object Name: POS_SURVEY_TRANSACTIONS
Object Type: TABLE
Owner: POS
Subobject Name:
Status: VALID


The tables stores the survey transactions for suppliers. The actual survey transaction data is stored in iScripting table. This table contains the foreign key reference to the transactions.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER
Yes Configuration Identifier, generated from sequence POS_SURVEY_CONFIG_S
SUPPLIER_MAPPING_ID NUMBER
Yes Supplier Mapping Identifier
SURVEY_TRANSACTION_ID NUMBER
Yes Survey Transaction Identifier
CREATED_BY NUMBER
Yes Standard Who Columns
CREATION_DATE DATE
Yes Standard Who Columns
LAST_UPDATED_BY NUMBER
Yes Standard Who Columns
LAST_UPDATE_DATE DATE
Yes Standard Who Columns
LAST_UPDATE_LOGIN NUMBER

Standard Who Columns
RESPONDENT_TABLE_NAME VARCHAR2 (30) Yes Name of the table in which the respondent_id represents the respondent
RESPONDENT_ID NUMBER
Yes Identifier of the respondent who took the survey transaction
SUPPLIER_UPDATE_FLAG VARCHAR2 (1)
If the survey transaction was taken by the supplier, the column in set to Y. This allows the supplier to come back to view/update the survey answers.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TRANSACTION_ID
,      SUPPLIER_MAPPING_ID
,      SURVEY_TRANSACTION_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      RESPONDENT_TABLE_NAME
,      RESPONDENT_ID
,      SUPPLIER_UPDATE_FLAG
FROM POS.POS_SURVEY_TRANSACTIONS;

Dependencies

[top of page]

POS.POS_SURVEY_TRANSACTIONS does not reference any database object

POS.POS_SURVEY_TRANSACTIONS is referenced by following:

SchemaAPPS
SynonymPOS_SURVEY_TRANSACTIONS