[Home] [Help] [Dependency Information]
Object Name: | OPI_EDW_COGS_FCV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view contains the extraction logic for COGS
Shipment Fact data from discrete manufacturing side
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VIEW_ID | NUMBER | View ID | ||
SEQ_ID | NUMBER | Sequence Identifier. | ||
COGS_PK | VARCHAR2 | (157) | PK for COGS | |
INSTANCE_FK | VARCHAR2 | (30) | FK to Instance Dimension | |
TOP_MODEL_ITEM_FK | VARCHAR2 | (117) | Parent Model Item, Fk To Item Dimension | |
ITEM_ORG_FK | VARCHAR2 | (117) | FK to Item Dimension | |
OPERATING_UNIT_FK | VARCHAR2 | (71) | Foreign key on the internal organization dimension (operating unit). | |
INV_ORG_FK | VARCHAR2 | (181) | Foreign key on the internal organization dimension . | |
CUSTOMER_FK | VARCHAR2 | (86) | FK reference to the Customer dimension key | |
SALES_CHANNEL_FK | VARCHAR2 | (61) | FK reference to the Sales Channel dimension key | |
PRIM_SALES_REP_FK | VARCHAR2 | (126) | FK reference to HR Person Dimension, Person Assignment Level | |
PRIM_SALESRESOURCE_FK | VARCHAR2 | (126) | FK to Primary Sales Resource | |
BILL_TO_LOC_FK | VARCHAR2 | (4000) | Fk To Geography Dimension | |
SHIP_TO_LOC_FK | VARCHAR2 | (4000) | Fk To Geography Dimension | |
PROJECT_FK | VARCHAR2 | (78) | FK reference to the Project dimension key | |
TASK_FK | VARCHAR2 | (71) | FK reference to the dimension key | |
BASE_UOM_FK | VARCHAR2 | (4000) | FK reference to Unit of Measure Dimension | |
TRX_CURRENCY_FK | VARCHAR2 | (4000) | FK to Transactional Currency | |
BASE_CURRENCY_FK | VARCHAR2 | (4000) | FK to Base Currency | |
ORDER_CATEGORY_FK | VARCHAR2 | (4000) | FK to Order Category | |
ORDER_TYPE_FK | VARCHAR2 | (4000) | FK to Order Type | |
BILL_TO_SITE_FK | VARCHAR2 | (85) | Fk To Trading Partners Dimension | |
SHIP_TO_SITE_FK | VARCHAR2 | (85) | Fk To Trading Partners Dimension | |
MONTH_BOOKED_FK | VARCHAR2 | (4000) | Foreign key on the time dimension level. | |
DATE_BOOKED_FK | VARCHAR2 | (4000) | Foreign key on the time dimension (date booked). | |
DATE_PROMISED_FK | VARCHAR2 | (4000) | Foreign key on the time dimension (date promised). | |
DATE_REQUESTED_FK | VARCHAR2 | (4000) | Foreign key on the time dimension (date requested). | |
DATE_SCHEDULED_FK | VARCHAR2 | (4000) | Foreign key on the time dimension (date scheduled). | |
DATE_SHIPPED_FK | VARCHAR2 | (4000) | Foreign key on the time dimension (date shipped). | |
LOCATOR_FK | VARCHAR2 | (75) | Foreign key on the inventory location dimension level. | |
ORDER_SOURCE_FK | VARCHAR2 | (4000) | Foreign key on the lookup dimension (order source). | |
SET_OF_BOOKS_FK | VARCHAR2 | (71) | Foreign key on the set of books dimension (GL set of books). | |
CAMPAIGN_INIT_FK | CHAR | (6) | Foreign key on the campaign dimension level. | |
CAMPAIGN_ACTL_FK | CHAR | (6) | Foreign key on the campaign dimension level. | |
MEDCHN_INIT_FK | CHAR | (6) | Foreign key on the market segment dimension level. | |
MEDCHN_ACTL_FK | CHAR | (6) | Foreign key on the market segment dimension level. | |
OFFER_HDR_FK | CHAR | (6) | Foreign key on the offer dimension (header level offer). | |
OFFER_LINE_FK | CHAR | (6) | Foreign key on the offer dimension (line level offer). | |
MARKET_SEGMENT_FK | CHAR | (6) | Foreign key on the market segment dimension level. | |
TARGET_SEGMENT_INIT_FK | CHAR | (6) | Foreign key on the target segment dimension level. | |
TARGET_SEGMENT_ACTL_FK | CHAR | (6) | Foreign key on the target segment dimension level. | |
CAMPAIGN_STATUS_ACTL_FK | CHAR | (6) | Foreign key on campaign status dimension. | |
CAMPAIGN_STATUS_INIT_FK | CHAR | (6) | Foreign key on campaign status dimension (initial status).. | |
COGS_DATE_FK | VARCHAR2 | (4000) | Foreign key on the time dimension. | |
ORDER_LINE_ID | VARCHAR2 | (71) | Foreign key on the EDW_NA dimension. | |
SHIP_INV_LOCATOR_FK | VARCHAR2 | (39) | Foreign key on the inventory location dimension. | |
COGS_DATE | DATE | COGS recognition date. | ||
ORDER_DATE | DATE | Ordered date. | ||
PROM_EARLY_COUNT | NUMBER | Number of order lines with shipped date no later than promised date. | ||
PROM_LATE_COUNT | NUMBER | Number of order lines with shipped date later than promised date. | ||
REQ_EARLY_COUNT | NUMBER | Number of order lines with shipped date no later than requested date. | ||
REQ_LATE_COUNT | NUMBER | Number of order lines with shipped date later than requested date. | ||
PROM_EARLY_VAL_G | NUMBER | COGS value in warehouse currency with shipped date no later than promised date. | ||
PROM_LATE_VAL_G | NUMBER | COGS value in warehouse currency with shipped date later than promised date. | ||
REQ_EARLY_VAL_G | NUMBER | COGS value in warehouse currency with shipped date no later than requested date. | ||
REQ_LATE_VAL_G | NUMBER | COGS value in warehouse currency with shipped date later than requested date. | ||
REQUEST_LEAD_TIME | NUMBER | Days between date shipped and date requested. | ||
PROMISE_LEAD_TIME | NUMBER | Days between date shipped and date promised. | ||
ORDER_LEAD_TIME | NUMBER | Days between date shipped and date booked. | ||
SHIPPED_QTY_B | NUMBER | Shipped quantity in base UOM. | ||
RMA_QTY_B | NUMBER | RMA quantity in base UOM. | ||
ICAP_QTY_B | NUMBER | Quantity due to Inter-Company AP invoices in base UOM. | ||
COGS_T | NUMBER | COGS in the transactional currency. | ||
COGS_B | NUMBER | COGS in the set of books currency. | ||
COGS_G | NUMBER | COGS in the global currency. | ||
RMA_VAL_T | NUMBER | RMA value in the transaction currency. | ||
RMA_VAL_G | NUMBER | RMA value in the global currency. | ||
LAST_UPDATE_DATE | VARCHAR2 | (0) | Standard WHO column. | |
COST_ELEMENT | NUMBER | Cost element Identifier. | ||
ACCOUNT | NUMBER | Account Identifier. | ||
ORDER_NUMBER | NUMBER | A user visible order Identifier. | ||
WAYBILL_NUMBER | VARCHAR2 | (30) | Waybill number. | |
LOT | VARCHAR2 | (80) | Item Lot number. | |
REVISION | VARCHAR2 | (3) | Revision number. | |
SERIAL_NUMBER | VARCHAR2 | (30) | Serial number. | |
USER_ATTRIBUTE1 | VARCHAR2 | (0) | User Defined Attribute1. | |
USER_ATTRIBUTE2 | VARCHAR2 | (0) | User Defined Attribute2. | |
USER_ATTRIBUTE3 | VARCHAR2 | (0) | User Defined Attribute3. | |
USER_ATTRIBUTE4 | VARCHAR2 | (0) | User Defined Attribute4. | |
USER_ATTRIBUTE5 | VARCHAR2 | (0) | User Defined Attribute5. | |
USER_ATTRIBUTE6 | VARCHAR2 | (0) | User Defined Attribute6. | |
USER_ATTRIBUTE7 | VARCHAR2 | (0) | User Defined Attribute7. | |
USER_ATTRIBUTE8 | VARCHAR2 | (0) | User Defined Attribute8. | |
USER_ATTRIBUTE9 | VARCHAR2 | (0) | User Defined Attribute9. | |
USER_ATTRIBUTE10 | VARCHAR2 | (0) | User Defined Attribute10. | |
USER_ATTRIBUTE11 | VARCHAR2 | (0) | User Defined Attribute11. | |
USER_ATTRIBUTE12 | VARCHAR2 | (0) | User Defined Attribute12. | |
USER_ATTRIBUTE13 | VARCHAR2 | (0) | User Defined Attribute13. | |
USER_ATTRIBUTE14 | VARCHAR2 | (0) | User Defined Attribute14. | |
USER_ATTRIBUTE15 | VARCHAR2 | (0) | User Defined Attribute15. | |
USER_MEASURE1 | NUMBER | User defined measure. | ||
USER_MEASURE2 | NUMBER | User defined measure. | ||
USER_MEASURE3 | NUMBER | User defined measure. | ||
USER_MEASURE4 | NUMBER | User defined measure. | ||
USER_MEASURE5 | NUMBER | User defined measure. | ||
USER_FK1 | VARCHAR2 | (0) | User defined dimension foreign key. | |
USER_FK2 | VARCHAR2 | (0) | User defined dimension foreign key. | |
USER_FK3 | VARCHAR2 | (0) | User defined dimension foreign key. | |
USER_FK4 | VARCHAR2 | (0) | User defined dimension foreign key. | |
USER_FK5 | VARCHAR2 | (0) | User defined dimension foreign key. | |
OPERATION_CODE | VARCHAR2 | (0) | Code used by the collection program to determine whether to insert/update/delete this record. | |
DELIVERY_ID | NUMBER | Delivery Identifier. | ||
GLOBAL_CURRENCY_RATE | NUMBER | Global currency rate. |
Cut, paste (and edit) the following text to query this object:
SELECT VIEW_ID
, SEQ_ID
, COGS_PK
, INSTANCE_FK
, TOP_MODEL_ITEM_FK
, ITEM_ORG_FK
, OPERATING_UNIT_FK
, INV_ORG_FK
, CUSTOMER_FK
, SALES_CHANNEL_FK
, PRIM_SALES_REP_FK
, PRIM_SALESRESOURCE_FK
, BILL_TO_LOC_FK
, SHIP_TO_LOC_FK
, PROJECT_FK
, TASK_FK
, BASE_UOM_FK
, TRX_CURRENCY_FK
, BASE_CURRENCY_FK
, ORDER_CATEGORY_FK
, ORDER_TYPE_FK
, BILL_TO_SITE_FK
, SHIP_TO_SITE_FK
, MONTH_BOOKED_FK
, DATE_BOOKED_FK
, DATE_PROMISED_FK
, DATE_REQUESTED_FK
, DATE_SCHEDULED_FK
, DATE_SHIPPED_FK
, LOCATOR_FK
, ORDER_SOURCE_FK
, SET_OF_BOOKS_FK
, CAMPAIGN_INIT_FK
, CAMPAIGN_ACTL_FK
, MEDCHN_INIT_FK
, MEDCHN_ACTL_FK
, OFFER_HDR_FK
, OFFER_LINE_FK
, MARKET_SEGMENT_FK
, TARGET_SEGMENT_INIT_FK
, TARGET_SEGMENT_ACTL_FK
, CAMPAIGN_STATUS_ACTL_FK
, CAMPAIGN_STATUS_INIT_FK
, COGS_DATE_FK
, ORDER_LINE_ID
, SHIP_INV_LOCATOR_FK
, COGS_DATE
, ORDER_DATE
, PROM_EARLY_COUNT
, PROM_LATE_COUNT
, REQ_EARLY_COUNT
, REQ_LATE_COUNT
, PROM_EARLY_VAL_G
, PROM_LATE_VAL_G
, REQ_EARLY_VAL_G
, REQ_LATE_VAL_G
, REQUEST_LEAD_TIME
, PROMISE_LEAD_TIME
, ORDER_LEAD_TIME
, SHIPPED_QTY_B
, RMA_QTY_B
, ICAP_QTY_B
, COGS_T
, COGS_B
, COGS_G
, RMA_VAL_T
, RMA_VAL_G
, LAST_UPDATE_DATE
, COST_ELEMENT
, ACCOUNT
, ORDER_NUMBER
, WAYBILL_NUMBER
, LOT
, REVISION
, SERIAL_NUMBER
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, USER_ATTRIBUTE6
, USER_ATTRIBUTE7
, USER_ATTRIBUTE8
, USER_ATTRIBUTE9
, USER_ATTRIBUTE10
, USER_ATTRIBUTE11
, USER_ATTRIBUTE12
, USER_ATTRIBUTE13
, USER_ATTRIBUTE14
, USER_ATTRIBUTE15
, USER_MEASURE1
, USER_MEASURE2
, USER_MEASURE3
, USER_MEASURE4
, USER_MEASURE5
, USER_FK1
, USER_FK2
, USER_FK3
, USER_FK4
, USER_FK5
, OPERATION_CODE
, DELIVERY_ID
, GLOBAL_CURRENCY_RATE
FROM APPS.OPI_EDW_COGS_FCV;
|
|
|