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

VIEW: APPS.ISCBV_BACKLOGS_FCV

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

View Type

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


This view is used by the Backlog Snapshot collection program to group by dimension rows retrieved by the ISCBV_BACKLOGS_BASE_FCV view.


[View Source]

Columns
Name Datatype Length Mandatory Comments
SEQ_ID NUMBER

Sequence id used by the collection program
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)
INSTANCE VARCHAR2 (30)
Source instance
LAST_UPDATE_DATE DATE

Standard Who column
BILL_BKLG_MRG_T NUMBER

Billing Backlog Gross Margin in Transaction Currency
SHIP_BKLG_MRG_T NUMBER

Shipping Backlog Gross Margin in Transaction Currency
DLQT_BKLG_MRG_T NUMBER

Delinquent Backlog Gross Margin in Transaction Currency
BILL_BKLG_REV_T NUMBER

Billing Backlog Revenue in Transaction Currency
SHIP_BKLG_REV_T NUMBER

Shipping Backlog Revenue in Transaction Currency
DLQT_BKLG_REV_T NUMBER

Delinquent Backlog Revenue in Transaction Currency
BILL_BKLG_COST_T NUMBER

Billing Backlog Cost in Transaction Currency
SHIP_BKLG_COST_T NUMBER

Shipping Backlog Cost in Transaction Currency
DLQT_BKLG_COST_T NUMBER

Delinquent Backlog Cost in Transaction Currency
BILL_BKLG_MRG_G NUMBER

Billing Backlog Gross Margin in Warehouse Currency
SHIP_BKLG_MRG_G NUMBER

Shipping Backlog Gross Margin in Warehouse Currency
DLQT_BKLG_MRG_G NUMBER

Delinquent Backlog Gross Margin in Warehouse Currency
BILL_BKLG_REV_G NUMBER

Billing Backlog Revenue in Warehouse Currency
SHIP_BKLG_REV_G NUMBER

Shipping Backlog Revenue in Warehouse Currency
DLQT_BKLG_REV_G NUMBER

Delinquent Backlog Revenue in Warehouse Currency
BILL_BKLG_COST_G NUMBER

Billing Backlog Cost in Warehouse Currency
SHIP_BKLG_COST_G NUMBER

Shipping Backlog Cost in Warehouse Currency
DLQT_BKLG_COST_G NUMBER

Delinquent Backlog Cost in Warehouse Currency
QTY_BILL_BKLG_B NUMBER

Billing Backlog Quantity
QTY_SHIP_BKLG_B NUMBER

Shipping Backlog Quantity
QTY_DLQT_BKLG_B NUMBER

Delinquent Backlog Quantity
QTY_UNBILL_SHIP_B NUMBER

Unbilled Shipments Backlog Quantity
UNBILL_SHIP_REV_T NUMBER

Unbilled Shipments Revenue in Transaction Currency
UNBILL_SHIP_REV_G NUMBER

Unbilled Shipments Revenue in Warehouse Currency
UNBILL_SHIP_COST_T NUMBER

Unbilled Shipments Cost in Transaction Currency
UNBILL_SHIP_COST_G NUMBER

Unbilled Shipments Cost in Warehouse Currency
UNBILL_SHIP_MRG_T NUMBER

Unbilled Shipments Gross Margin in Transaction Currency
UNBILL_SHIP_MRG_G NUMBER

Unbilled Shipments Gross Margin in Warehouse Currency
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 VARCHAR2 (0)
Foreign key to user defined dimension
USER_FK2 VARCHAR2 (0)
Foreign key to user defined dimension
USER_FK3 VARCHAR2 (0)
Foreign key to user defined dimension
USER_FK4 VARCHAR2 (0)
Foreign key to user defined dimension
USER_FK5 VARCHAR2 (0)
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 SEQ_ID
,      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
,      INSTANCE
,      LAST_UPDATE_DATE
,      BILL_BKLG_MRG_T
,      SHIP_BKLG_MRG_T
,      DLQT_BKLG_MRG_T
,      BILL_BKLG_REV_T
,      SHIP_BKLG_REV_T
,      DLQT_BKLG_REV_T
,      BILL_BKLG_COST_T
,      SHIP_BKLG_COST_T
,      DLQT_BKLG_COST_T
,      BILL_BKLG_MRG_G
,      SHIP_BKLG_MRG_G
,      DLQT_BKLG_MRG_G
,      BILL_BKLG_REV_G
,      SHIP_BKLG_REV_G
,      DLQT_BKLG_REV_G
,      BILL_BKLG_COST_G
,      SHIP_BKLG_COST_G
,      DLQT_BKLG_COST_G
,      QTY_BILL_BKLG_B
,      QTY_SHIP_BKLG_B
,      QTY_DLQT_BKLG_B
,      QTY_UNBILL_SHIP_B
,      UNBILL_SHIP_REV_T
,      UNBILL_SHIP_REV_G
,      UNBILL_SHIP_COST_T
,      UNBILL_SHIP_COST_G
,      UNBILL_SHIP_MRG_T
,      UNBILL_SHIP_MRG_G
,      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.ISCBV_BACKLOGS_FCV;

Dependencies

[top of page]

APPS.ISCBV_BACKLOGS_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_BASE_FCV
APPS.ISCBV_BACKLOGS_FCV is referenced by following:

SchemaAPPS
ViewISC_EDW_BACKLOGS_F_FCV