View: CZ_MODELS_V

Product:	CZ - Configurator
Description:	Mapping from an item_id to a configuration model
Implementation/DBA Data:	APPS.CZ_MODELS_V

View Text

SELECT TOP_ITEM_ID AS INVENTORY_ITEM_ID
, ORGANIZATION_ID AS BOM_EXPLOSION_ORG_ID
, EFF_FROM AS START_DATE
, EFF_TO AS DISABLE_DATE
, TO_NUMBER(NULL) AS USER_ID
, TO_NUMBER(NULL) AS RESPONSIBILITY_ID
, TO_NUMBER(NULL) AS UI_DEF_ID
, MODEL_PS_NODE_ID AS PS_NODE_ID
FROM CZ_XFR_PROJECT_BILLS
WHERE DELETED_FLAG='0'

Columns