Product: | OKX - Contracts Integration |
---|---|
Description: | Inventory item definitions |
Implementation/DBA Data: | APPS.OKX_SYSTEM_ITEMS_V |
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')