EGP_ITEM_ATTR_CATEGORIES_V
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 |
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) |