CZ_SS_ITEMS

Details

Schema: FUSION
Object owner: CZ
Object type: VIEW

Columns

Name
INVENTORY_ITEM_ID ORGANIZATION_ID PRODUCTION_FLAG VERSION_START_DATE VERSION_END_DATE ITEM_NUMBER BOM_ITEM_TYPE ITEM_CATALOG_GROUP_ID PRIMARY_UOM_CODE INDIVISIBLE_FLAG ELIGIBILITY_COMPATIBILITY_RULE SERIAL_NUMBER_CONTROL_CODE COMMS_NL_TRACKABLE_FLAG REPLENISH_TO_ORDER_FLAG INVENTORY_ITEM_STATUS_CODE DELETED_FLAG REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER DESCRIPTION EFFECTIVITY_CHANGE_DATE SALES_PRODUCT_TYPE

Name

INVENTORY_ITEM_ID

ORGANIZATION_ID

PRODUCTION_FLAG

VERSION_START_DATE

VERSION_END_DATE

ITEM_NUMBER

BOM_ITEM_TYPE

ITEM_CATALOG_GROUP_ID

PRIMARY_UOM_CODE

INDIVISIBLE_FLAG

ELIGIBILITY_COMPATIBILITY_RULE

SERIAL_NUMBER_CONTROL_CODE

COMMS_NL_TRACKABLE_FLAG

REPLENISH_TO_ORDER_FLAG

INVENTORY_ITEM_STATUS_CODE

DELETED_FLAG

REQUEST_ID

JOB_DEFINITION_NAME

JOB_DEFINITION_PACKAGE

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

DESCRIPTION

EFFECTIVITY_CHANGE_DATE

SALES_PRODUCT_TYPE

Query

SQL_Statement
SELECT B.INVENTORY_ITEM_ID, B.ORGANIZATION_ID, B.PRODUCTION_FLAG, B.VERSION_START_DATE, B.VERSION_END_DATE, B.ITEM_NUMBER, B.BOM_ITEM_TYPE, B.ITEM_CATALOG_GROUP_ID, B.PRIMARY_UOM_CODE, B.INDIVISIBLE_FLAG, B.ELIGIBILITY_COMPATIBILITY_RULE, B.SERIAL_NUMBER_CONTROL_CODE, B.COMMS_NL_TRACKABLE_FLAG, B.REPLENISH_TO_ORDER_FLAG, B.INVENTORY_ITEM_STATUS_CODE, B.DELETED_FLAG, B.REQUEST_ID, B.JOB_DEFINITION_NAME, B.JOB_DEFINITION_PACKAGE, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, T.DESCRIPTION, B.EFFECTIVITY_CHANGE_DATE, B.SALES_PRODUCT_TYPE FROM CZ_SS_ITEMS_B B, CZ_SS_ITEMS_TL T WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID AND B.ORGANIZATION_ID = T.ORGANIZATION_ID AND B.PRODUCTION_FLAG = T.PRODUCTION_FLAG AND B.VERSION_START_DATE = T.VERSION_START_DATE AND T.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.INVENTORY_ITEM_ID,

B.ORGANIZATION_ID,

B.PRODUCTION_FLAG,

B.VERSION_START_DATE,

B.VERSION_END_DATE,

B.ITEM_NUMBER,

B.BOM_ITEM_TYPE,

B.ITEM_CATALOG_GROUP_ID,

B.PRIMARY_UOM_CODE,

B.INDIVISIBLE_FLAG,

B.ELIGIBILITY_COMPATIBILITY_RULE,

B.SERIAL_NUMBER_CONTROL_CODE,

B.COMMS_NL_TRACKABLE_FLAG,

B.REPLENISH_TO_ORDER_FLAG,

B.INVENTORY_ITEM_STATUS_CODE,

B.DELETED_FLAG,

B.REQUEST_ID,

B.JOB_DEFINITION_NAME,

B.JOB_DEFINITION_PACKAGE,

B.CREATION_DATE,

B.CREATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_LOGIN,

B.OBJECT_VERSION_NUMBER,

T.DESCRIPTION,

B.EFFECTIVITY_CHANGE_DATE,

B.SALES_PRODUCT_TYPE

FROM

CZ_SS_ITEMS_B B,

CZ_SS_ITEMS_TL T

WHERE

B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID AND B.ORGANIZATION_ID = T.ORGANIZATION_ID AND B.PRODUCTION_FLAG = T.PRODUCTION_FLAG AND B.VERSION_START_DATE = T.VERSION_START_DATE AND T.LANGUAGE = USERENV('LANG')