[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CZ_IMP_PS_NODES# |
|---|---|
| Object Type: | VIEW |
| Owner: | CZ |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PS_NODE_ID | NUMBER | (15) | ||
| DEVL_PROJECT_ID | NUMBER | (15) | ||
| FROM_POPULATOR_ID | NUMBER | (9) | ||
| PROPERTY_BACKPTR | NUMBER | (9) | ||
| ITEM_TYPE_BACKPTR | NUMBER | (9) | ||
| INTL_TEXT_ID | NUMBER | (15) | ||
| SUB_CONS_ID | NUMBER | (9) | ||
| ORGANIZATION_ID | NUMBER | (9) | ||
| ITEM_ID | NUMBER | (9) | ||
| EXPLOSION_TYPE | VARCHAR2 | (20) | ||
| NAME | VARCHAR2 | (1000) | ||
| ORIG_SYS_REF | VARCHAR2 | (1200) | ||
| RESOURCE_FLAG | VARCHAR2 | (1) | ||
| TOP_ITEM_ID | NUMBER | (9) | ||
| INITIAL_VALUE | VARCHAR2 | (255) | ||
| PARENT_ID | NUMBER | (15) | ||
| MINIMUM | NUMBER | |||
| MAXIMUM | NUMBER | |||
| PS_NODE_TYPE | NUMBER | (9) | ||
| FEATURE_TYPE | NUMBER | (9) | ||
| PRODUCT_FLAG | VARCHAR2 | (1) | ||
| REFERENCE_ID | NUMBER | (15) | ||
| MULTI_CONFIG_FLAG | VARCHAR2 | (1) | ||
| ORDER_SEQ_FLAG | VARCHAR2 | (1) | ||
| SYSTEM_NODE_FLAG | VARCHAR2 | (1) | ||
| TREE_SEQ | NUMBER | (9) | ||
| COUNTED_OPTIONS_FLAG | VARCHAR2 | (1) | ||
| UI_OMIT | VARCHAR2 | (1) | ||
| UI_SECTION | NUMBER | (9) | ||
| BOM_TREATMENT | NUMBER | (9) | ||
| RUN_ID | NUMBER | |||
| REC_STATUS | VARCHAR2 | (4) | ||
| DISPOSITION | VARCHAR2 | (1) | ||
| DELETED_FLAG | VARCHAR2 | (1) | Yes | |
| EFF_FROM | DATE | |||
| EFF_TO | DATE | |||
| EFF_MASK | VARCHAR2 | (40) | ||
| USER_STR01 | VARCHAR2 | (255) | ||
| USER_STR02 | VARCHAR2 | (255) | ||
| USER_STR03 | VARCHAR2 | (255) | ||
| USER_STR04 | VARCHAR2 | (255) | ||
| USER_NUM01 | NUMBER | (16) | ||
| USER_NUM02 | NUMBER | (16) | ||
| USER_NUM03 | NUMBER | (16) | ||
| USER_NUM04 | NUMBER | (16) | ||
| CHECKOUT_USER | VARCHAR2 | (40) | ||
| CREATION_DATE | DATE | |||
| LAST_UPDATE_DATE | DATE | |||
| CREATED_BY | NUMBER | (15) | ||
| LAST_UPDATED_BY | NUMBER | (15) | ||
| SECURITY_MASK | VARCHAR2 | (40) | ||
| FSK_INTLTEXT_1_1 | VARCHAR2 | (255) | ||
| FSK_INTLTEXT_1_EXT | VARCHAR2 | (255) | ||
| FSK_ITEMMASTER_2_1 | VARCHAR2 | (255) | ||
| FSK_ITEMMASTER_2_EXT | VARCHAR2 | (255) | ||
| FSK_PSNODE_3_1 | VARCHAR2 | (255) | ||
| FSK_PSNODE_3_EXT | VARCHAR2 | (255) | ||
| FSK_PSNODE_4_1 | VARCHAR2 | (255) | ||
| FSK_PSNODE_4_EXT | VARCHAR2 | (255) | ||
| FSK_DEVLPROJECT_5_1 | VARCHAR2 | (255) | ||
| FSK_DEVLPROJECT_5_EXT | VARCHAR2 | (255) | ||
| COMPONENT_SEQUENCE_ID | NUMBER | |||
| COMPONENT_CODE | VARCHAR2 | (1200) | ||
| PLAN_LEVEL | NUMBER | |||
| BOM_ITEM_TYPE | NUMBER | |||
| SO_ITEM_TYPE_CODE | VARCHAR2 | (30) | ||
| MINIMUM_SELECTED | NUMBER | (9) | ||
| MAXIMUM_SELECTED | NUMBER | (9) | ||
| BOM_REQUIRED | VARCHAR2 | (1) | ||
| MUTUALLY_EXCLUSIVE_OPTIONS | NUMBER | |||
| OPTIONAL | NUMBER | |||
| FSK_EXPLNODE_1_1 | VARCHAR2 | (255) | ||
| FSK_PSNODE_6_1 | VARCHAR2 | (255) | ||
| EFFECTIVE_FROM | DATE | |||
| EFFECTIVE_UNTIL | DATE | |||
| EFFECTIVE_USAGE_MASK | VARCHAR2 | (16) | ||
| EFFECTIVITY_SET_ID | NUMBER | |||
| FSK_EFFSET_7_1 | VARCHAR2 | (256) | ||
| DECIMAL_QTY_FLAG | VARCHAR2 | (1) | ||
| QUOTEABLE_FLAG | VARCHAR2 | (1) | ||
| PRIMARY_UOM_CODE | VARCHAR2 | (3) | ||
| COMPONENT_SEQUENCE_PATH | VARCHAR2 | (2000) | ||
| BOM_SORT_ORDER | VARCHAR2 | (4000) | ||
| IB_TRACKABLE | VARCHAR2 | (1) | ||
| LAST_UPDATE_LOGIN | NUMBER | |||
| INITIAL_NUM_VALUE | NUMBER | |||
| SRC_APPLICATION_ID | NUMBER | |||
| FSK_ITEMMASTER_2_2 | NUMBER | |||
| INSTANTIABLE_FLAG | VARCHAR2 | (1) | ||
| DISPLAY_IN_SUMMARY_FLAG | VARCHAR2 | (1) | ||
| IB_LINK_ITEM_FLAG | VARCHAR2 | (1) | ||
| SHIPPABLE_ITEM_FLAG | VARCHAR2 | (1) | ||
| INVENTORY_TRANSACTABLE_FLAG | VARCHAR2 | (1) | ||
| ASSEMBLE_TO_ORDER_FLAG | VARCHAR2 | (1) | ||
| SERIALIZABLE_ITEM_FLAG | VARCHAR2 | (1) | ||
| 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
APPS
CZ_IMP_PS_NODES
|
|
|
|