[Home] [Help] [Dependency Information]
Object Name: | ISC_BOOK_SUM2_PDUE_F |
---|---|
Object Type: | TABLE |
Owner: | ISC |
Subobject Name: | |
Status: | VALID |
Base summary table for past due information on the Shipping Management page. This table stores current past due quantity and days late according to the scheduled shipment date. It stores the information in snapshots at the line level.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 30 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ISC_BOOK_SUM2_PDUE_F_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | CUSTOMER_ID |
ISC_BOOK_SUM2_PDUE_F_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | SOLD_TO_ORG_ID |
ISC_BOOK_SUM2_PDUE_F_N3 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | SHIP_TO_ORG_ID |
ISC_BOOK_SUM2_PDUE_F_N4 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | LINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOMER_ID | NUMBER | Customer Identifier | ||
INV_ORG_ID | NUMBER | Inventory Organization Identifier | ||
INVENTORY_ITEM_ID | NUMBER | Inventory Item ID | ||
TIME_BOOKED_DATE_ID | DATE | Indicates the date when the order was booked | ||
TIME_SNAPSHOT_DATE_ID | DATE | Date on which the snapshot was taken | ||
DAYS_LATE | NUMBER | Count of Days Late (to schedule) | ||
HEADER_ID | NUMBER | Order Header Identifier | ||
ORDER_NUMBER | NUMBER | User-visible number of the order | ||
PDUE_QTY | NUMBER | Past Due Quantity | ||
UOM | VARCHAR2 | (30) | Unit Of Measure Code | |
LINE_NUMBER | VARCHAR2 | (240) | Line sequence number within the order | |
PDUE_LINE_CNT | NUMBER | Count of Lines Past Due Schedule | ||
SOLD_TO_ORG_ID | NUMBER | Sold to Organization ID | ||
SHIP_TO_ORG_ID | NUMBER | Ship to Organization ID | ||
LINE_ID | NUMBER | Line ID |
Cut, paste (and edit) the following text to query this object:
SELECT CUSTOMER_ID
, INV_ORG_ID
, INVENTORY_ITEM_ID
, TIME_BOOKED_DATE_ID
, TIME_SNAPSHOT_DATE_ID
, DAYS_LATE
, HEADER_ID
, ORDER_NUMBER
, PDUE_QTY
, UOM
, LINE_NUMBER
, PDUE_LINE_CNT
, SOLD_TO_ORG_ID
, SHIP_TO_ORG_ID
, LINE_ID
FROM ISC.ISC_BOOK_SUM2_PDUE_F;
ISC.ISC_BOOK_SUM2_PDUE_F does not reference any database object
ISC.ISC_BOOK_SUM2_PDUE_F is referenced by following:
|
|
|