DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OPI_EDW_OPMCOGS_FCV

Object Details
Object Name: OPI_EDW_OPMCOGS_FCV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOPI.OPI_EDW_OPMCOGS_FCV
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Fact source view of COGS for OPM extraction.


[View Source]

Columns
Name Datatype Length Mandatory Comments
COGS_PK VARCHAR2 (120)
Unique Identifier.
COGS_DATE DATE

COGS recognition date.
COGS_DATE_FK VARCHAR2 (4000)
Foreign key on the time dimension.
ORDER_LINE_ID VARCHAR2 (75)
Foreign key on the EDW_NA dimension.
SHIP_INV_LOCATOR_FK VARCHAR2 (39)
Foreign key on the Inventory Location dimension.
INSTANCE_FK VARCHAR2 (30)
Foreign key on the instance dimension (source instance).
TOP_MODEL_ITEM_FK VARCHAR2 (117)
Foreign key on the item org dimension level.
ITEM_ORG_FK VARCHAR2 (117)
Foreign key on the item dimension (item of an organization).
OPERATING_UNIT_FK VARCHAR2 (71)
Foreign key on the internal organization dimension (operating unit).
INV_ORG_FK VARCHAR2 (71)
Foreign key on the internal organization dimension .
CUSTOMER_FK VARCHAR2 (4000)
Foreign key on the trading partner dimension (customer).
SALES_CHANNEL_FK CHAR (6)
Foreign key on the sales channel dimension (sales channel).
PRIM_SALES_REP_FK VARCHAR2 (49)
Foreign key on the HR person dimension assignment level.
PRIM_SALESRESOURCE_FK VARCHAR2 (49)
Foreign Key to Primary Sales Resource Dimension
BILL_TO_LOC_FK VARCHAR2 (4000)
Foreign key on the geography dimension location level.
SHIP_TO_LOC_FK VARCHAR2 (4000)
Foreign key on the geography dimension location level.
PROJECT_FK CHAR (6)
Foreign key on the project dimension (project).
TASK_FK CHAR (6)
Foreign key on the task level of project dimension.
ORDER_DATE DATE

Ordered date.
BASE_UOM_FK VARCHAR2 (4000)
Foreign key on the UOM dimension (base UOM).
TRX_CURRENCY_FK VARCHAR2 (4)
Foreign key on the currency dimension level.
BASE_CURRENCY_FK VARCHAR2 (4)
Foreign key on the currency dimension (base Currency).
ORDER_CATEGORY_FK CHAR (6)
Foreign key on the lookup dimension level.
ORDER_TYPE_FK CHAR (6)
Foreign key on the lookup dimension level.
BILL_TO_SITE_FK VARCHAR2 (4000)
Foreign key on the trading partner dimension location level.
SHIP_TO_SITE_FK VARCHAR2 (4000)
Foreign key on the trading partner dimension location level.
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 (4000)
Foreign key on the invetory location dimension level.
ORDER_SOURCE_FK CHAR (6)
Foreign key on the lookup dimension (order source).
SET_OF_BOOKS_FK VARCHAR2 (81)
Foreign key on the set of books dimension (GL set of books).
CAMPAIGN_INIT_FK CHAR (6)
Foreign key on the campaign dimension (campaign attributed).
CAMPAIGN_ACTL_FK CHAR (6)
Foreign key on the campaign dimension (campaign actual).
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).
MEDCHN_INIT_FK CHAR (6)
Foreign key on the media channel dimension level.
MEDCHN_ACTL_FK CHAR (6)
Foreign key on the media channel 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.
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 the base UOM.
RMA_QTY_B NUMBER

RMA quantity in the base UOM.
ICAP_QTY_B NUMBER

Quantity due to Inter-Company AP invoices in base UOM.
COGS_T NUMBER

COGS in transaction currency.
COGS_B NUMBER

COGS in set of books currency.
COGS_G NUMBER

COGS in global currency.
RMA_VAL_T NUMBER

RMA value in transaction currency.
RMA_VAL_G NUMBER

RMA value in global currency.
LAST_UPDATE_DATE DATE

Standard WHO column.
COST_ELEMENT VARCHAR2 (0)
Cost element Identifier.
ACCOUNT VARCHAR2 (0)
Account Identifier.
ORDER_NUMBER VARCHAR2 (32)
User visible order Identifier.
WAYBILL_NUMBER VARCHAR2 (0)
Waybill number.Waybill number.
LOT VARCHAR2 (32)
Item lot number.
REVISION NUMBER

Item revision number.
SERIAL_NUMBER NUMBER (5)
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 CHAR (6)
User defined dimension foreign key.
USER_FK2 CHAR (6)
User defined dimension foreign key.
USER_FK3 CHAR (6)
User defined dimension foreign key.
USER_FK4 CHAR (6)
User defined dimension foreign key.
USER_FK5 CHAR (6)
User defined dimension foreign key.
OPERATION_CODE VARCHAR2 (0)
Code used by the collection program to determine whether to insert/update/delete this record.
VIEW_ID NUMBER

View Identifier.
SEQ_ID NUMBER

Surrogate key for the sequence.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT COGS_PK
,      COGS_DATE
,      COGS_DATE_FK
,      ORDER_LINE_ID
,      SHIP_INV_LOCATOR_FK
,      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
,      ORDER_DATE
,      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
,      CAMPAIGN_STATUS_ACTL_FK
,      CAMPAIGN_STATUS_INIT_FK
,      MEDCHN_INIT_FK
,      MEDCHN_ACTL_FK
,      OFFER_HDR_FK
,      OFFER_LINE_FK
,      MARKET_SEGMENT_FK
,      TARGET_SEGMENT_INIT_FK
,      TARGET_SEGMENT_ACTL_FK
,      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
,      VIEW_ID
,      SEQ_ID
FROM APPS.OPI_EDW_OPMCOGS_FCV;

Dependencies

[top of page]

APPS.OPI_EDW_OPMCOGS_FCV references the following:

SchemaAPPS
PL/SQL PackageEDW_CURRENCY - show dependent code
PL/SQL PackageEDW_GEOGRAPHY_PKG - show dependent code
PL/SQL PackageEDW_INSTANCE - show dependent code
SynonymEDW_LOCAL_INSTANCE
PL/SQL PackageEDW_MTL_INVENTORY_LOC_PKG - show dependent code
PL/SQL PackageEDW_TIME_PKG - show dependent code
PL/SQL PackageEDW_TRD_PARTNER_PKG - show dependent code
PL/SQL PackageEDW_UTIL - show dependent code
PL/SQL PackageFND_PROFILE - show dependent code
SynonymGL_PLCY_MST
SynonymIC_ITEM_MST
SynonymIC_LOCT_MST
SynonymIC_LOTS_MST
SynonymIC_TRAN_CMP
SynonymIC_TRAN_PND
SynonymIC_WHSE_MST
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS
SynonymOPI_EDW_OPMCOGS_INC
PL/SQL PackageOPI_OPM_COMMON_PKG - show dependent code
SynonymOPI_PMI_UOMS_MST
SynonymOP_CUST_MST
SynonymOP_ORDR_DTL
SynonymOP_ORDR_HDR
SynonymSY_ORGN_MST
APPS.OPI_EDW_OPMCOGS_FCV is referenced by following:

SchemaAPPS
Package BodyOPI_EDW_OPMCOGS_F_C - show dependent code