EGP_ITEM_ATTR_CATEGORIES

Details

Schema: FUSION
Object owner: EGP
Object type: VIEW

Columns

Name
INVENTORY_ITEM_ID ORGANIZATION_ID CATEGORY_SET_ID CATEGORY_ID OBJECT_VERSION_NUMBER LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN REQUEST_ID SEQUENCE_NUMBER PROGRAM_NAME PROGRAM_APP_NAME JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE ALT_ITEM_CAT_CODE ITEM_CATEGORY_ASSIGNMENT_ID START_DATE END_DATE ITEM_NUMBER DESCRIPTION ALLOW_ITEM_DESC_UPDATE_FLAG APPROVAL_STATUS DUAL_UOM_CONTROL DUAL_UOM_DEVIATION_HIGH DUAL_UOM_DEVIATION_LOW ENABLED_FLAG INTERNAL_ORDER_ENABLED_FLAG INTERNAL_ORDER_FLAG INVENTORY_ITEM_FLAG LIST_PRICE_PER_UNIT OUTSIDE_OPERATION_FLAG PRIMARY_UOM_CODE PURCHASING_ENABLED_FLAG PURCHASING_ITEM_FLAG SECONDARY_DEFAULT_IND SECONDARY_UOM_CODE SOURCE_SUBINVENTORY HAZARD_CLASS_ID UN_NUMBER_ID RESTRICT_SUBINVENTORIES_CODE NEGOTIATION_REQUIRED_FLAG TRACKING_QUANTITY_IND ONT_PRICING_QTY_SOURCE STOCK_ENABLED_FLAG ROUNDING_FACTOR SHIPPABLE_ITEM_FLAG MTL_TRANSACTIONS_ENABLED_FLAG AUTO_CREATED_CONFIG_FLAG UNIT_OF_ISSUE OUTSIDE_PROCESS_SERVICE_FLAG BOM_ITEM_TYPE LANGUAGE SOURCE_LANG ITEM_DEFINITION_ORG_ID MASTER_ORGANIZATION_ID CONTROL_LEVEL

Name

INVENTORY_ITEM_ID

ORGANIZATION_ID

CATEGORY_SET_ID

CATEGORY_ID

OBJECT_VERSION_NUMBER

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

REQUEST_ID

SEQUENCE_NUMBER

PROGRAM_NAME

PROGRAM_APP_NAME

JOB_DEFINITION_NAME

JOB_DEFINITION_PACKAGE

ALT_ITEM_CAT_CODE

ITEM_CATEGORY_ASSIGNMENT_ID

START_DATE

END_DATE

ITEM_NUMBER

DESCRIPTION

ALLOW_ITEM_DESC_UPDATE_FLAG

APPROVAL_STATUS

DUAL_UOM_CONTROL

DUAL_UOM_DEVIATION_HIGH

DUAL_UOM_DEVIATION_LOW

ENABLED_FLAG

INTERNAL_ORDER_ENABLED_FLAG

INTERNAL_ORDER_FLAG

INVENTORY_ITEM_FLAG

LIST_PRICE_PER_UNIT

OUTSIDE_OPERATION_FLAG

PRIMARY_UOM_CODE

PURCHASING_ENABLED_FLAG

PURCHASING_ITEM_FLAG

SECONDARY_DEFAULT_IND

SECONDARY_UOM_CODE

SOURCE_SUBINVENTORY

HAZARD_CLASS_ID

UN_NUMBER_ID

RESTRICT_SUBINVENTORIES_CODE

NEGOTIATION_REQUIRED_FLAG

TRACKING_QUANTITY_IND

ONT_PRICING_QTY_SOURCE

STOCK_ENABLED_FLAG

ROUNDING_FACTOR

SHIPPABLE_ITEM_FLAG

MTL_TRANSACTIONS_ENABLED_FLAG

AUTO_CREATED_CONFIG_FLAG

UNIT_OF_ISSUE

OUTSIDE_PROCESS_SERVICE_FLAG

BOM_ITEM_TYPE

LANGUAGE

SOURCE_LANG

ITEM_DEFINITION_ORG_ID

MASTER_ORGANIZATION_ID

CONTROL_LEVEL

Query

SQL_Statement
SELECT ITEMCATS.inventory_item_id, ITEMORGS.organization_id, ITEMCATS.category_set_id, ITEMCATS.category_id, ITEMCATS.object_version_number, ITEMCATS.last_update_date, ITEMCATS.last_updated_by, ITEMCATS.creation_date, ITEMCATS.created_by, ITEMCATS.last_update_login, ITEMCATS.request_id, ITEMCATS.sequence_number, ITEMCATS.program_name, ITEMCATS.program_app_name, ITEMCATS.job_definition_name, ITEMCATS.job_definition_package, ITEMCATS.alt_item_cat_code, ITEMCATS.item_category_assignment_id, ITEMCATS.start_date, ITEMCATS.end_date, ITEMSB.ITEM_NUMBER, ITEMSTL.DESCRIPTION, ITEMSB.ALLOW_ITEM_DESC_UPDATE_FLAG, ITEMSB.APPROVAL_STATUS, ITEMSB.DUAL_UOM_CONTROL, ITEMSB.DUAL_UOM_DEVIATION_HIGH, ITEMSB.DUAL_UOM_DEVIATION_LOW, ITEMSB.ENABLED_FLAG, ITEMSB.INTERNAL_ORDER_ENABLED_FLAG, ITEMSB.INTERNAL_ORDER_FLAG, ITEMSB.INVENTORY_ITEM_FLAG, ITEMSB.LIST_PRICE_PER_UNIT, ITEMSB.OUTSIDE_OPERATION_FLAG, ITEMSB.PRIMARY_UOM_CODE, ITEMSB.PURCHASING_ENABLED_FLAG, ITEMSB.PURCHASING_ITEM_FLAG, ITEMSB.SECONDARY_DEFAULT_IND, ITEMSB.SECONDARY_UOM_CODE, ITEMSB.SOURCE_SUBINVENTORY, ITEMSB.HAZARD_CLASS_ID, ITEMSB.UN_NUMBER_ID, ITEMSB.RESTRICT_SUBINVENTORIES_CODE, ITEMSB.NEGOTIATION_REQUIRED_FLAG, ITEMSB.TRACKING_QUANTITY_IND, ITEMSB.ONT_PRICING_QTY_SOURCE, ITEMSB.STOCK_ENABLED_FLAG, ITEMSB.ROUNDING_FACTOR, ITEMSB.SHIPPABLE_ITEM_FLAG, ITEMSB.MTL_TRANSACTIONS_ENABLED_FLAG, ITEMSB.AUTO_CREATED_CONFIG_FLAG, ITEMSB.UNIT_OF_ISSUE, ITEMSB.OUTSIDE_PROCESS_SERVICE_FLAG, ITEMSB.BOM_ITEM_TYPE, ITEMSTL.LANGUAGE, ITEMSTL.SOURCE_LANG, ORGS.ITEM_DEFINITION_ORG_ID, ORGS.MASTER_ORGANIZATION_ID, CATSETS.CONTROL_LEVEL FROM egp_item_cat_assignments ITEMCATS, egp_category_sets_b CATSETS, egp_system_items_b ITEMSB, egp_system_items_tl ITEMSTL, EGP_ITEM_ORG_ASSOCIATIONS ITEMORGS, INV_ORG_PARAMETERS ORGS WHERE CATSETS.category_set_id = ITEMCATS.category_set_id AND ITEMCATS.INVENTORY_ITEM_ID = ITEMSB.INVENTORY_ITEM_ID AND ( ( CATSETS.control_level = 1 AND ITEMCATS.organization_id = ORGS.MASTER_ORGANIZATION_ID ) OR ( CATSETS.control_level = 2 AND ITEMCATS.organization_id = ORGS.ITEM_DEFINITION_ORG_ID ) ) AND ITEMSB.INVENTORY_ITEM_ID = ITEMSTL.INVENTORY_ITEM_ID AND ITEMSB.ORGANIZATION_ID = ITEMSTL.ORGANIZATION_ID AND ITEMSB.INVENTORY_ITEM_ID = ITEMORGS.INVENTORY_ITEM_ID AND ITEMSB.INVENTORY_ORGANIZATION_ID = ORGS.ITEM_DEFINITION_ORG_ID AND ITEMSB.ACD_TYPE = 'PROD' AND ITEMORGS.ORGANIZATION_ID = ORGS.ORGANIZATION_ID AND ITEMORGS.CHANGE_ROW_FLAG = 'N' AND (ITEMSB.VERSION_ID = -1) AND NVL(ITEMSB.ITEM_OBJECT_TYPE, 'ITEM') in ('ITEM', 'DOCUMENT')

SQL_Statement

SELECT ITEMCATS.inventory_item_id,

ITEMORGS.organization_id,

ITEMCATS.category_set_id,

ITEMCATS.category_id,

ITEMCATS.object_version_number,

ITEMCATS.last_update_date,

ITEMCATS.last_updated_by,

ITEMCATS.creation_date,

ITEMCATS.created_by,

ITEMCATS.last_update_login,

ITEMCATS.request_id,

ITEMCATS.sequence_number,

ITEMCATS.program_name,

ITEMCATS.program_app_name,

ITEMCATS.job_definition_name,

ITEMCATS.job_definition_package,

ITEMCATS.alt_item_cat_code,

ITEMCATS.item_category_assignment_id,

ITEMCATS.start_date,

ITEMCATS.end_date,

ITEMSB.ITEM_NUMBER,

ITEMSTL.DESCRIPTION,

ITEMSB.ALLOW_ITEM_DESC_UPDATE_FLAG,

ITEMSB.APPROVAL_STATUS,

ITEMSB.DUAL_UOM_CONTROL,

ITEMSB.DUAL_UOM_DEVIATION_HIGH,

ITEMSB.DUAL_UOM_DEVIATION_LOW,

ITEMSB.ENABLED_FLAG,

ITEMSB.INTERNAL_ORDER_ENABLED_FLAG,

ITEMSB.INTERNAL_ORDER_FLAG,

ITEMSB.INVENTORY_ITEM_FLAG,

ITEMSB.LIST_PRICE_PER_UNIT,

ITEMSB.OUTSIDE_OPERATION_FLAG,

ITEMSB.PRIMARY_UOM_CODE,

ITEMSB.PURCHASING_ENABLED_FLAG,

ITEMSB.PURCHASING_ITEM_FLAG,

ITEMSB.SECONDARY_DEFAULT_IND,

ITEMSB.SECONDARY_UOM_CODE,

ITEMSB.SOURCE_SUBINVENTORY,

ITEMSB.HAZARD_CLASS_ID,

ITEMSB.UN_NUMBER_ID,

ITEMSB.RESTRICT_SUBINVENTORIES_CODE,

ITEMSB.NEGOTIATION_REQUIRED_FLAG,

ITEMSB.TRACKING_QUANTITY_IND,

ITEMSB.ONT_PRICING_QTY_SOURCE,

ITEMSB.STOCK_ENABLED_FLAG,

ITEMSB.ROUNDING_FACTOR,

ITEMSB.SHIPPABLE_ITEM_FLAG,

ITEMSB.MTL_TRANSACTIONS_ENABLED_FLAG,

ITEMSB.AUTO_CREATED_CONFIG_FLAG,

ITEMSB.UNIT_OF_ISSUE,

ITEMSB.OUTSIDE_PROCESS_SERVICE_FLAG,

ITEMSB.BOM_ITEM_TYPE,

ITEMSTL.LANGUAGE,

ITEMSTL.SOURCE_LANG,

ORGS.ITEM_DEFINITION_ORG_ID,

ORGS.MASTER_ORGANIZATION_ID,

CATSETS.CONTROL_LEVEL

FROM egp_item_cat_assignments ITEMCATS,

egp_category_sets_b CATSETS,

egp_system_items_b ITEMSB,

egp_system_items_tl ITEMSTL,

EGP_ITEM_ORG_ASSOCIATIONS ITEMORGS,

INV_ORG_PARAMETERS ORGS

WHERE CATSETS.category_set_id = ITEMCATS.category_set_id

AND ITEMCATS.INVENTORY_ITEM_ID = ITEMSB.INVENTORY_ITEM_ID

AND ( ( CATSETS.control_level = 1

AND ITEMCATS.organization_id = ORGS.MASTER_ORGANIZATION_ID )

OR ( CATSETS.control_level = 2

AND ITEMCATS.organization_id = ORGS.ITEM_DEFINITION_ORG_ID ) )

AND ITEMSB.INVENTORY_ITEM_ID = ITEMSTL.INVENTORY_ITEM_ID

AND ITEMSB.ORGANIZATION_ID = ITEMSTL.ORGANIZATION_ID

AND ITEMSB.INVENTORY_ITEM_ID = ITEMORGS.INVENTORY_ITEM_ID

AND ITEMSB.INVENTORY_ORGANIZATION_ID = ORGS.ITEM_DEFINITION_ORG_ID

AND ITEMSB.ACD_TYPE = 'PROD'

AND ITEMORGS.ORGANIZATION_ID = ORGS.ORGANIZATION_ID

AND ITEMORGS.CHANGE_ROW_FLAG = 'N'

AND (ITEMSB.VERSION_ID = -1)

AND NVL(ITEMSB.ITEM_OBJECT_TYPE, 'ITEM') in ('ITEM', 'DOCUMENT')