View: EDW_ITEM_ITEMORG_LCV

Product:	ENG - Engineering
Description:	This view holds item - organization level information
Implementation/DBA Data:	APPS.EDW_ITEM_ITEMORG_LCV

View Text

SELECT ITEM_ORG_PK
, INSTANCE
, ITEM_NUMBER_FK
, PROD_FAMILY_FK
, CATSET_CATEGORY_FK
, ITEM_ORG_DP
, NAME
, BUYER_FK
, PLANNER_FK
, ITEM_NUMBER
, DESCRIPTION
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, MAKE_OR_BUY_FLAG
, UNIT_LIST_PRICE
, MARKET_PRICE
, TAXABLE_FLAG
, STOCKABLE_FLAG
, INTERNAL_ORD_FLAG
, INV_PLANNING_CODE
, LOT_CONTROL
, OUTSIDE_OP_FLAG
, PRICE_TOL_PERCENT
, PURCHASABLE_FLAG
, SHELF_LIFE_CODE
, SHELF_LIFE_DAYS
, TAX_CODE
, REVISION_CONTROL
, INSP_REQUIRED
, RECEIPT_REQUIRED
, LOCATOR_CONTROL
, EFFECTIVITY_CONTROL
, SERIAL_CONTROL
, MRP_PLN_METHOD
, APPROVED_SUPPLIER
, SUBSTITUTE_RCPT
, UNORDERED_RCPT
, EXPRS_DELIVERY
, HAZARD_CLASS_ID
, UN_NUMBER_ID
, RFQ_REQUIRED_FLAG
, SEGMENT1
, CREATION_DATE
, LAST_UPDATE_DATE
, OPERATION_CODE
, NULL
, NULL
, NULL
, NULL
, NULL
FROM EDWBV_ITEM_ITEMORG_LCV

Columns