[Home] [Help] [Dependency Information]
Object Name: | POS_SURVEY_CONFIG |
---|---|
Object Type: | TABLE |
Owner: | POS |
Subobject Name: | |
Status: | VALID |
This table stores the configuration of supplier surveys. It specify the list of surveys for global or individual operating units.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONFIG_ID | NUMBER | Yes | Configuration Identifier. Generated from sequence POS_SURVEY_CONFIG_S. | |
ORG_ID | NUMBER | Yes | For global survey -999. For operating unit specific survey it is org identifier. | |
SURVEY_DEPLOYMENT_ID | NUMBER | Yes | Survey Deployment Identifier. | |
SUPPLIER_UPDATE_FLAG | VARCHAR2 | (1) | Yes | Supplier Update Flag. Must be Y/N. |
INTERNAL_UPDATE_FLAG | VARCHAR2 | (1) | Yes | Internal Update Flag. Must be Y/N. |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT CONFIG_ID
, ORG_ID
, SURVEY_DEPLOYMENT_ID
, SUPPLIER_UPDATE_FLAG
, INTERNAL_UPDATE_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM POS.POS_SURVEY_CONFIG;
POS.POS_SURVEY_CONFIG does not reference any database object
POS.POS_SURVEY_CONFIG is referenced by following:
|
|
|