[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | EDWBV_ITEM_ITEMORGPF_LCV |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  ENG.EDWBV_ITEM_ITEMORGPF_LCV
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view contains item/organization level Product Family items. It is the base view for its counterpart item/organization collection source view EDW_ITEM_ITEMORGPF_LCV. The view is based on the following: MTL_SYSTEM_ITEMS_KFV, MTL_ITEM_CATEGORIES, MTL_CATEGORY_SETS, and MTL_PARAMETERS.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| _KF:MSTK:MSTK:_EDW | CHAR | (16) | Key Flexfield tag | |
| ITEM_ORG_PK | VARCHAR2 | (112) | Unique identifier of the organization item | |
| INSTANCE | VARCHAR2 | (0) | Instance from which the record was collected | |
| ITEM_NUMBER_FK | VARCHAR2 | (112) | Foreign key to the item level | |
| PROD_FAMILY_FK | VARCHAR2 | (71) | Foreign key to the product family level | |
| CATSET_CATEGORY_FK | CHAR | (6) | Foreign key to the category set level | |
| ITEM_ORG_DP | VARCHAR2 | (45) | Not currently used | |
| NAME | VARCHAR2 | (45) | Organization Item name | |
| BUYER_FK | VARCHAR2 | (40) | Not currently used | |
| PLANNER_FK | VARCHAR2 | (10) | Not currently used | |
| ITEM_NUMBER | VARCHAR2 | (45) | Item number | |
| DESCRIPTION | VARCHAR2 | (240) | Item description | |
| INVENTORY_ITEM_ID | NUMBER | Yes | Internal id of the item in the source system | |
| ORGANIZATION_ID | NUMBER | Yes | ID of the item's organization | |
| MAKE_OR_BUY_FLAG | NUMBER | Make or Buy flag | ||
| UNIT_LIST_PRICE | NUMBER | Unit list price | ||
| MARKET_PRICE | NUMBER | Market price | ||
| TAXABLE_FLAG | VARCHAR2 | (1) | Flag to indicate if this item is taxable | |
| STOCKABLE_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if this item is stockable |
| INTERNAL_ORD_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if this item is internally orderable |
| INV_PLANNING_CODE | NUMBER | Inventory planning code | ||
| LOT_CONTROL | NUMBER | Lot locator control code | ||
| OUTSIDE_OP_FLAG | VARCHAR2 | (1) | Yes | Flag indicating item may appear on outside operation purchase order |
| PRICE_TOL_PERCENT | NUMBER | Price tolerance percentage | ||
| PURCHASABLE_FLAG | VARCHAR2 | (1) | Yes | Flag to indicate if this item is purchasable |
| SHELF_LIFE_CODE | NUMBER | Shelf life code | ||
| SHELF_LIFE_DAYS | NUMBER | Number of shelf life days | ||
| TAX_CODE | VARCHAR2 | (50) | Tax code | |
| REVISION_CONTROL | NUMBER | Revision quantity control code | ||
| INSP_REQUIRED | VARCHAR2 | (1) | Flag indicating whether inspection is required upon receipt | |
| RECEIPT_REQUIRED | VARCHAR2 | (1) | Flag indicating supplier receipt is required before payment | |
| LOCATOR_CONTROL | NUMBER | Stock locator control code | ||
| EFFECTIVITY_CONTROL | NUMBER | Indicates whether item is unit or date controlled | ||
| SERIAL_CONTROL | NUMBER | Serial number control code | ||
| MRP_PLN_METHOD | NUMBER | MRP planning method | ||
| APPROVED_SUPPLIER | VARCHAR2 | (1) | Yes | Approved Supplier |
| SUBSTITUTE_RCPT | VARCHAR2 | (1) | Substitute receipt | |
| UNORDERED_RCPT | VARCHAR2 | (1) | Flag indicating unordered receipts allowed | |
| EXPRS_DELIVERY | VARCHAR2 | (1) | Flag indicating whether express delivery is required | |
| HAZARD_CLASS_ID | NUMBER | Hazard class ID | ||
| UN_NUMBER_ID | NUMBER | Unit number ID | ||
| RFQ_REQUIRED_FLAG | VARCHAR2 | (1) | Flag indicating whether an RFQ (Request For Quotation) is required | |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| OPERATION_CODE | VARCHAR2 | (0) | Code used by the collection program to determine whether to insert/update/delete this record | |
| SEGMENT1 | VARCHAR2 | (40) | Segment 1 of the item key flexfield | |
| _DF:ITM:_EDW | CHAR | (28) | Descriptive flexfield tag |
Cut, paste (and edit) the following text to query this object:
SELECT _KF:MSTK:MSTK:_EDW
, 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
, CREATION_DATE
, LAST_UPDATE_DATE
, OPERATION_CODE
, SEGMENT1
, _DF:ITM:_EDW
FROM APPS.EDWBV_ITEM_ITEMORGPF_LCV;
APPS
EDW_ITEMS_PKG
- show dependent code
EDW_LOCAL_INSTANCE
MTL_CATEGORY_SETS
MTL_ITEM_CATEGORIES
MTL_PARAMETERS
MTL_SYSTEM_ITEMS_KFV
APPS
EDW_ITEM_ITEMORGPF_LCV
|
|
|
|