[Home] [Help] [Dependency Information]
Object Name: | ISC_EDW_BACKLOGS_F_FCV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ISC.ISC_EDW_BACKLOGS_F_FCV |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
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;
|
|
|