[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CZ_IMP_PS_NODES |
|---|---|
| Object Type: | TABLE |
| Owner: | CZ |
| FND Design Data: |  CZ.CZ_IMP_PS_NODES
|
| Subobject Name: | |
| Status: | VALID |
CZ_IMP_PS_NODES contains data that will be imported (or rejected) into CZ_PS_NODES table by the import process.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| CZ_BMX_IMPPSNODE_PLANLEVEL_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
 PLAN_LEVEL
|
| CZ_IMP_PS_NODES_N0 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
RUN_ID
REC_STATUS
|
| CZ_IMP_PS_NODES_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
PS_NODE_ID
RUN_ID
DISPOSITION
|
| CZ_IMP_PS_NODES_N3 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
FSK_INTLTEXT_1_1
|
| CZ_IMP_PS_NODES_N4 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
FSK_ITEMMASTER_2_1
|
| CZ_IMP_PS_NODES_N5 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
FSK_PSNODE_3_1
|
| CZ_IMP_PS_NODES_N6 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
FSK_DEVLPROJECT_5_1
|
| CZ_IMP_PS_NODES_N7 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
RUN_ID
ORIG_SYS_REF
DEVL_PROJECT_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PS_NODE_ID | NUMBER | (15) | Node Identifier (primary key) | |
| DEVL_PROJECT_ID | NUMBER | (15) | Development project identifier (psnode ID of root psnode) | |
| FROM_POPULATOR_ID | NUMBER | (9) | Identifier of the populator that created this node | |
| PROPERTY_BACKPTR | NUMBER | (9) | Identifier of property if property was used to populate this node | |
| ITEM_TYPE_BACKPTR | NUMBER | (9) | Item type identifier if item type was used to populate this node | |
| INTL_TEXT_ID | NUMBER | (15) | Identifier of the translatable node description | |
| SUB_CONS_ID | NUMBER | (9) | UNUSED | |
| ORGANIZATION_ID | NUMBER | (9) | Organization identifier on imported nodes | |
| ITEM_ID | NUMBER | (9) | CONFIGURATOR Item identifier (not INV) | |
| EXPLOSION_TYPE | VARCHAR2 | (20) | Bill explosion type; all, included, optional - on nodes imported from BOM | |
| NAME | VARCHAR2 | (1000) | Node name | |
| ORIG_SYS_REF | VARCHAR2 | (1200) | Unique identification of a record in this table. Used for the imported projects only. | |
| RESOURCE_FLAG | VARCHAR2 | (1) | Flag indicating if node is a resource node type | |
| TOP_ITEM_ID | NUMBER | (9) | Item identifier of the bill top item from BOM | |
| INITIAL_VALUE | VARCHAR2 | (255) | Node initial value | |
| PARENT_ID | NUMBER | (15) | Node identifier of the parent node | |
| MINIMUM | NUMBER | Minimum value. Used for Integer, Decimal, and BOM Node feature type nodes | ||
| MAXIMUM | NUMBER | Maximum value. Used for Integer, Decimal, and BOM Node feature type nodes | ||
| PS_NODE_TYPE | NUMBER | (9) | Product node type: ROOT = 256; FOLDER =257; PRODUCT = 258; COMPONENT = 259; FEATURE_GROUP = 260; FEATURE = 261; OPTION = 262; TOTAL = 270; RESOURCE = 271;; BOM_MODEL = 436; BOM_OPTION_CLASS = 437; BOM_STD_ITEM = 438 | |
| FEATURE_TYPE | NUMBER | (9) | Feature type: 0-option;1-integer;2-decimal;3-boolean;4-text | |
| PRODUCT_FLAG | VARCHAR2 | (1) | Flag indicating if node is a product type node | |
| REFERENCE_ID | NUMBER | (15) | UNUSED | |
| MULTI_CONFIG_FLAG | VARCHAR2 | (1) | UNUSED | |
| ORDER_SEQ_FLAG | VARCHAR2 | (1) | UNUSED | |
| SYSTEM_NODE_FLAG | VARCHAR2 | (1) | Reserved | |
| TREE_SEQ | NUMBER | (9) | Order of this node among other nodes with the same PARENT_ID | |
| COUNTED_OPTIONS_FLAG | VARCHAR2 | (1) | Flag indicating if option can be counted vs. selected | |
| UI_OMIT | VARCHAR2 | (1) | Flag indicating whether or not this node should appear as a selection in your Oracle Configurator application | |
| UI_SECTION | NUMBER | (9) | UNUSED | |
| BOM_TREATMENT | NUMBER | (9) | Field indicating how imported node will be displayed: skip=1; Leaf=2;Flatten=3 | |
| RUN_ID | NUMBER | Contains a number indicating the Import run in which this record was loaded/processed | ||
| REC_STATUS | VARCHAR2 | (4) | Records a coded status describing the import results for this record; if null, it indicates the record has not yet it indicates the record has not yet been completely processed | |
| DISPOSITION | VARCHAR2 | (1) | Indicates whether the record was inserted, updated, unchanged, or rejected | |
| DELETED_FLAG | VARCHAR2 | (1) | Yes | Indicates ('1'/'0') that this record has been deleted |
| EFF_FROM | DATE | UNUSED | ||
| EFF_TO | DATE | UNUSED | ||
| EFF_MASK | VARCHAR2 | (40) | UNUSED | |
| USER_STR01 | VARCHAR2 | (255) | Textual user expansion field | |
| USER_STR02 | VARCHAR2 | (255) | Textual user expansion field | |
| USER_STR03 | VARCHAR2 | (255) | Textual user expansion field | |
| USER_STR04 | VARCHAR2 | (255) | Textual user expansion field | |
| USER_NUM01 | NUMBER | (16) | Numeric user expansion field | |
| USER_NUM02 | NUMBER | (16) | Numeric user expansion field | |
| USER_NUM03 | NUMBER | (16) | Numeric user expansion field | |
| USER_NUM04 | NUMBER | (16) | Numeric user expansion field | |
| CHECKOUT_USER | VARCHAR2 | (40) | UNUSED | |
| CREATION_DATE | DATE | Standard Who column | ||
| LAST_UPDATE_DATE | DATE | Standard Who column | ||
| CREATED_BY | NUMBER | (15) | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
| SECURITY_MASK | VARCHAR2 | (40) | UNUSED | |
| FSK_INTLTEXT_1_1 | VARCHAR2 | (255) | Contains a foreign surrogate-key value matching CZ_ IMP_INTL_TEXT on TEXT_STR | |
| FSK_INTLTEXT_1_EXT | VARCHAR2 | (255) | Contains a foreign surrogate-key value matching CZ_ IMP_INTL_TEXT on USER_STR03 | |
| FSK_ITEMMASTER_2_1 | VARCHAR2 | (255) | Contains a foreign surrogate-key value matching CZ_ IMP_ITEM_MASTER on ORIG_SYS_REF | |
| FSK_ITEMMASTER_2_EXT | VARCHAR2 | (255) | Contains a foreign surrogate-key value matching CZ_IMP_ITEM_MASTER on ORIG_SYS_REF | |
| FSK_PSNODE_3_1 | VARCHAR2 | (255) | Contains a foreign surrogate-key value matching CZ_IMP_PS_NODE on ORIG_SYS_REF | |
| FSK_PSNODE_3_EXT | VARCHAR2 | (255) | Contains a foreign surrogate-key value matching CZ_ IMP_PS_NODE on USER_STR03 | |
| FSK_PSNODE_4_1 | VARCHAR2 | (255) | contains a foreign surrogate-key value matching CZ_PS_NODES on parent_id | |
| FSK_PSNODE_4_EXT | VARCHAR2 | (255) | Currently not used | |
| FSK_DEVLPROJECT_5_1 | VARCHAR2 | (255) | Contains a foreign surrogate-key value matching CZ_ IMP_DEVL_PROJECT on ORIG_SYS_REF | |
| FSK_DEVLPROJECT_5_EXT | VARCHAR2 | (255) | Contains a foreign surrogate-key value matching CZ_IMP_DEVL_PROJECT on USER_STR03 | |
| COMPONENT_SEQUENCE_ID | NUMBER | A number identifying the sequence of this component in the component set. | ||
| COMPONENT_CODE | VARCHAR2 | (1200) | Component code | |
| PLAN_LEVEL | NUMBER | Plan level | ||
| BOM_ITEM_TYPE | NUMBER | BOM item type: 1 - model; 2 - option class; 4 - standard item. | ||
| SO_ITEM_TYPE_CODE | VARCHAR2 | (30) | Item type code used in Order Entry: Model, Class, Kit, Standard | |
| MINIMUM_SELECTED | NUMBER | (9) | Minimum number of options to be selected for the feature type node | |
| MAXIMUM_SELECTED | NUMBER | (9) | Maximum number of options to be selected for the feature type node | |
| BOM_REQUIRED | VARCHAR2 | (1) | Flag indicating if the node is optional or required in BOM _EXPLOSIONS table. Used for imported models only | |
| MUTUALLY_EXCLUSIVE_OPTIONS | NUMBER | Flag indicating if the options are mutually exclusive | ||
| OPTIONAL | NUMBER | Flag indicating if the option is optional or required | ||
| FSK_EXPLNODE_1_1 | VARCHAR2 | (255) | Contains a foreign surrogate-key value for CZ_MODEL_REF_EXPLS for additional info resolving the Reference ID | |
| FSK_PSNODE_6_1 | VARCHAR2 | (255) | contains a foreign surrogate-key value matching CZ_PS_NODES on reference_id | |
| EFFECTIVE_FROM | DATE | Date beginning on which this data is effective | ||
| EFFECTIVE_UNTIL | DATE | Date at which this data is no longer effective. Note this is EXCLUSIVE. | ||
| EFFECTIVE_USAGE_MASK | VARCHAR2 | (16) | Hexadecimal-encoded bit map identifying Usages for which this record is INEFFECTIVE | |
| EFFECTIVITY_SET_ID | NUMBER | Identifies the named effectivity set associated with this record | ||
| FSK_EFFSET_7_1 | VARCHAR2 | (256) | Contains a foreign surrogate-key value matching CZ_EFFECTIVITY_SETS on effectivity_set_id | |
| DECIMAL_QTY_FLAG | VARCHAR2 | (1) | '1' indicates the item described by this record is measured in fractional quantities; '0' indicates quantities must be whole/units | |
| QUOTEABLE_FLAG | VARCHAR2 | (1) | Indicates this item can be separately quoted. | |
| PRIMARY_UOM_CODE | VARCHAR2 | (3) | Indicates the primary unit of measure for this item. | |
| COMPONENT_SEQUENCE_PATH | VARCHAR2 | (2000) | For nodes imported from Oracle BOM, records the component_sequence_path of the source BOM entry | |
| BOM_SORT_ORDER | VARCHAR2 | (4000) | Holds the 'sort order' value for nodes imported from Oracle Bills of Material (denormalization) | |
| IB_TRACKABLE | VARCHAR2 | (1) | Flag indicating whether this item is trackable through Installed Base; imported from MTL_SYSTEM_ITEMS | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| INITIAL_NUM_VALUE | NUMBER | or import of numeric initial values | ||
| SRC_APPLICATION_ID | NUMBER | Records the application that initially created the data in this node, whether Configurator 'native' or imported | ||
| FSK_ITEMMASTER_2_2 | NUMBER | SRC_APPLICATION_ID should be supplied in FSK_ITEMMASTER_2_2 for resolution of the ps_nodes item_id. | ||
| INSTANTIABLE_FLAG | VARCHAR2 | (1) | INSTANTIABLE_FLAG records the user's intended instantiation behavior for Component and Reference structure nodes. '1' indicates an Optional node (minimum 0 instances, maximum 1 instance); '2' indicates a Mandatory or Single instance (1, 1) node; '4' indicates a Multiply-Instantiable node, allowing a maximum of two or more instances. Also, the value '3' is used for Connectors. | |
| DISPLAY_IN_SUMMARY_FLAG | VARCHAR2 | (1) | '1' indicates this node should be displayed in summary regions and pages | |
| IB_LINK_ITEM_FLAG | VARCHAR2 | (1) | Transfers the value to the corresponding CZ_PS_NODES column. | |
| SHIPPABLE_ITEM_FLAG | VARCHAR2 | (1) | Populated for BOM nodes from BOM_EXPLOSIONS.shippable_item_flag | |
| INVENTORY_TRANSACTABLE_FLAG | VARCHAR2 | (1) | Populated for BOM nodes from MTL_SYSTEM_ITEMS.mtl_transactions_enabled_flag | |
| ASSEMBLE_TO_ORDER_FLAG | VARCHAR2 | (1) | Populated for BOM nodes from BOM_EXPLOSIONS.replenish_to_order_flag | |
| SERIALIZABLE_ITEM_FLAG | VARCHAR2 | (1) | Populated for BOM nodes from MTL_SYSTEM_ITEMS.serial_number_control_code'1' if serial_number_control_code <> 1, '0' otherwise | |
| MAX_QTY_PER_OPTION | NUMBER | |||
| DOMAIN_ORDER | NUMBER | |||
| USER_INPUT_REQUIRED_FLAG | VARCHAR2 | (1) | ||
| REVERSE_CONNECTOR_ID | NUMBER | (10) |
Cut, paste (and edit) the following text to query this object:
SELECT PS_NODE_ID
, DEVL_PROJECT_ID
, FROM_POPULATOR_ID
, PROPERTY_BACKPTR
, ITEM_TYPE_BACKPTR
, INTL_TEXT_ID
, SUB_CONS_ID
, ORGANIZATION_ID
, ITEM_ID
, EXPLOSION_TYPE
, NAME
, ORIG_SYS_REF
, RESOURCE_FLAG
, TOP_ITEM_ID
, INITIAL_VALUE
, PARENT_ID
, MINIMUM
, MAXIMUM
, PS_NODE_TYPE
, FEATURE_TYPE
, PRODUCT_FLAG
, REFERENCE_ID
, MULTI_CONFIG_FLAG
, ORDER_SEQ_FLAG
, SYSTEM_NODE_FLAG
, TREE_SEQ
, COUNTED_OPTIONS_FLAG
, UI_OMIT
, UI_SECTION
, BOM_TREATMENT
, RUN_ID
, REC_STATUS
, DISPOSITION
, DELETED_FLAG
, EFF_FROM
, EFF_TO
, EFF_MASK
, USER_STR01
, USER_STR02
, USER_STR03
, USER_STR04
, USER_NUM01
, USER_NUM02
, USER_NUM03
, USER_NUM04
, CHECKOUT_USER
, CREATION_DATE
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATED_BY
, SECURITY_MASK
, FSK_INTLTEXT_1_1
, FSK_INTLTEXT_1_EXT
, FSK_ITEMMASTER_2_1
, FSK_ITEMMASTER_2_EXT
, FSK_PSNODE_3_1
, FSK_PSNODE_3_EXT
, FSK_PSNODE_4_1
, FSK_PSNODE_4_EXT
, FSK_DEVLPROJECT_5_1
, FSK_DEVLPROJECT_5_EXT
, COMPONENT_SEQUENCE_ID
, COMPONENT_CODE
, PLAN_LEVEL
, BOM_ITEM_TYPE
, SO_ITEM_TYPE_CODE
, MINIMUM_SELECTED
, MAXIMUM_SELECTED
, BOM_REQUIRED
, MUTUALLY_EXCLUSIVE_OPTIONS
, OPTIONAL
, FSK_EXPLNODE_1_1
, FSK_PSNODE_6_1
, EFFECTIVE_FROM
, EFFECTIVE_UNTIL
, EFFECTIVE_USAGE_MASK
, EFFECTIVITY_SET_ID
, FSK_EFFSET_7_1
, DECIMAL_QTY_FLAG
, QUOTEABLE_FLAG
, PRIMARY_UOM_CODE
, COMPONENT_SEQUENCE_PATH
, BOM_SORT_ORDER
, IB_TRACKABLE
, LAST_UPDATE_LOGIN
, INITIAL_NUM_VALUE
, SRC_APPLICATION_ID
, FSK_ITEMMASTER_2_2
, INSTANTIABLE_FLAG
, DISPLAY_IN_SUMMARY_FLAG
, IB_LINK_ITEM_FLAG
, SHIPPABLE_ITEM_FLAG
, INVENTORY_TRANSACTABLE_FLAG
, ASSEMBLE_TO_ORDER_FLAG
, SERIALIZABLE_ITEM_FLAG
, MAX_QTY_PER_OPTION
, DOMAIN_ORDER
, USER_INPUT_REQUIRED_FLAG
, REVERSE_CONNECTOR_ID
FROM CZ.CZ_IMP_PS_NODES;
CZ.CZ_IMP_PS_NODES does not reference any database object
CZ.CZ_IMP_PS_NODES is referenced by following:
APPS
CZ_IMP_PS_NODES
|
|
|
|