[Home] [Help]
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
Name |
ITEM_ORG_PK |
INSTANCE |
ITEM_NUMBER_FK |
PROD_FAMILY_FK |
INV_CATEGORY_FK |
PO_CATEGORY_FK |
MRP_CATEGORY_FK |
SER_CATEGORY_FK |
CST_CATEGORY_FK |
ENG_CATEGORY_FK |
OE_CATEGORY_FK |
PLA_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 |
USER_ATTRIBUTE1 |
USER_ATTRIBUTE2 |
USER_ATTRIBUTE3 |
USER_ATTRIBUTE4 |
USER_ATTRIBUTE5 |
CATSET_CATEGORY_FK |