[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | EDW_ITEM_ONETIME_ITEMORG_LCV |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  ENG.EDW_ITEM_ONETIME_ITEMORG_LCV
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view is the item/organization level source view for one-time items. It stores all item/organization one-time items, as well as the parent category associations. The view is based on MTL_CATEGORIES_KFV, PO_LINES_ALL.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ITEM_ORG_PK | VARCHAR2 | (322) | Unique identifier of the organization item | |
| INSTANCE | VARCHAR2 | (0) | Instance from which the record was collected | |
| ITEM_NUMBER_FK | VARCHAR2 | (322) | Foreign key to the item level | |
| PROD_FAMILY_FK | CHAR | (6) | Foreign key to the product family level | |
| CATSET_CATEGORY_FK | NUMBER | Foreign key to the first level of the organization item category hierarchy | ||
| ITEM_ORG_DP | VARCHAR2 | (240) | Not currently used | |
| NAME | VARCHAR2 | (320) | Organization item name | |
| BUYER_FK | CHAR | (6) | Not currently used | |
| PLANNER_FK | CHAR | (6) | Not currently used | |
| ONE_TIME_FLAG | CHAR | (1) | Flag to indicate if this item is a one-time item | |
| ITEM_NUMBER | VARCHAR2 | (0) | Item number | |
| DESCRIPTION | VARCHAR2 | (240) | Item description | |
| ORGANIZATION_ID | NUMBER | Internal id of the item's organziation | ||
| MAKE_OR_BUY_FLAG | VARCHAR2 | (0) | Make of buy flag | |
| UNIT_LIST_PRICE | VARCHAR2 | (0) | Unit list price | |
| MARKET_PRICE | VARCHAR2 | (0) | Market price | |
| TAXABLE_FLAG | VARCHAR2 | (0) | Flag indicating item is taxable | |
| STOCKABLE_FLAG | VARCHAR2 | (0) | Flag indicating item is stockable | |
| INTERNAL_ORD_FLAG | VARCHAR2 | (0) | Flag indicating internally orderable item | |
| INV_PLANNING_CODE | VARCHAR2 | (0) | Inventory planning code | |
| LOT_CONTROL | VARCHAR2 | (0) | Lot control code | |
| OUTSIDE_OP_FLAG | VARCHAR2 | (0) | Flag indicating item may appear on outside operation purchase order | |
| PRICE_TOL_PERCENT | VARCHAR2 | (0) | Price tolerance percentage | |
| PURCHASABLE_FLAG | VARCHAR2 | (0) | Price tolerance percentage | |
| SHELF_LIFE_CODE | VARCHAR2 | (0) | Shelf life code | |
| SHELF_LIFE_DAYS | VARCHAR2 | (0) | Shelf life days | |
| TAX_CODE | VARCHAR2 | (0) | Tax code | |
| REVISION_CONTROL | VARCHAR2 | (0) | Revision control code | |
| INSP_REQUIRED | VARCHAR2 | (0) | Flag indicating whether inspection is required upon receipt | |
| RECEIPT_REQUIRED | VARCHAR2 | (0) | Flag indicating supplier receipt is required before payment | |
| LOCATOR_CONTROL | VARCHAR2 | (0) | Stock locator control code | |
| EFFECTIVITY_CONTROL | VARCHAR2 | (0) | Indicates whether item is unit or date controlled | |
| SERIAL_CONTROL | VARCHAR2 | (0) | Serial number control code | |
| MRP_PLN_METHOD | VARCHAR2 | (0) | MRP planning method | |
| APPROVED_SUPPLIER | VARCHAR2 | (0) | Approved Supplier | |
| SUBSTITUTE_RCPT | VARCHAR2 | (0) | Substitute receipt | |
| UNORDERED_RCPT | VARCHAR2 | (0) | Flag indicating unordered receipts allowed | |
| EXPRS_DELIVERY | VARCHAR2 | (0) | Flag indicating whether express delivery is required | |
| RFQ_REQUIRED_FLAG | VARCHAR2 | (0) | Flag indicating whether an RFQ (Request For Quotation) is required | |
| CREATION_DATE | DATE | Standard Who column | ||
| LAST_UPDATE_DATE | DATE | Standard Who column | ||
| OPERATION_CODE | VARCHAR2 | (0) | Code used by the collection program to insert/update/delete this record | |
| USER_ATTRIBUTE1 | VARCHAR2 | (0) | User defined attribute | |
| USER_ATTRIBUTE2 | VARCHAR2 | (0) | User defined attribute | |
| USER_ATTRIBUTE3 | VARCHAR2 | (0) | User defined attribute | |
| USER_ATTRIBUTE4 | VARCHAR2 | (0) | User defined attribute | |
| USER_ATTRIBUTE5 | VARCHAR2 | (0) | User defined attribute |
Cut, paste (and edit) the following text to query this object:
SELECT ITEM_ORG_PK
, INSTANCE
, ITEM_NUMBER_FK
, PROD_FAMILY_FK
, CATSET_CATEGORY_FK
, ITEM_ORG_DP
, NAME
, BUYER_FK
, PLANNER_FK
, ONE_TIME_FLAG
, ITEM_NUMBER
, DESCRIPTION
, 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
, RFQ_REQUIRED_FLAG
, CREATION_DATE
, LAST_UPDATE_DATE
, OPERATION_CODE
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
FROM APPS.EDW_ITEM_ONETIME_ITEMORG_LCV;
APPS
MTL_CATEGORIES_KFV
PO_LINES_ALL
PO_REQUISITION_LINES_ALL
RCV_SHIPMENT_LINES
APPS
EDW_ITEMS_M_C
- show dependent code
|
|
|
|