VIEW: APPS.OKX_SYSTEM_ITEMS_V

Source

View Text - Preformatted

SELECT B.INVENTORY_ITEM_ID ID1, B.ORGANIZATION_ID ID2, T.DESCRIPTION NAME, B.CONCATENATED_SEGMENTS DESCRIPTION, B.CUSTOMER_ORDER_ENABLED_FLAG CUSTOMER_ORDER_ENABLED_FLAG, B.SERVICE_ITEM_FLAG SERVICE_ITEM_FLAG, B.VENDOR_WARRANTY_FLAG VENDOR_WARRANTY_FLAG, B.SERVICEABLE_PRODUCT_FLAG SERVICEABLE_PRODUCT_FLAG, B.COVERAGE_SCHEDULE_ID COVERAGE_TEMPLATE_ID, B.ITEM_TYPE ITEM_TYPE, B.ENABLED_FLAG B_STATUS, DECODE(B.ENABLED_FLAG,'Y','A','I') STATUS, B.START_DATE_ACTIVE START_DATE_ACTIVE, B.END_DATE_ACTIVE END_DATE_ACTIVE, B.SHIPPABLE_ITEM_FLAG SHIPPABLE_ITEM_FLAG, B.PRIMARY_UOM_CODE PRIMARY_UOM_CODE, B.USAGE_ITEM_FLAG USAGE_ITEM_FLAG, B.SERVICE_STARTING_DELAY SERVICE_STARTING_DELAY, B.INVENTORY_ITEM_ID INVENTORY_ITEM_ID, B.ORGANIZATION_ID ORGANIZATION_ID, B.SEGMENT1 SEGMENT1, B.SEGMENT2 SEGMENT2, B.SEGMENT3 SEGMENT3, B.SEGMENT4 SEGMENT4, B.SEGMENT5 SEGMENT5, B.SEGMENT6 SEGMENT6, B.SEGMENT7 SEGMENT7, B.SEGMENT8 SEGMENT8, B.SEGMENT9 SEGMENT9, B.SEGMENT10 SEGMENT10, B.SEGMENT11 SEGMENT11, B.SEGMENT12 SEGMENT12, B.SEGMENT13 SEGMENT13, B.SEGMENT14 SEGMENT14, B.SEGMENT15 SEGMENT15, B.SEGMENT16 SEGMENT16, B.SEGMENT17 SEGMENT17, B.SEGMENT18 SEGMENT18, B.SEGMENT19 SEGMENT19, B.SEGMENT20 SEGMENT20, B.CUSTOMER_ORDER_FLAG, B.INTERNAL_ORDER_FLAG, B.INTERNAL_ORDER_ENABLED_FLAG, B.INVOICEABLE_ITEM_FLAG, B.INVOICE_ENABLED_FLAG, B.BOM_ITEM_TYPE BOM_ITEM_TYPE, B.INVENTORY_ITEM_FLAG INVENTORY_ITEM_FLAG, B.BOM_ENABLED_FLAG BOM_ENABLED_FLAG, B.LIST_PRICE_PER_UNIT LIST_PRICE_PER_UNIT, B.ATP_FLAG ATP_FLAG, B.INVENTORY_ITEM_STATUS_CODE INVENTORY_ITEM_STATUS_CODE, B.PURCHASING_ITEM_FLAG, B.EXPENSE_ACCOUNT, B.PURCHASING_ENABLED_FLAG PURCHASING_ENABLED_FLAG, B.GLOBAL_ATTRIBUTE_CATEGORY, B.GLOBAL_ATTRIBUTE1, B.GLOBAL_ATTRIBUTE2, B.GLOBAL_ATTRIBUTE3, B.GLOBAL_ATTRIBUTE4, B.GLOBAL_ATTRIBUTE5, B.GLOBAL_ATTRIBUTE6, B.GLOBAL_ATTRIBUTE7, B.GLOBAL_ATTRIBUTE8, B.GLOBAL_ATTRIBUTE9, B.GLOBAL_ATTRIBUTE10 FROM MTL_SYSTEM_ITEMS_B_KFV B,MTL_SYSTEM_ITEMS_TL T WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID and B.ORGANIZATION_ID = T.ORGANIZATION_ID and T.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.INVENTORY_ITEM_ID ID1
, B.ORGANIZATION_ID ID2
, T.DESCRIPTION NAME
, B.CONCATENATED_SEGMENTS DESCRIPTION
, B.CUSTOMER_ORDER_ENABLED_FLAG CUSTOMER_ORDER_ENABLED_FLAG
, B.SERVICE_ITEM_FLAG SERVICE_ITEM_FLAG
, B.VENDOR_WARRANTY_FLAG VENDOR_WARRANTY_FLAG
, B.SERVICEABLE_PRODUCT_FLAG SERVICEABLE_PRODUCT_FLAG
, B.COVERAGE_SCHEDULE_ID COVERAGE_TEMPLATE_ID
, B.ITEM_TYPE ITEM_TYPE
, B.ENABLED_FLAG B_STATUS
, DECODE(B.ENABLED_FLAG
, 'Y'
, 'A'
, 'I') STATUS
, B.START_DATE_ACTIVE START_DATE_ACTIVE
, B.END_DATE_ACTIVE END_DATE_ACTIVE
, B.SHIPPABLE_ITEM_FLAG SHIPPABLE_ITEM_FLAG
, B.PRIMARY_UOM_CODE PRIMARY_UOM_CODE
, B.USAGE_ITEM_FLAG USAGE_ITEM_FLAG
, B.SERVICE_STARTING_DELAY SERVICE_STARTING_DELAY
, B.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, B.ORGANIZATION_ID ORGANIZATION_ID
, B.SEGMENT1 SEGMENT1
, B.SEGMENT2 SEGMENT2
, B.SEGMENT3 SEGMENT3
, B.SEGMENT4 SEGMENT4
, B.SEGMENT5 SEGMENT5
, B.SEGMENT6 SEGMENT6
, B.SEGMENT7 SEGMENT7
, B.SEGMENT8 SEGMENT8
, B.SEGMENT9 SEGMENT9
, B.SEGMENT10 SEGMENT10
, B.SEGMENT11 SEGMENT11
, B.SEGMENT12 SEGMENT12
, B.SEGMENT13 SEGMENT13
, B.SEGMENT14 SEGMENT14
, B.SEGMENT15 SEGMENT15
, B.SEGMENT16 SEGMENT16
, B.SEGMENT17 SEGMENT17
, B.SEGMENT18 SEGMENT18
, B.SEGMENT19 SEGMENT19
, B.SEGMENT20 SEGMENT20
, B.CUSTOMER_ORDER_FLAG
, B.INTERNAL_ORDER_FLAG
, B.INTERNAL_ORDER_ENABLED_FLAG
, B.INVOICEABLE_ITEM_FLAG
, B.INVOICE_ENABLED_FLAG
, B.BOM_ITEM_TYPE BOM_ITEM_TYPE
, B.INVENTORY_ITEM_FLAG INVENTORY_ITEM_FLAG
, B.BOM_ENABLED_FLAG BOM_ENABLED_FLAG
, B.LIST_PRICE_PER_UNIT LIST_PRICE_PER_UNIT
, B.ATP_FLAG ATP_FLAG
, B.INVENTORY_ITEM_STATUS_CODE INVENTORY_ITEM_STATUS_CODE
, B.PURCHASING_ITEM_FLAG
, B.EXPENSE_ACCOUNT
, B.PURCHASING_ENABLED_FLAG PURCHASING_ENABLED_FLAG
, B.GLOBAL_ATTRIBUTE_CATEGORY
, B.GLOBAL_ATTRIBUTE1
, B.GLOBAL_ATTRIBUTE2
, B.GLOBAL_ATTRIBUTE3
, B.GLOBAL_ATTRIBUTE4
, B.GLOBAL_ATTRIBUTE5
, B.GLOBAL_ATTRIBUTE6
, B.GLOBAL_ATTRIBUTE7
, B.GLOBAL_ATTRIBUTE8
, B.GLOBAL_ATTRIBUTE9
, B.GLOBAL_ATTRIBUTE10
FROM MTL_SYSTEM_ITEMS_B_KFV B
, MTL_SYSTEM_ITEMS_TL T
WHERE B.INVENTORY_ITEM_ID = T.INVENTORY_ITEM_ID
AND B.ORGANIZATION_ID = T.ORGANIZATION_ID
AND T.LANGUAGE = USERENV('LANG')