[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ISC_BOOK_SUM2_F |
|---|---|
| Object Type: | TABLE |
| Owner: | ISC |
| Subobject Name: | |
| Status: | VALID |
Base summary table for the Customer Fulfillment Management page and Shipping Management page. It is built on the OE_ORDER_LINES_ALL table. It contains the following dimensions: header functional currency, organization functional currency, customer, item, organization, return reason, and time. It contains the following amounts in the global (primary and secondary) currency and organization functional currency: backlog value, booked value at selling price, booked value at list price, fulfilled value, invoice value, return value, and shipped value, among other line-level information.
| Tablespace: |  APPS_TS_SUMMARY |
|---|---|
| PCT Free: | 30 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| ISC_BOOK_SUM2_F_U1 | NORMAL | UNIQUE |
APPS_TS_SUMMARY
|
 LINE_ID
|
| ISC_BOOK_SUM2_F_N1 | NORMAL | NONUNIQUE |
APPS_TS_SUMMARY
|
TIME_BOOKED_DATE_ID
|
| ISC_BOOK_SUM2_F_N2 | NORMAL | NONUNIQUE |
APPS_TS_SUMMARY
|
CUSTOMER_ID
|
| ISC_BOOK_SUM2_F_N3 | NORMAL | NONUNIQUE |
APPS_TS_SUMMARY
|
ITEM_INV_ORG_ID
INVENTORY_ITEM_ID
|
| ISC_BOOK_SUM2_F_N4 | NORMAL | NONUNIQUE |
APPS_TS_SUMMARY
|
SHIP_TO_PARTY_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LINE_ID | NUMBER | System Generated Line Identifier | ||
| CURRENCY_FUNC_ID | VARCHAR2 | (30) | Functional currency identifier | |
| CURR_WH_FUNC_ID | VARCHAR2 | (30) | Warehouse Functional currency identifier | |
| CUSTOMER_ID | NUMBER | Customer Identifier | ||
| INVENTORY_ITEM_ID | NUMBER | Inventory Item Identifier | ||
| INV_ORG_ID | NUMBER | Inventory Organization Identifier | ||
| INV_OU_ID | NUMBER | Operating Unit Identifier | ||
| ITEM_ID | NUMBER | Inventory Item Identifier | ||
| ITEM_INV_ORG_ID | NUMBER | Inventory Organization Identifier | ||
| ORDER_CATEGORY_ID | VARCHAR2 | (80) | Indicates whether the line is regular or return | |
| ORDER_SOURCE_ID | VARCHAR2 | (80) | Source of order line | |
| ORDER_TYPE_ID | VARCHAR2 | (80) | Order Transaction Type Identifier | |
| ORG_OU_ID | NUMBER | perating Unit which performed this transaction | ||
| RETURN_REASON_ID | VARCHAR2 | (80) | Order Item Return Reason Identifier | |
| SALES_CHANNEL_ID | VARCHAR2 | (80) | Sales channel through which order was placed | |
| TIME_ACT_SHIP_DATE_ID | DATE | Actual Shipment (truncated) Date of the line | ||
| TIME_BOOKED_DATE_ID | DATE | Indicates the (truncated) date when the order was booked | ||
| TIME_FULFILLED_DATE_ID | DATE | Fulfillment (truncated) Date for the Line | ||
| TIME_ORDERED_DATE_ID | DATE | Indicates the (truncated) date when the order was entered | ||
| TIME_PROMISE_DATE_ID | DATE | Date (truncated) promised to customer to receive item | ||
| TIME_REQUEST_DATE_ID | DATE | Ordered Item Request (truncated) date | ||
| TIME_SCHEDULE_DATE_ID | DATE | Date (truncated) Scheduled to ship item | ||
| TIME_SHIPPED_DATE_ID | DATE | Actual Shipment (truncated) Date of the line | ||
| TOP_MODEL_ITEM_ID | NUMBER | Inventory Item Identifier (of Top Model) | ||
| TOP_MODEL_ORG_ID | NUMBER | Inventory Organization Identifier (of Top Model) | ||
| ACTUAL_SHIPMENT_DATE | DATE | Actual Shipment Date of the line | ||
| ATO_LINE_ID | NUMBER | System-generated identifier if ATO configuration top model line | ||
| BOOKED_AMT_F | NUMBER | Booked amount in Functional currency | ||
| BOOKED_AMT_F1 | NUMBER | Booked amount in Warehouse Functional currency | ||
| BOOKED_AMT_G | NUMBER | Booked amount in Global currency | ||
| BOOKED_QTY_INV | NUMBER | Booked Quantity | ||
| BOOKED_DATE | DATE | Indicates the date when the order was booked | ||
| BOOKED_LIST_AMT_F | NUMBER | Booked list amount in Functional currency | ||
| BOOKED_LIST_AMT_F1 | NUMBER | Booked list amount in Warehouse Functional currency | ||
| BOOKED_LIST_AMT_G | NUMBER | Booked list amount in Global currency | ||
| COUNT_PDUE_LINE | NUMBER | Indicates whether the line is past due (1) or not (0) | ||
| COUNT_SHIP_LINE | NUMBER | Indicates whether the line is shipped (1) or not (0) | ||
| FLOW_STATUS_CODE | VARCHAR2 | (80) | Workflow status for the line | |
| FULFILLED_AMT_F | NUMBER | Fulfilled amount in Functional currency | ||
| FULFILLED_AMT_F1 | NUMBER | Fulfilled amount in Warehouse Functional currency | ||
| FULFILLED_AMT_G | NUMBER | Fulfilled amount in Global currency | ||
| FULFILLED_QTY_INV | NUMBER | Fulfilled Quantity | ||
| FULFILLED_DATE | DATE | Fulfillment Date for the Line | ||
| FULFILLED_FLAG | VARCHAR2 | (30) | Fulfilled Flag to indicate whether the line has been fulfilled. | |
| HEADER_ID | NUMBER | Order Header Identifier | ||
| H_MARKETING_SOURCE_CODE_ID | NUMBER | Marketing Source Code Identifier | ||
| INVOICED_AMT_F | NUMBER | Invoiced amount in Functional currency | ||
| INVOICED_AMT_F1 | NUMBER | Invoiced amount in Warehouse Functional currency | ||
| INVOICED_AMT_G | NUMBER | Invoiced amount in Global currency | ||
| INVOICED_QTY_INV | NUMBER | Invoiced Quantity | ||
| INVOICE_TO_ORG_ID | NUMBER | Invoice To Organization ID | ||
| ITEM_TYPE_CODE | VARCHAR2 | (80) | Type of item | |
| LINE_CATEGORY_CODE | VARCHAR2 | (80) | Indicates whether the line is regular or return | |
| LINE_ITEM_TYPE | NUMBER | Specifies if the order line is an ATO or not | ||
| LINE_NUMBER | VARCHAR2 | (240) | Line sequence number within the order | |
| MARKETING_SOURCE_CODE_ID | NUMBER | Marketing source code identifier. | ||
| OPEN_FLAG | VARCHAR2 | (1) | Indicates whether the line has been closed (N) or not (Y) | |
| ORDERED_DATE | DATE | Date on which the order was placed | ||
| ORDERED_QUANTITY | NUMBER | Ordered Quantity | ||
| ORDER_DATE_TYPE_CODE | VARCHAR2 | (80) | Order Date Type Code | |
| ORDER_NUMBER | NUMBER | User-visible number of the order | ||
| ORDER_QUANTITY_UOM | VARCHAR2 | (30) | Ordered Quantity | |
| INV_UOM_CODE | VARCHAR2 | (30) | Unit Of Measure Code | |
| PROMISE_DATE | DATE | Date promised to customer to receive item | ||
| REQUEST_DATE | DATE | Ordered Item Request date | ||
| SCHEDULE_SHIP_DATE | DATE | Date Scheduled to ship item | ||
| SHIPPABLE_FLAG | VARCHAR2 | (30) | Flag indicating if order line is capable of being shipped | |
| SHIPPED_AMT_F | NUMBER | Shipped amount in Functional currency | ||
| SHIPPED_AMT_F1 | NUMBER | Shipped amount in Warehouse Functional currency | ||
| SHIPPED_AMT_G | NUMBER | Shipped amount in Global currency | ||
| SHIPPED_QTY_INV | NUMBER | Shipped Quantity | ||
| SHIPPED_DATE | DATE | Actual Shipment Date of the line | ||
| TOP_MODEL_LINE_ID | NUMBER | System Generated Line Identifier (of Top Model) | ||
| UNIT_LIST_PRICE | NUMBER | Price List price for the item | ||
| UNIT_SELLING_PRICE | NUMBER | Actual price charged to customer | ||
| CREATED_BY | NUMBER | Standard Who column | ||
| CREATION_DATE | DATE | Standard Who column | ||
| LAST_UPDATED_BY | NUMBER | Standard Who column | ||
| LAST_UPDATE_DATE | DATE | Standard Who column | ||
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| SERVICE_PARENT_LINE_ID | NUMBER | System Generated Line Identifier (of service line parent) | ||
| SHIP_TO_PARTY_ID | NUMBER | Identifier for the party | ||
| BOOKED_AMT_G1 | NUMBER | Booked amount in Secondary Global currency | ||
| BOOKED_LIST_AMT_G1 | NUMBER | Booked list amount in Secondary Global currency | ||
| FULFILLED_AMT_G1 | NUMBER | Fulfilled amount in Secondary Global currency | ||
| INVOICED_AMT_G1 | NUMBER | Invoiced amount in Secondary Global currency | ||
| SHIPPED_AMT_G1 | NUMBER | Shipped amount in Secondary Global currency | ||
| SHIP_TO_ORG_ID | NUMBER | Ship to Organization ID | ||
| SOLD_TO_ORG_ID | NUMBER | Sold to Organization ID | ||
| FREIGHT_CHARGE | NUMBER | Freight Charge amount in Transactional currency | ||
| FREIGHT_CHARGE_F | NUMBER | Freight Charge amount in Functional currency | ||
| FREIGHT_CHARGE_G | NUMBER | Freight Charge amount in Global currency | ||
| FREIGHT_CHARGE_G1 | NUMBER | Freight Charge amount in Secondary Global currency | ||
| FREIGHT_COST | NUMBER | Freight Cost amount in Transactional currency | ||
| FREIGHT_COST_F | NUMBER | Freight Cost amount in Functional currency | ||
| FREIGHT_COST_G | NUMBER | Freight Cost amount in Global currency | ||
| FREIGHT_COST_G1 | NUMBER | Freight Cost amount in Secondary Global currency | ||
| CHARGE_PERIODICITY_CODE | VARCHAR2 | (30) | Charge periodicity code for recurring charges | |
| BLANKET_NUMBER | NUMBER | Blanket Sales Agreement Number | ||
| BLANKET_LINE_NUMBER | NUMBER | Blanket Sales Agreement Line Number |
Cut, paste (and edit) the following text to query this object:
SELECT LINE_ID
, CURRENCY_FUNC_ID
, CURR_WH_FUNC_ID
, CUSTOMER_ID
, INVENTORY_ITEM_ID
, INV_ORG_ID
, INV_OU_ID
, ITEM_ID
, ITEM_INV_ORG_ID
, ORDER_CATEGORY_ID
, ORDER_SOURCE_ID
, ORDER_TYPE_ID
, ORG_OU_ID
, RETURN_REASON_ID
, SALES_CHANNEL_ID
, TIME_ACT_SHIP_DATE_ID
, TIME_BOOKED_DATE_ID
, TIME_FULFILLED_DATE_ID
, TIME_ORDERED_DATE_ID
, TIME_PROMISE_DATE_ID
, TIME_REQUEST_DATE_ID
, TIME_SCHEDULE_DATE_ID
, TIME_SHIPPED_DATE_ID
, TOP_MODEL_ITEM_ID
, TOP_MODEL_ORG_ID
, ACTUAL_SHIPMENT_DATE
, ATO_LINE_ID
, BOOKED_AMT_F
, BOOKED_AMT_F1
, BOOKED_AMT_G
, BOOKED_QTY_INV
, BOOKED_DATE
, BOOKED_LIST_AMT_F
, BOOKED_LIST_AMT_F1
, BOOKED_LIST_AMT_G
, COUNT_PDUE_LINE
, COUNT_SHIP_LINE
, FLOW_STATUS_CODE
, FULFILLED_AMT_F
, FULFILLED_AMT_F1
, FULFILLED_AMT_G
, FULFILLED_QTY_INV
, FULFILLED_DATE
, FULFILLED_FLAG
, HEADER_ID
, H_MARKETING_SOURCE_CODE_ID
, INVOICED_AMT_F
, INVOICED_AMT_F1
, INVOICED_AMT_G
, INVOICED_QTY_INV
, INVOICE_TO_ORG_ID
, ITEM_TYPE_CODE
, LINE_CATEGORY_CODE
, LINE_ITEM_TYPE
, LINE_NUMBER
, MARKETING_SOURCE_CODE_ID
, OPEN_FLAG
, ORDERED_DATE
, ORDERED_QUANTITY
, ORDER_DATE_TYPE_CODE
, ORDER_NUMBER
, ORDER_QUANTITY_UOM
, INV_UOM_CODE
, PROMISE_DATE
, REQUEST_DATE
, SCHEDULE_SHIP_DATE
, SHIPPABLE_FLAG
, SHIPPED_AMT_F
, SHIPPED_AMT_F1
, SHIPPED_AMT_G
, SHIPPED_QTY_INV
, SHIPPED_DATE
, TOP_MODEL_LINE_ID
, UNIT_LIST_PRICE
, UNIT_SELLING_PRICE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SERVICE_PARENT_LINE_ID
, SHIP_TO_PARTY_ID
, BOOKED_AMT_G1
, BOOKED_LIST_AMT_G1
, FULFILLED_AMT_G1
, INVOICED_AMT_G1
, SHIPPED_AMT_G1
, SHIP_TO_ORG_ID
, SOLD_TO_ORG_ID
, FREIGHT_CHARGE
, FREIGHT_CHARGE_F
, FREIGHT_CHARGE_G
, FREIGHT_CHARGE_G1
, FREIGHT_COST
, FREIGHT_COST_F
, FREIGHT_COST_G
, FREIGHT_COST_G1
, CHARGE_PERIODICITY_CODE
, BLANKET_NUMBER
, BLANKET_LINE_NUMBER
FROM ISC.ISC_BOOK_SUM2_F;
ISC.ISC_BOOK_SUM2_F does not reference any database object
ISC.ISC_BOOK_SUM2_F is referenced by following:
APPS
BIM_I_ORD_COL_MV
BIM_SGMT_ACT_B_MV
BIM_SGMT_VAL_B_MV
ENI_DBI_TOB_MV
IBE_BI_CUST_INTM_MV
IBE_BI_ORDERBOM_MV
IBW_VISIT_CUST_MV
ISC_BOOK_SUM2_F
ISC_DBI_CFM_000_MV
ISC_DBI_CFM_002_MV
ISC_DBI_CFM_003_MV
ISC_DBI_CFM_004_MV
ISC_DBI_CFM_005_MV
ISC_DBI_CFM_006_MV
ISC_DBI_CFM_010_MV
ISC_DBI_CPM_002_MV
ISC_DBI_FM_0000_MV
ISC_DBI_FM_0001_MV
ISC_DBI_FM_0003_MV
ISC_DBI_FM_0004_MV
ISC_DBI_SCR_000_MV
ISC_DBI_SCR_003_MV
ISC_SAM_006_MV
|
|
|
|