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

TABLE: ISC.ISC_EDW_BOOKINGS_FSTG

Object Details
Object Name: ISC_EDW_BOOKINGS_FSTG
Object Type: TABLE
Owner: ISC
FND Design Data: TableISC.ISC_EDW_BOOKINGS_FSTG
Subobject Name:
Status: VALID


This is the interface table for the Bookings fact table. Data from multiple transactional systems is staged here for verification and cleansing, before loading it into the fact table.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 5
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ISC_EDW_BOOKINGS_FSTG_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnBOOKINGS_PK
ISC_EDW_BOOKINGS_FSTG_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnCOLLECTION_STATUS
Columns
Name Datatype Length Mandatory Comments
BOOKINGS_PK VARCHAR2 (240)
Unique Identifier
AGREEMENT_TYPE_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Customer Agreement Type)
AGREEMENT_TYPE_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Customer Agreement Type)
BILL_TO_CUST_FK VARCHAR2 (320)
Foreign key to the Trading Partner dimension (Bill-to Site)
BILL_TO_CUST_FK_KEY NUMBER

System generated foreign key to the Trading Partner dimension (Bill-to Site)
BILL_TO_LOC_FK VARCHAR2 (240)
Foreign key to the Geography dimension (Bill-to Location)
BILL_TO_LOC_FK_KEY NUMBER

System generated foreign key to the Geography dimension (Bill-to Location)
CAMPAIGN_ACTL_FK VARCHAR2 (320)
Foreign key to the Campaign dimension (Campaign Actual)
CAMPAIGN_ACTL_FK_KEY NUMBER

System generated foreign key to the Campaign dimension (Campaign Actual)
CAMPAIGN_INIT_FK VARCHAR2 (320)
Foreign key to the Lookup dimension (Cancel Reason)
CAMPAIGN_INIT_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Cancel Reason)
CAMPAIGN_STATUS_ACTL_FK VARCHAR2 (320)
Foreign key to the Campaign Status dimension (Campaign Status Actual)
CAMPAIGN_STATUS_ACTL_FK_KEY NUMBER

System generated foreign key to the Campaign Status dimension (Campaign Status Actual)
CAMPAIGN_STATUS_INIT_FK VARCHAR2 (320)
Foreign key to the Campaign Status dimension (Campaign Status Attributed)
CAMPAIGN_STATUS_INIT_FK_KEY NUMBER

System generated foreign key to the Campaign Status dimension (Campaign Status Attributed)
CANCEL_REASON_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Cancel Reason)
CANCEL_REASON_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Cancel Reason)
CURRENCY_TRN_FK VARCHAR2 (240)
Foreign key to the Currency dimension (Transaction Currency)
CURRENCY_TRN_FK_KEY NUMBER

System generated foreign key to the Currency dimension (Transaction Currency)
CUSTOMER_FK VARCHAR2 (240)
Foreign key to the Trading Partner dimension (Customer)
CUSTOMER_FK_KEY NUMBER

System generated foreign key to the Trading Partner dimension (Customer)
DATE_BOOKED_FK VARCHAR2 (240)
Foreign key to the Time dimension (Date Booked)
DATE_BOOKED_FK_KEY NUMBER

System generated foreign key to the Time dimension (Date Booked)
DATE_PROMISED_FK VARCHAR2 (240)
Foreign key to the Time dimension (Date Promised)
DATE_PROMISED_FK_KEY NUMBER

System generated foreign key to the Time dimension (Date Promised)
DATE_REQUESTED_FK VARCHAR2 (240)
Foreign key to the Time dimension (Date Requested)
DATE_REQUESTED_FK_KEY NUMBER

System generated foreign key to the Time dimension (Date Requested)
DATE_SCHEDULED_FK VARCHAR2 (240)
Foreign key to the Time dimension (Date Scheduled)
DATE_SCHEDULED_FK_KEY NUMBER

System generated foreign key to the Time dimension (Date Scheduled)
DEMAND_CLASS_FK VARCHAR2 (240)
Foreign key to the Demand Class dimension
DEMAND_CLASS_FK_KEY NUMBER

System generated foreign key to the Demand Class dimension
EVENT_OFFER_ACTL_FK VARCHAR2 (240)
Foreign key to the Event dimension (Event Offer Actual)
EVENT_OFFER_ACTL_FK_KEY NUMBER

System generated foreign key to the Event dimension (Event Offer Actual)
EVENT_OFFER_INIT_FK VARCHAR2 (240)
Foreign key to the Event dimension (Event Offer Attributed)
EVENT_OFFER_INIT_FK_KEY NUMBER

System generated foreign key to the Event dimension (Event Offer Attributed)
EVENT_OFFER_REG_FK VARCHAR2 (240)
Foreign key to the Event dimension (Event Registration)
EVENT_OFFER_REG_FK_KEY NUMBER

System generated foreign key to the Event dimension (Event Registration)
INSTANCE_FK VARCHAR2 (240)
Foreign key to the Instance dimension
INSTANCE_FK_KEY NUMBER

System generated foreign key to the Instance dimension
INV_ORG_FK VARCHAR2 (240)
Foreign key to the Inventory Location dimension (Inventory Organization) from which the Items are issued
INV_ORG_FK_KEY NUMBER

System generated foreign key to the Inventory Location dimension (Inventory Organization) from which the Items are issued
ITEM_ORG_FK VARCHAR2 (320)
Foreign key to the Item dimension (Organization Item)
ITEM_ORG_FK_KEY NUMBER

System generated foreign key to the Item dimension (Organization Item)
MARKET_SEGMENT_FK VARCHAR2 (240)
Foreign key to the Market Segment dimension
MARKET_SEGMENT_FK_KEY NUMBER

System generated foreign key to the Market Segment dimension
MEDCHN_ACTL_FK VARCHAR2 (240)
Foreign key to the Media Channel dimension (Media Channel Actual)
MEDCHN_ACTL_FK_KEY NUMBER

System generated foreign key to the Media Channel dimension (Media Channel Actual)
MEDCHN_INIT_FK VARCHAR2 (240)
Foreign key to the Media Channel dimension (Media Channel Attributed)
MEDCHN_INIT_FK_KEY NUMBER

System generated foreign key to the Media Channel dimension (Media Channel Attributed)
OFFER_HDR_FK VARCHAR2 (240)
Foreign key to the Offer dimension (Header level)
OFFER_HDR_FK_KEY NUMBER

System generated foreign key to the Offer dimension (Header level)
OFFER_LINE_FK VARCHAR2 (240)
Foreign key to the Offer dimension (Line level)
OFFER_LINE_FK_KEY NUMBER

System generated foreign key to the Offer dimension (Line level)
OPERATING_UNIT_FK VARCHAR2 (240)
Foreign key to the Internal Organization dimension (Operating Unit) where the order was booked
OPERATING_UNIT_FK_KEY NUMBER

System generated foreign key to the Internal Organization dimension (Operating Unit) where the order was booked
ORDER_CATEGORY_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Sales Order Category)
ORDER_CATEGORY_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Sales Order Category)
ORDER_SOURCE_FK VARCHAR2 (240)
Foreign key to the Sales Order Source dimension
ORDER_SOURCE_FK_KEY NUMBER

System generated foreign key to the Sales Order Source dimension
ORDER_TYPE_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Sales Order Type)
ORDER_TYPE_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Sales Order Type)
RETURN_REASON_FK VARCHAR2 (240)
Foreign key to the Lookup dimension (Return Reason)
RETURN_REASON_FK_KEY NUMBER

System generated foreign key to the Lookup dimension (Return Reason)
SALES_CHANNEL_FK VARCHAR2 (240)
Foreign key to the Sales Channel dimension
SALES_CHANNEL_FK_KEY NUMBER

Reserved for future use
SALES_PERSON_FK VARCHAR2 (240)
Reserved for future use
SALES_PERSON_FK_KEY NUMBER

System generated foreign key to the Person dimension (Salesperson)
SET_OF_BOOKS_FK VARCHAR2 (240)
Foreign key to the Set of Books dimension (GL Set of Book)
SET_OF_BOOKS_FK_KEY NUMBER

System generated foreign key to the Set of Books dimension (GL Set of Book)
SHIP_TO_CUST_FK VARCHAR2 (320)
Foreign key to the Trading Partner dimension (Ship-to Site) for which the items are shipped
SHIP_TO_CUST_FK_KEY NUMBER

System generated foreign key to the Trading Partner dimension (Ship-to Site) for which the items are shipped
SHIP_TO_LOC_FK VARCHAR2 (240)
Foreign key to the Geography dimension (Ship-to Location) to which the items are shipped
SHIP_TO_LOC_FK_KEY NUMBER

System generated foreign key to the Geography dimension (Ship-to Location) to which the items are shipped
SOURCE_LIST_FK VARCHAR2 (240)
Foreign key to the Source List dimension
SOURCE_LIST_FK_KEY NUMBER

System generated foreign key to the Source List dimension
TARGET_SEGMENT_ACTL_FK VARCHAR2 (240)
Foreign key to the Target Segment dimension (Target Segment Actual)
TARGET_SEGMENT_ACTL_FK_KEY NUMBER

System generated foreign key to the Target Segment dimension (Target Segment Actual)
TARGET_SEGMENT_INIT_FK VARCHAR2 (240)
Foreign key to the Target Segment dimension (Target Segment Attributed)
TARGET_SEGMENT_INIT_FK_KEY NUMBER

System generated foreign key to the Target Segment dimension (Target Segment Attributed)
TASK_FK VARCHAR2 (240)
Foreign key to the Project dimension (Project Task)
TASK_FK_KEY NUMBER

System generated foreign key to the Project dimension (Project Task)
TOP_MODEL_FK VARCHAR2 (320)
Foreign key to the Item dimension (Top Model Organization Item) when the item is a component in a bill of material (BOM)
TOP_MODEL_FK_KEY NUMBER

System generated foreign key to the Item dimension (Top Model Organization Item) when the item is a component in a bill of material (BOM)
UOM_UOM_FK VARCHAR2 (240)
Foreign key to the UoM dimension
UOM_UOM_FK_KEY NUMBER

System generated foreign key to the UoM dimension
AGREEMENT_ID VARCHAR2 (80)
Id of the Agreement to which this order relates to
BOOKED_DATE DATE

Date Booked
COLLECTION_STATUS VARCHAR2 (40)
Collection status code for the record
CONFIGURATION_ITEM_FLAG VARCHAR2 (40)
Flag indicating if the item is part of a configuration.
CONVERSION_DATE DATE

Currency Conversion Date
CONVERSION_RATE NUMBER

Currency Conversion Rate
CONVERSION_TYPE VARCHAR2 (80)
Currency Conversion Type
CUST_PO_NUMBER VARCHAR2 (80)
Customer's Purchase Order Number
DATE_FULFILLED DATE

Date Fulfilled
DATE_LATEST_SHIP DATE

Date Latest Ship
DATE_LATEST_PICK DATE

Date Latest Pick
ERROR_CODE VARCHAR2 (2000)
Code used to store error messages
FULFILLMENT_FLAG VARCHAR2 (40)
Flag indicating if the line has been fulfilled (typically fully shipped and invoiced for shippable items, fully invoiced for non-shippable items)
HEADER_ID VARCHAR2 (80)
Sales Order Header Identifier in the source system
INCLUDED_ITEM_FLAG VARCHAR2 (40)
Used as invoiceable_flag. Future realeases will have a new column for invoiceable_flag.This flag is set to "Y" if the sales order line is not : Internal, an "INCLUDED" item, and the invoiceable flag for this item = "Y"
INSTANCE VARCHAR2 (40)
Instance
ITEM_TYPE_CODE VARCHAR2 (80)
Code for the item type : STANDARD, CONFIG, KIT, MODEL, CLASS, OPTION, INCLUDED, SERVICE)
LAST_UPDATE_DATE DATE

Standard Who column
LINE_DETAIL_ID VARCHAR2 (80)
Sales Order Line Details Identifier in the source system
LINE_ID VARCHAR2 (80)
Sales Order Line Identifier in the source system
PRICE_LIST_ID VARCHAR2 (80)
Id of the Price List from which the List Price was issued
OPERATION_CODE VARCHAR2 (40)
Code used by the collection program to determine whether to insert/update/delete this record
ORDER_NUMBER VARCHAR2 (80)
Sales Order Number in the source system
ORDERED_DATE DATE

Date Ordered
PROMISED_DATE DATE

Date Promised
QTY_CANCELLED NUMBER

Quantity Canceled
QTY_FULFILLED NUMBER

Quantity Fulfilled
QTY_INVOICED NUMBER

Quantity Invoiced
QTY_SHIPPED NUMBER

Quantity Shipped
QTY_ORDERED NUMBER

Quantity Ordered
QTY_RESERVED NUMBER

Quantity Reserved
QTY_RETURNED NUMBER

Quantity Returned
REQUEST_ID NUMBER

Identifier used by collection program
REQUESTED_DATE DATE

Date Requested
ROW_ID ROWID (10)
Row Id
SCHEDULED_DATE DATE

Date Scheduled
SHIPPABLE_FLAG VARCHAR2 (40)
Shippable Flag
TOTAL_NET_ORDER_VALUE NUMBER

Total net value for the entire order (non additive across lines of the same order)
TRANSACTABLE_FLAG VARCHAR2 (40)
Reserved for future use
UNIT_COST_G NUMBER

Unit Cost in Warehouse currency
UNIT_COST_T NUMBER

Unit Cost in Transaction currency
UNIT_LIST_PRC_G NUMBER

Unit List Price in Warehouse currency
UNIT_LIST_PRC_T NUMBER

Unit List Price in Transaction currency
UNIT_SELL_PRC_G NUMBER

Unit Sell Price in Warehouse Currency
UNIT_SELL_PRC_T NUMBER

Unit Sell Price in Transaction Currency
USER_ATTRIBUTE1 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE2 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE3 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE4 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE5 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE6 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE7 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE8 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE9 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE10 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE11 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE12 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE13 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE14 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE15 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE16 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE17 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE18 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE19 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE20 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE21 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE22 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE23 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE24 VARCHAR2 (240)
User defined attribute
USER_ATTRIBUTE25 VARCHAR2 (240)
User defined attribute
USER_FK1_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK2_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK3_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK4_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK5_KEY NUMBER

System generated foreign key to user defined dimension
USER_FK1 VARCHAR2 (240)
Foreign Key to user defined dimension
USER_FK2 VARCHAR2 (240)
Foreign Key to user defined dimension
USER_FK3 VARCHAR2 (240)
Foreign Key to user defined dimension
USER_FK4 VARCHAR2 (240)
Foreign Key to user defined dimension
USER_FK5 VARCHAR2 (240)
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
SALES_RESOURCE_FK_KEY NUMBER

System generated foreign key for Sales Resource
SALES_RESOURCE_FK VARCHAR2 (240)
Foreign key for Sales Resource
Query Text

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


SELECT BOOKINGS_PK
,      AGREEMENT_TYPE_FK
,      AGREEMENT_TYPE_FK_KEY
,      BILL_TO_CUST_FK
,      BILL_TO_CUST_FK_KEY
,      BILL_TO_LOC_FK
,      BILL_TO_LOC_FK_KEY
,      CAMPAIGN_ACTL_FK
,      CAMPAIGN_ACTL_FK_KEY
,      CAMPAIGN_INIT_FK
,      CAMPAIGN_INIT_FK_KEY
,      CAMPAIGN_STATUS_ACTL_FK
,      CAMPAIGN_STATUS_ACTL_FK_KEY
,      CAMPAIGN_STATUS_INIT_FK
,      CAMPAIGN_STATUS_INIT_FK_KEY
,      CANCEL_REASON_FK
,      CANCEL_REASON_FK_KEY
,      CURRENCY_TRN_FK
,      CURRENCY_TRN_FK_KEY
,      CUSTOMER_FK
,      CUSTOMER_FK_KEY
,      DATE_BOOKED_FK
,      DATE_BOOKED_FK_KEY
,      DATE_PROMISED_FK
,      DATE_PROMISED_FK_KEY
,      DATE_REQUESTED_FK
,      DATE_REQUESTED_FK_KEY
,      DATE_SCHEDULED_FK
,      DATE_SCHEDULED_FK_KEY
,      DEMAND_CLASS_FK
,      DEMAND_CLASS_FK_KEY
,      EVENT_OFFER_ACTL_FK
,      EVENT_OFFER_ACTL_FK_KEY
,      EVENT_OFFER_INIT_FK
,      EVENT_OFFER_INIT_FK_KEY
,      EVENT_OFFER_REG_FK
,      EVENT_OFFER_REG_FK_KEY
,      INSTANCE_FK
,      INSTANCE_FK_KEY
,      INV_ORG_FK
,      INV_ORG_FK_KEY
,      ITEM_ORG_FK
,      ITEM_ORG_FK_KEY
,      MARKET_SEGMENT_FK
,      MARKET_SEGMENT_FK_KEY
,      MEDCHN_ACTL_FK
,      MEDCHN_ACTL_FK_KEY
,      MEDCHN_INIT_FK
,      MEDCHN_INIT_FK_KEY
,      OFFER_HDR_FK
,      OFFER_HDR_FK_KEY
,      OFFER_LINE_FK
,      OFFER_LINE_FK_KEY
,      OPERATING_UNIT_FK
,      OPERATING_UNIT_FK_KEY
,      ORDER_CATEGORY_FK
,      ORDER_CATEGORY_FK_KEY
,      ORDER_SOURCE_FK
,      ORDER_SOURCE_FK_KEY
,      ORDER_TYPE_FK
,      ORDER_TYPE_FK_KEY
,      RETURN_REASON_FK
,      RETURN_REASON_FK_KEY
,      SALES_CHANNEL_FK
,      SALES_CHANNEL_FK_KEY
,      SALES_PERSON_FK
,      SALES_PERSON_FK_KEY
,      SET_OF_BOOKS_FK
,      SET_OF_BOOKS_FK_KEY
,      SHIP_TO_CUST_FK
,      SHIP_TO_CUST_FK_KEY
,      SHIP_TO_LOC_FK
,      SHIP_TO_LOC_FK_KEY
,      SOURCE_LIST_FK
,      SOURCE_LIST_FK_KEY
,      TARGET_SEGMENT_ACTL_FK
,      TARGET_SEGMENT_ACTL_FK_KEY
,      TARGET_SEGMENT_INIT_FK
,      TARGET_SEGMENT_INIT_FK_KEY
,      TASK_FK
,      TASK_FK_KEY
,      TOP_MODEL_FK
,      TOP_MODEL_FK_KEY
,      UOM_UOM_FK
,      UOM_UOM_FK_KEY
,      AGREEMENT_ID
,      BOOKED_DATE
,      COLLECTION_STATUS
,      CONFIGURATION_ITEM_FLAG
,      CONVERSION_DATE
,      CONVERSION_RATE
,      CONVERSION_TYPE
,      CUST_PO_NUMBER
,      DATE_FULFILLED
,      DATE_LATEST_SHIP
,      DATE_LATEST_PICK
,      ERROR_CODE
,      FULFILLMENT_FLAG
,      HEADER_ID
,      INCLUDED_ITEM_FLAG
,      INSTANCE
,      ITEM_TYPE_CODE
,      LAST_UPDATE_DATE
,      LINE_DETAIL_ID
,      LINE_ID
,      PRICE_LIST_ID
,      OPERATION_CODE
,      ORDER_NUMBER
,      ORDERED_DATE
,      PROMISED_DATE
,      QTY_CANCELLED
,      QTY_FULFILLED
,      QTY_INVOICED
,      QTY_SHIPPED
,      QTY_ORDERED
,      QTY_RESERVED
,      QTY_RETURNED
,      REQUEST_ID
,      REQUESTED_DATE
,      ROW_ID
,      SCHEDULED_DATE
,      SHIPPABLE_FLAG
,      TOTAL_NET_ORDER_VALUE
,      TRANSACTABLE_FLAG
,      UNIT_COST_G
,      UNIT_COST_T
,      UNIT_LIST_PRC_G
,      UNIT_LIST_PRC_T
,      UNIT_SELL_PRC_G
,      UNIT_SELL_PRC_T
,      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_KEY
,      USER_FK2_KEY
,      USER_FK3_KEY
,      USER_FK4_KEY
,      USER_FK5_KEY
,      USER_FK1
,      USER_FK2
,      USER_FK3
,      USER_FK4
,      USER_FK5
,      USER_MEASURE1
,      USER_MEASURE2
,      USER_MEASURE3
,      USER_MEASURE4
,      USER_MEASURE5
,      SALES_RESOURCE_FK_KEY
,      SALES_RESOURCE_FK
FROM ISC.ISC_EDW_BOOKINGS_FSTG;

Dependencies

[top of page]

ISC.ISC_EDW_BOOKINGS_FSTG does not reference any database object

ISC.ISC_EDW_BOOKINGS_FSTG is referenced by following:

SchemaAPPS
SynonymISC_EDW_BOOKINGS_FSTG