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

VIEW: APPS.OPI_EDW_COGS_FCV

Object Details
Object Name: OPI_EDW_COGS_FCV
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

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


[View Source]

Columns
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.
Query Text

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;

Dependencies

[top of page]

APPS.OPI_EDW_COGS_FCV references the following:

SchemaAPPS
SynonymAP_INVOICES_ALL
SynonymAP_INVOICE_DISTRIBUTIONS_ALL
PL/SQL PackageEDW_CURRENCY - show dependent code
PL/SQL PackageEDW_GEOGRAPHY_PKG - show dependent code
SynonymEDW_LOCAL_INSTANCE
PL/SQL PackageEDW_LOOKUP_PKG - show dependent code
PL/SQL PackageEDW_TIME_PKG - show dependent code
PL/SQL PackageEDW_UTIL - show dependent code
SynonymFINANCIALS_SYSTEM_PARAMS_ALL
SynonymFND_PRODUCT_GROUPS
ViewGL_SETS_OF_BOOKS
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_ORGANIZATION_INFORMATION
ViewHR_ORGANIZATION_UNITS
PL/SQL PackageHR_SECURITY - show dependent code
SynonymMTL_MATERIAL_TRANSACTIONS
SynonymMTL_PARAMETERS
SynonymMTL_TRANSACTION_ACCOUNTS
SynonymOE_ORDER_HEADERS_ALL
SynonymOE_ORDER_LINES_ALL
SynonymOPI_EDW_COGS_INC
SynonymRA_CUSTOMER_TRX_LINES_ALL
SynonymSO_ORDER_TYPES_ALL
SynonymWSH_DELIVERY_ASSIGNMENTS
SynonymWSH_DELIVERY_DETAILS
SynonymWSH_NEW_DELIVERIES
APPS.OPI_EDW_COGS_FCV is referenced by following:

SchemaAPPS
Package BodyOPI_EDW_COGS_F_C - show dependent code