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

VIEW: APPS.ISC_BOOK_SUM2_F_V

Object Details
Object Name: ISC_BOOK_SUM2_F_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
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

Operating 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
SHIP_TO_ORG_ID NUMBER

Ship to Organization ID
SOLD_TO_ORG_ID NUMBER

Sold to Organization ID
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 UOM
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
SERVICE_PARENT_LINE_ID NUMBER

System Generated Line Identifier (of service line parent)
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
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
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
Query Text

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
,      SHIP_TO_ORG_ID
,      SOLD_TO_ORG_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
,      SERVICE_PARENT_LINE_ID
,      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
,      SHIP_TO_PARTY_ID
,      BOOKED_AMT_G1
,      BOOKED_LIST_AMT_G1
,      FULFILLED_AMT_G1
,      INVOICED_AMT_G1
,      SHIPPED_AMT_G1
,      FREIGHT_CHARGE
,      FREIGHT_CHARGE_F
,      FREIGHT_CHARGE_G
,      FREIGHT_CHARGE_G1
,      FREIGHT_COST
,      FREIGHT_COST_F
,      FREIGHT_COST_G
,      FREIGHT_COST_G1
FROM APPS.ISC_BOOK_SUM2_F_V;

Dependencies

[top of page]

APPS.ISC_BOOK_SUM2_F_V references the following:

SchemaAPPS
SynonymISC_BOOK_SUM2_F

APPS.ISC_BOOK_SUM2_F_V is not referenced by any database object