eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.ISCBV_BACKLOGS_FCV

Source

View Text - Preformatted


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, MAX(LAST_UPDATE_DATE) LAST_UPDATE_DATE, SUM(BILL_BKLG_MRG_T) BILL_BKLG_MRG_T, SUM(SHIP_BKLG_MRG_T) SHIP_BKLG_MRG_T, SUM(DLQT_BKLG_MRG_T) DLQT_BKLG_MRG_T, SUM(BILL_BKLG_REV_T) BILL_BKLG_REV_T, SUM(SHIP_BKLG_REV_T) SHIP_BKLG_REV_T, SUM(DLQT_BKLG_REV_T) DLQT_BKLG_REV_T, SUM(BILL_BKLG_COST_T) BILL_BKLG_COST_T, SUM(SHIP_BKLG_COST_T) SHIP_BKLG_COST_T, SUM(DLQT_BKLG_COST_T) DLQT_BKLG_COST_T, SUM(BILL_BKLG_MRG_G) BILL_BKLG_MRG_G, SUM(SHIP_BKLG_MRG_G) SHIP_BKLG_MRG_G, SUM(DLQT_BKLG_MRG_G) DLQT_BKLG_MRG_G, SUM(BILL_BKLG_REV_G) BILL_BKLG_REV_G, SUM(SHIP_BKLG_REV_G) SHIP_BKLG_REV_G, SUM(DLQT_BKLG_REV_G) DLQT_BKLG_REV_G, SUM(BILL_BKLG_COST_G) BILL_BKLG_COST_G, SUM(SHIP_BKLG_COST_G) SHIP_BKLG_COST_G, SUM(DLQT_BKLG_COST_G) DLQT_BKLG_COST_G, SUM(QTY_BILL_BKLG_B) QTY_BILL_BKLG_B, SUM(QTY_SHIP_BKLG_B) QTY_SHIP_BKLG_B, SUM(QTY_DLQT_BKLG_B) QTY_DLQT_BKLG_B, SUM(QTY_UNBILL_SHIP_B) QTY_UNBILL_SHIP_B, SUM(UNBILL_SHIP_REV_T) UNBILL_SHIP_REV_T, SUM(UNBILL_SHIP_REV_G) UNBILL_SHIP_REV_G, SUM(UNBILL_SHIP_COST_T) UNBILL_SHIP_COST_T, SUM(UNBILL_SHIP_COST_G) UNBILL_SHIP_COST_G, SUM(UNBILL_SHIP_MRG_T) UNBILL_SHIP_MRG_T, SUM(UNBILL_SHIP_MRG_G) 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, SUM(USER_MEASURE1) USER_MEASURE1, SUM(USER_MEASURE2) USER_MEASURE2, SUM(USER_MEASURE3) USER_MEASURE3, SUM(USER_MEASURE4) USER_MEASURE4, SUM(USER_MEASURE5) USER_MEASURE5 from ISCBV_BACKLOGS_BASE_FCV WHERE (BILL_BKLG_REV_T <> 0 or SHIP_BKLG_REV_T <> 0 or DLQT_BKLG_REV_T <> 0 or UNBILL_SHIP_REV_T <> 0 or BILL_BKLG_COST_T <> 0 or SHIP_BKLG_COST_T <> 0 or DLQT_BKLG_COST_T <> 0 or UNBILL_SHIP_COST_T <> 0 or QTY_BILL_BKLG_B <> 0 or QTY_SHIP_BKLG_B <> 0 or QTY_DLQT_BKLG_B <> 0 or QTY_UNBILL_SHIP_B <> 0 ) group by SEQ_ID, BACKLOGS_PK, BILL_TO_LOCATION_FK, SHIP_TO_LOCATION_FK, DATE_BALANCE_FK, INSTANCE, INSTANCE_FK, TOP_MODEL_ITEM_FK, ITEM_ORG_FK, BASE_UOM_FK, OPERATING_UNIT_FK, CUSTOMER_FK, SALES_CHANNEL_FK, SALES_PERSON_FK, TASK_FK, INV_ORG_FK, BILL_TO_CUST_FK, SHIP_TO_CUST_FK, DEMAND_CLASS_FK, TRX_CURRENCY_FK, ORDER_CATEGORY_FK, ORDER_TYPE_FK, ORDER_SOURCE_FK, GL_BOOK_FK, 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

View Text - HTML Formatted

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
, MAX(LAST_UPDATE_DATE) LAST_UPDATE_DATE
, SUM(BILL_BKLG_MRG_T) BILL_BKLG_MRG_T
, SUM(SHIP_BKLG_MRG_T) SHIP_BKLG_MRG_T
, SUM(DLQT_BKLG_MRG_T) DLQT_BKLG_MRG_T
, SUM(BILL_BKLG_REV_T) BILL_BKLG_REV_T
, SUM(SHIP_BKLG_REV_T) SHIP_BKLG_REV_T
, SUM(DLQT_BKLG_REV_T) DLQT_BKLG_REV_T
, SUM(BILL_BKLG_COST_T) BILL_BKLG_COST_T
, SUM(SHIP_BKLG_COST_T) SHIP_BKLG_COST_T
, SUM(DLQT_BKLG_COST_T) DLQT_BKLG_COST_T
, SUM(BILL_BKLG_MRG_G) BILL_BKLG_MRG_G
, SUM(SHIP_BKLG_MRG_G) SHIP_BKLG_MRG_G
, SUM(DLQT_BKLG_MRG_G) DLQT_BKLG_MRG_G
, SUM(BILL_BKLG_REV_G) BILL_BKLG_REV_G
, SUM(SHIP_BKLG_REV_G) SHIP_BKLG_REV_G
, SUM(DLQT_BKLG_REV_G) DLQT_BKLG_REV_G
, SUM(BILL_BKLG_COST_G) BILL_BKLG_COST_G
, SUM(SHIP_BKLG_COST_G) SHIP_BKLG_COST_G
, SUM(DLQT_BKLG_COST_G) DLQT_BKLG_COST_G
, SUM(QTY_BILL_BKLG_B) QTY_BILL_BKLG_B
, SUM(QTY_SHIP_BKLG_B) QTY_SHIP_BKLG_B
, SUM(QTY_DLQT_BKLG_B) QTY_DLQT_BKLG_B
, SUM(QTY_UNBILL_SHIP_B) QTY_UNBILL_SHIP_B
, SUM(UNBILL_SHIP_REV_T) UNBILL_SHIP_REV_T
, SUM(UNBILL_SHIP_REV_G) UNBILL_SHIP_REV_G
, SUM(UNBILL_SHIP_COST_T) UNBILL_SHIP_COST_T
, SUM(UNBILL_SHIP_COST_G) UNBILL_SHIP_COST_G
, SUM(UNBILL_SHIP_MRG_T) UNBILL_SHIP_MRG_T
, SUM(UNBILL_SHIP_MRG_G) 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
, SUM(USER_MEASURE1) USER_MEASURE1
, SUM(USER_MEASURE2) USER_MEASURE2
, SUM(USER_MEASURE3) USER_MEASURE3
, SUM(USER_MEASURE4) USER_MEASURE4
, SUM(USER_MEASURE5) USER_MEASURE5
FROM ISCBV_BACKLOGS_BASE_FCV
WHERE (BILL_BKLG_REV_T <> 0 OR SHIP_BKLG_REV_T <> 0 OR DLQT_BKLG_REV_T <> 0 OR UNBILL_SHIP_REV_T <> 0 OR BILL_BKLG_COST_T <> 0 OR SHIP_BKLG_COST_T <> 0 OR DLQT_BKLG_COST_T <> 0 OR UNBILL_SHIP_COST_T <> 0 OR QTY_BILL_BKLG_B <> 0 OR QTY_SHIP_BKLG_B <> 0 OR QTY_DLQT_BKLG_B <> 0 OR QTY_UNBILL_SHIP_B <> 0 ) GROUP BY SEQ_ID
, BACKLOGS_PK
, BILL_TO_LOCATION_FK
, SHIP_TO_LOCATION_FK
, DATE_BALANCE_FK
, INSTANCE
, INSTANCE_FK
, TOP_MODEL_ITEM_FK
, ITEM_ORG_FK
, BASE_UOM_FK
, OPERATING_UNIT_FK
, CUSTOMER_FK
, SALES_CHANNEL_FK
, SALES_PERSON_FK
, TASK_FK
, INV_ORG_FK
, BILL_TO_CUST_FK
, SHIP_TO_CUST_FK
, DEMAND_CLASS_FK
, TRX_CURRENCY_FK
, ORDER_CATEGORY_FK
, ORDER_TYPE_FK
, ORDER_SOURCE_FK
, GL_BOOK_FK
, 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