VIEW: APPS.CZ_MODELS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'