SELECT MTL_SYSTEM_ITEMS_B.LAST_UPDATE_DATE
,MTL_SYSTEM_ITEMS_B.LAST_UPDATED_BY
,MTL_SYSTEM_ITEMS_B.CREATION_DATE
,MTL_SYSTEM_ITEMS_B.CREATED_BY
,MTL_SYSTEM_ITEMS_B.DESCRIPTION
,MTL_SYSTEM_ITEMS_B.SEGMENT1
,MTL_SYSTEM_ITEMS_B.SHELF_LIFE_CODE
,MTL_SYSTEM_ITEMS_B.UNIT_WEIGHT
,MTL_SYSTEM_ITEMS_B.WEIGHT_UOM_CODE
,MTL_SYSTEM_ITEMS_B.VOLUME_UOM_CODE
,MTL_SYSTEM_ITEMS_B.UNIT_VOLUME
,MTL_SYSTEM_ITEMS_B.PRIMARY_UOM_CODE
,MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID
,MTL_SYSTEM_ITEMS_B.ITEM_TYPE
,MTL_PARAMETERS.MASTER_ORGANIZATION_ID
,MTL_SYSTEM_ITEMS_B.HAZARD_CLASS_ID
,MTL_SYSTEM_ITEMS_B.SERIAL_NUMBER_CONTROL_CODE
,MTL_SYSTEM_ITEMS_B.PLANNING_MAKE_BUY_CODE
,MTL_SYSTEM_ITEMS_B.BASE_ITEM_ID
,MTL_SYSTEM_ITEMS_B.START_DATE_ACTIVE
,MTL_SYSTEM_ITEMS_B.RETURNABLE_FLAG
,MTL_SYSTEM_ITEMS_B.PURCHASING_ENABLED_FLAG
,MTL_SYSTEM_ITEMS_B.SERVICEABLE_PRODUCT_FLAG
,MTL_SYSTEM_ITEMS_B.END_DATE_ACTIVE
,MTL_SYSTEM_ITEMS_B.FIXED_ORDER_QUANTITY
,MTL_SYSTEM_ITEMS_B.ORDER_COST
,MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_FLAG
,MTL_SYSTEM_ITEMS_B.CUSTOMER_ORDER_ENABLED_FLAG
FROM MTL_SYSTEM_ITEMS_B
,MTL_PARAMETERS
WHERE MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID = MTL_PARAMETERS.ORGANIZATION_ID
AND MTL_PARAMETERS.MASTER_ORGANIZATION_ID = MTL_PARAMETERS.ORGANIZATION_ID
No comments:
Post a Comment