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.

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

VIEW: APPS.ISCBV_BOOK_SUM2_FCV

Object Details

Object Name:	ISCBV_BOOK_SUM2_FCV
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
LINE_ID	NUMBER		Yes
CURRENCY_FUNC_ID	VARCHAR2	(40)
CURR_WH_FUNC_ID	VARCHAR2	(40)
CUSTOMER_ID	NUMBER
SHIP_TO_PARTY_ID	NUMBER
INVENTORY_ITEM_ID	NUMBER		Yes
INV_ORG_ID	NUMBER
INV_OU_ID	NUMBER
ITEM_ID	NUMBER
ITEM_INV_ORG_ID	NUMBER
ORDER_CATEGORY_ID	VARCHAR2	(30)	Yes
ORDER_SOURCE_ID	NUMBER
ORDER_TYPE_ID	NUMBER		Yes
ORG_OU_ID	NUMBER
RETURN_REASON_ID	VARCHAR2	(30)
SALES_CHANNEL_ID	VARCHAR2	(30)
SHIP_TO_ORG_ID	NUMBER
SOLD_TO_ORG_ID	NUMBER
TIME_ACT_SHIP_DATE_ID	DATE
TIME_BOOKED_DATE_ID	DATE
TIME_FULFILLED_DATE_ID	DATE
TIME_ORDERED_DATE_ID	DATE
TIME_PROMISE_DATE_ID	DATE
TIME_REQUEST_DATE_ID	DATE
TIME_SCHEDULE_DATE_ID	DATE
TIME_SHIPPED_DATE_ID	DATE
TOP_MODEL_ITEM_ID	NUMBER		Yes
TOP_MODEL_ORG_ID	NUMBER
ACTUAL_SHIPMENT_DATE	DATE
ATO_LINE_ID	NUMBER
BATCH_ID	NUMBER
BOOKED_AMT_F	NUMBER
BOOKED_AMT_F1	NUMBER
BOOKED_AMT_G	NUMBER
BOOKED_AMT_G1	NUMBER
BOOKED_QTY_INV	NUMBER
BOOKED_DATE	DATE
BOOKED_LIST_AMT_F	NUMBER
BOOKED_LIST_AMT_F1	NUMBER
BOOKED_LIST_AMT_G	NUMBER
BOOKED_LIST_AMT_G1	NUMBER
COUNT_PDUE_LINE	NUMBER
COUNT_SHIP_LINE	NUMBER
FLOW_STATUS_CODE	VARCHAR2	(30)
FULFILLED_AMT_F	NUMBER
FULFILLED_AMT_F1	NUMBER
FULFILLED_AMT_G	NUMBER
FULFILLED_AMT_G1	NUMBER
FULFILLED_QTY_INV	NUMBER
FULFILLED_DATE	DATE
FULFILLED_FLAG	VARCHAR2	(1)
HEADER_ID	NUMBER		Yes
H_MARKETING_SOURCE_CODE_ID	NUMBER
INVOICED_AMT_F	NUMBER
INVOICED_AMT_F1	NUMBER
INVOICED_AMT_G	NUMBER
INVOICED_AMT_G1	NUMBER
INVOICED_QTY_INV	NUMBER
INVOICE_TO_ORG_ID	NUMBER
INV_UOM_CODE	VARCHAR2	(30)
ITEM_TYPE_CODE	VARCHAR2	(30)
LINE_CATEGORY_CODE	VARCHAR2	(30)	Yes
LINE_ITEM_TYPE	NUMBER
LINE_NUMBER	VARCHAR2	(240)
MARKETING_SOURCE_CODE_ID	NUMBER
OPEN_FLAG	VARCHAR2	(1)	Yes
ORDERED_DATE	DATE
ORDERED_QUANTITY	NUMBER
ORDER_DATE_TYPE_CODE	VARCHAR2	(30)
ORDER_NUMBER	NUMBER		Yes
ORDER_QUANTITY_UOM	VARCHAR2	(3)
PROMISE_DATE	DATE
REQUEST_DATE	DATE
SCHEDULE_SHIP_DATE	DATE
SERVICE_PARENT_LINE_ID	NUMBER
SHIPPABLE_FLAG	VARCHAR2	(1)
SHIPPED_AMT_F	NUMBER
SHIPPED_AMT_F1	NUMBER
SHIPPED_AMT_G	NUMBER
SHIPPED_AMT_G1	NUMBER
SHIPPED_QTY_INV	NUMBER
SHIPPED_DATE	DATE
TOP_MODEL_LINE_ID	NUMBER
UNIT_LIST_PRICE	NUMBER
UNIT_SELLING_PRICE	NUMBER
FREIGHT_CHARGE	NUMBER
FREIGHT_CHARGE_F	NUMBER
FREIGHT_CHARGE_G	NUMBER
FREIGHT_CHARGE_G1	NUMBER
FREIGHT_COST	NUMBER
FREIGHT_COST_F	NUMBER
FREIGHT_COST_G	NUMBER
FREIGHT_COST_G1	NUMBER
CHARGE_PERIODICITY_CODE	VARCHAR2	(3)
BLANKET_NUMBER	NUMBER
BLANKET_LINE_NUMBER	NUMBER
CREATED_BY	NUMBER
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER

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
,      SHIP_TO_PARTY_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
,      BATCH_ID
,      BOOKED_AMT_F
,      BOOKED_AMT_F1
,      BOOKED_AMT_G
,      BOOKED_AMT_G1
,      BOOKED_QTY_INV
,      BOOKED_DATE
,      BOOKED_LIST_AMT_F
,      BOOKED_LIST_AMT_F1
,      BOOKED_LIST_AMT_G
,      BOOKED_LIST_AMT_G1
,      COUNT_PDUE_LINE
,      COUNT_SHIP_LINE
,      FLOW_STATUS_CODE
,      FULFILLED_AMT_F
,      FULFILLED_AMT_F1
,      FULFILLED_AMT_G
,      FULFILLED_AMT_G1
,      FULFILLED_QTY_INV
,      FULFILLED_DATE
,      FULFILLED_FLAG
,      HEADER_ID
,      H_MARKETING_SOURCE_CODE_ID
,      INVOICED_AMT_F
,      INVOICED_AMT_F1
,      INVOICED_AMT_G
,      INVOICED_AMT_G1
,      INVOICED_QTY_INV
,      INVOICE_TO_ORG_ID
,      INV_UOM_CODE
,      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
,      PROMISE_DATE
,      REQUEST_DATE
,      SCHEDULE_SHIP_DATE
,      SERVICE_PARENT_LINE_ID
,      SHIPPABLE_FLAG
,      SHIPPED_AMT_F
,      SHIPPED_AMT_F1
,      SHIPPED_AMT_G
,      SHIPPED_AMT_G1
,      SHIPPED_QTY_INV
,      SHIPPED_DATE
,      TOP_MODEL_LINE_ID
,      UNIT_LIST_PRICE
,      UNIT_SELLING_PRICE
,      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
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.ISCBV_BOOK_SUM2_FCV;

Dependencies

[top of page]

APPS.ISCBV_BOOK_SUM2_FCV references the following:

APPS: HZ_CUST_ACCOUNTS; HZ_CUST_ACCT_SITES_ALL; HZ_CUST_SITE_USES_ALL; HZ_PARTY_SITES; ISC_CURR_BOOK_SUM2; ISC_SERVICE_BOOK_SUM2; ISC_TMP_BOOK_SUM2; OE_ORDER_HEADERS_ALL; OE_ORDER_LINES_ALL

APPS.ISCBV_BOOK_SUM2_FCV is referenced by following:

APPS: ISC_DBI_BOOK_SUM2_F_C - show dependent code