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

VIEW: APPS.ISC_EDW_BACKLOGS_F_FCV

Object Details
Object Name: ISC_EDW_BACKLOGS_F_FCV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewISC.ISC_EDW_BACKLOGS_F_FCV
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
BACKLOGS_PK VARCHAR2 (768)
Unique identifier
BASE_UOM_FK VARCHAR2 (4000)
Foreign key to the UoM dimension
BILL_TO_CUST_FK VARCHAR2 (85)
Foreign key to the Trading Partner dimension (Bill-to Site)
BILL_TO_LOCATION_FK VARCHAR2 (4000)
Foreign key to the Geography dimension (Bill-to Location)
CUSTOMER_FK VARCHAR2 (86)
Foreign key to the Trading Partner dimension (Customer)
DATE_BALANCE_FK VARCHAR2 (76)
Foreign key to the Time dimension (Date of Snapshot)
DEMAND_CLASS_FK VARCHAR2 (61)
Foreign key to the Demand Class dimension
GL_BOOK_FK VARCHAR2 (71)
Foreign key to the Set of Books dimension (GL Set of Book)
INSTANCE_FK VARCHAR2 (30)
Foreign key to the Instance dimension
INV_ORG_FK VARCHAR2 (71)
Foreign key to the Inventory Location dimension (Inventory Organization) from which the Items are issued
ITEM_ORG_FK VARCHAR2 (117)
Foreign key to the Organization Item dimension
OPERATING_UNIT_FK VARCHAR2 (4000)
Foreign key to the Internal Organization dimension (Operating Unit)
ORDER_CATEGORY_FK VARCHAR2 (49)
Foreign key to the Lookup dimension (Sales Order Category)
ORDER_SOURCE_FK VARCHAR2 (257)
Foreign key to the Lookup dimension (Sales Order Source)
ORDER_TYPE_FK VARCHAR2 (45)
Foreign key to the Lookup dimension (Sales Order Type)
SALES_CHANNEL_FK VARCHAR2 (61)
Foreign key to the Sales Channel dimension
SALES_PERSON_FK VARCHAR2 (126)
Foreign key to the Person dimension (Salesperson)
SHIP_TO_CUST_FK VARCHAR2 (85)
Foreign key to the Trading Partner dimension (Ship-to Site) for which the items are shipped
SHIP_TO_LOCATION_FK VARCHAR2 (4000)
Foreign key to the Geography dimension (Ship-to Location) to which the items are shipped
TASK_FK VARCHAR2 (78)
Foreign key to the Project dimension (Project Task)
TOP_MODEL_ITEM_FK VARCHAR2 (117)
Foreign key to the Item dimension (Top Model Organization Item) when the item is a component in a bill of material
TRX_CURRENCY_FK VARCHAR2 (15)
Foreign key to the Currency dimension (Transaction Currency)
BILL_BKLG_COST_G NUMBER

Billing Backlog Cost in Warehouse Currency
BILL_BKLG_COST_T NUMBER

Billing Backlog Cost in Transaction Currency
BILL_BKLG_MRG_G NUMBER

Billing Backlog Gross Margin in Warehouse Currency
BILL_BKLG_MRG_T NUMBER

Billing Backlog Gross Margin in Transaction Currency
BILL_BKLG_REV_G NUMBER

Billing Backlog Revenue in Warehouse Currency
BILL_BKLG_REV_T NUMBER

Billing Backlog Revenue in Transaction Currency
DLQT_BKLG_COST_G NUMBER

Delinquent Backlog Cost in Warehouse Currency
DLQT_BKLG_COST_T NUMBER

Delinquent Backlog Cost in Transaction Currency
DLQT_BKLG_MRG_G NUMBER

Delinquent Backlog Gross Margin in Warehouse Currency
DLQT_BKLG_MRG_T NUMBER

Delinquent Backlog Gross Margin in Transaction Currency
DLQT_BKLG_REV_G NUMBER

Delinquent Backlog Revenue in Warehouse Currency
DLQT_BKLG_REV_T NUMBER

Delinquent Backlog Revenue in Transaction Currency
QTY_BILL_BKLG_B NUMBER

Billing Backlog Quantity
QTY_DLQT_BKLG_B NUMBER

Delinquent Backlog Quantity
QTY_SHIP_BKLG_B NUMBER

Shipping Backlog Quantity
QTY_UNBILL_SHIP_B NUMBER

Unbilled Shipments Backlog Quantity
SHIP_BKLG_COST_G NUMBER

Shipping Backlog Cost in Warehouse Currency
SHIP_BKLG_COST_T NUMBER

Shipping Backlog Cost in Transaction Currency
SHIP_BKLG_MRG_G NUMBER

Shipping Backlog Gross Margin in Warehouse Currency
SHIP_BKLG_MRG_T NUMBER

Shipping Backlog Gross Margin in Transaction Currency
SHIP_BKLG_REV_G NUMBER

Shipping Backlog Revenue in Warehouse Currency
SHIP_BKLG_REV_T NUMBER

Shipping Backlog Revenue in Transaction Currency
UNBILL_SHIP_COST_G NUMBER

Unbilled Shipments Cost in Warehouse Currency
UNBILL_SHIP_COST_T NUMBER

Unbilled Shipments Cost in Transaction Currency
UNBILL_SHIP_MRG_G NUMBER

Unbilled Shipments Gross Margin in Warehouse Currency
UNBILL_SHIP_MRG_T NUMBER

Unbilled Shipments Gross Margin in Transaction Currency
UNBILL_SHIP_REV_G NUMBER

Unbilled Shipments Revenue in Warehouse Currency
UNBILL_SHIP_REV_T NUMBER

Unbilled Shipments Revenue in Transaction Currency
INSTANCE VARCHAR2 (30)
Source instance
LAST_UPDATE_DATE DATE

Standard Who column
SEQ_ID NUMBER

Sequence id used by the collection program
USER_ATTRIBUTE1 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE2 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE3 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE4 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE5 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE6 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE7 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE8 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE9 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE10 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE11 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE12 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE13 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE14 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE15 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE16 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE17 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE18 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE19 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE20 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE21 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE22 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE23 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE24 VARCHAR2 (0)
User attribute
USER_ATTRIBUTE25 VARCHAR2 (0)
User attribute
USER_FK1 CHAR (6)
Foreign key to user defined dimension
USER_FK2 CHAR (6)
Foreign key to user defined dimension
USER_FK3 CHAR (6)
Foreign key to user defined dimension
USER_FK4 CHAR (6)
Foreign key to user defined dimension
USER_FK5 CHAR (6)
Foreign key to user defined dimension
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
Query Text

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


SELECT BACKLOGS_PK
,      BASE_UOM_FK
,      BILL_TO_CUST_FK
,      BILL_TO_LOCATION_FK
,      CUSTOMER_FK
,      DATE_BALANCE_FK
,      DEMAND_CLASS_FK
,      GL_BOOK_FK
,      INSTANCE_FK
,      INV_ORG_FK
,      ITEM_ORG_FK
,      OPERATING_UNIT_FK
,      ORDER_CATEGORY_FK
,      ORDER_SOURCE_FK
,      ORDER_TYPE_FK
,      SALES_CHANNEL_FK
,      SALES_PERSON_FK
,      SHIP_TO_CUST_FK
,      SHIP_TO_LOCATION_FK
,      TASK_FK
,      TOP_MODEL_ITEM_FK
,      TRX_CURRENCY_FK
,      BILL_BKLG_COST_G
,      BILL_BKLG_COST_T
,      BILL_BKLG_MRG_G
,      BILL_BKLG_MRG_T
,      BILL_BKLG_REV_G
,      BILL_BKLG_REV_T
,      DLQT_BKLG_COST_G
,      DLQT_BKLG_COST_T
,      DLQT_BKLG_MRG_G
,      DLQT_BKLG_MRG_T
,      DLQT_BKLG_REV_G
,      DLQT_BKLG_REV_T
,      QTY_BILL_BKLG_B
,      QTY_DLQT_BKLG_B
,      QTY_SHIP_BKLG_B
,      QTY_UNBILL_SHIP_B
,      SHIP_BKLG_COST_G
,      SHIP_BKLG_COST_T
,      SHIP_BKLG_MRG_G
,      SHIP_BKLG_MRG_T
,      SHIP_BKLG_REV_G
,      SHIP_BKLG_REV_T
,      UNBILL_SHIP_COST_G
,      UNBILL_SHIP_COST_T
,      UNBILL_SHIP_MRG_G
,      UNBILL_SHIP_MRG_T
,      UNBILL_SHIP_REV_G
,      UNBILL_SHIP_REV_T
,      INSTANCE
,      LAST_UPDATE_DATE
,      SEQ_ID
,      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_ATTRIBUTE16
,      USER_ATTRIBUTE17
,      USER_ATTRIBUTE18
,      USER_ATTRIBUTE19
,      USER_ATTRIBUTE20
,      USER_ATTRIBUTE21
,      USER_ATTRIBUTE22
,      USER_ATTRIBUTE23
,      USER_ATTRIBUTE24
,      USER_ATTRIBUTE25
,      USER_FK1
,      USER_FK2
,      USER_FK3
,      USER_FK4
,      USER_FK5
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
FROM APPS.ISC_EDW_BACKLOGS_F_FCV;

Dependencies

[top of page]

APPS.ISC_EDW_BACKLOGS_F_FCV references the following:

SchemaAPPS
PL/SQL PackageEDW_CURRENCY - show dependent code
PL/SQL PackageEDW_GEOGRAPHY_PKG - show dependent code
PL/SQL PackageEDW_ORGANIZATION_PKG - show dependent code
PL/SQL PackageEDW_UTIL - show dependent code
PL/SQL PackageGL_CURRENCY_API - show dependent code
ViewISCBV_BACKLOGS_FCV
APPS.ISC_EDW_BACKLOGS_F_FCV is referenced by following:

SchemaAPPS
Package BodyISC_EDW_BACKLOGS_F_C - show dependent code