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]

TABLE: ISC.ISC_DBI_BSA_ORDER_LINES_F

Object Details

Object Name:	ISC_DBI_BSA_ORDER_LINES_F
Object Type:	TABLE
Owner:	ISC
Subobject Name:
Status:	VALID

Base summary table for Sales Agreements Management page. It is mainly built on OE_BLANKET_HEADERS_ALL, OE_BLANKET_HEADERS_EXT, OE_BLANKET_LINES_ALL, OE_BLANKET_LINES_EXT, and ISC_BOOK_SUM2_F tables. It contains the following dimensions: product, customer, resource, agreement type and time. It contains the commitment and fulfilled amounts in DBI primary global currency and DBI secondary global currency among other blanket information.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	30
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ISC_DBI_BSA_ORDER_LINES_F_N4	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	SALES_GRP_ID BLANKET_LINE_ID CUSTOMER_ID AGREEMENT_TYPE_ID
ISC_DBI_BSA_ORDER_LINES_F_N5	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	BLANKET_LINE_ID ORDER_LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ORDER_LINE_ID	NUMBER			Order Line ID. Primary key to identify order line referencing BSA
ORDER_LINE_HEADER_ID	NUMBER			Order Line Header ID
ORDER_NUMBER	NUMBER			Sales order number
LINE_NUMBER	VARCHAR2	(240)		Sales order line number
INVENTORY_ITEM_ID	NUMBER			Inventory item identifier
ITEM_INV_ORG_ID	NUMBER			Inventory organization identifier
BLANKET_LINE_ID	NUMBER			Blanket line identifier
BLANKET_HEADER_ID	NUMBER			Blanket header identifier
BLANKET_NUMBER	NUMBER			User-Visibile number of the blanket
BLANKET_LINE_NUMBER	NUMBER			Blanket line identifier
ORG_ID	NUMBER			Organization identifier
SALESREP_ID	NUMBER			Sales representative identifier for the blanket
SALES_GRP_ID	NUMBER			Sales group identifier for the blanket
AGREEMENT_TYPE_ID	NUMBER			Blanket Transaction Type identifier
SOLD_TO_ORG_ID	NUMBER			Sold to customer
CUSTOMER_ID	NUMBER			Customer identifier
TIME_ACTIVATION_DATE_ID	DATE			Activation (truncated) date
TIME_EXPIRATION_DATE_ID	DATE			Expiration (truncated) date
TIME_TERMINATION_DATE_ID	DATE			Termination (truncated) date of the blanket
TIME_FULFILLED_DATE_ID	DATE			Fulfillment (truncated) date of the sales order lines
TIME_EFFECTIVE_END_DATE_ID	DATE			Effective end (truncated) date
H_START_DATE_ACTIVE	DATE			Activation date of the blanket
L_START_DATE_ACTIVE	DATE			Activation date of the blanket line
H_END_DATE_ACTIVE	DATE			Expiration date of the blanket
L_END_DATE_ACTIVE	DATE			Expiration date of the blanket line
TERMINATION_DATE	DATE			Termination date of the blanket
BLANKET_MIN_AMT	NUMBER			Minimum currency amount allowed for blanket
BLANKET_LINE_MIN_AMT	NUMBER			Minimum currency amount allowed for blanket line
FULFILLED_AMT_G	NUMBER			Fulfilled amount in primary global currency
FULFILLED_AMT_G1	NUMBER			Fulfilled amount in secondary global currency
H_CNT	NUMBER			Number of order lines for blanket
L_CNT	NUMBER			Number of order lines for blanket line
COMMIT_PRORATED_AMT_G	NUMBER			Commitement (prorated) amount in primary global currency
COMMIT_PRORATED_AMT_G1	NUMBER			Commitment (prorated) amount in secondary global currency
FULFILLED_OUTSTAND_AMT_G	NUMBER			Fulfilled amount for Outstanding Commitments in primary global currency
FULFILLED_OUTSTAND_AMT_G1	NUMBER			Fulfilled amount for Outstanding Commitments in secondary global currency
TRANSACTION_PHASE_CODE	VARCHAR2	(80)		Indicates if Transaction is in negotitation or fulfillment phase
CREATED_BY	NUMBER		Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER			Standard who column
PROGRAM_ID	NUMBER			Standard who column
PROGRAM_LOGIN_ID	NUMBER			Standard who column
PROGRAM_APPLICATION_ID	NUMBER			Standard who column
REQUEST_ID	NUMBER			Standard who column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ORDER_LINE_ID
,      ORDER_LINE_HEADER_ID
,      ORDER_NUMBER
,      LINE_NUMBER
,      INVENTORY_ITEM_ID
,      ITEM_INV_ORG_ID
,      BLANKET_LINE_ID
,      BLANKET_HEADER_ID
,      BLANKET_NUMBER
,      BLANKET_LINE_NUMBER
,      ORG_ID
,      SALESREP_ID
,      SALES_GRP_ID
,      AGREEMENT_TYPE_ID
,      SOLD_TO_ORG_ID
,      CUSTOMER_ID
,      TIME_ACTIVATION_DATE_ID
,      TIME_EXPIRATION_DATE_ID
,      TIME_TERMINATION_DATE_ID
,      TIME_FULFILLED_DATE_ID
,      TIME_EFFECTIVE_END_DATE_ID
,      H_START_DATE_ACTIVE
,      L_START_DATE_ACTIVE
,      H_END_DATE_ACTIVE
,      L_END_DATE_ACTIVE
,      TERMINATION_DATE
,      BLANKET_MIN_AMT
,      BLANKET_LINE_MIN_AMT
,      FULFILLED_AMT_G
,      FULFILLED_AMT_G1
,      H_CNT
,      L_CNT
,      COMMIT_PRORATED_AMT_G
,      COMMIT_PRORATED_AMT_G1
,      FULFILLED_OUTSTAND_AMT_G
,      FULFILLED_OUTSTAND_AMT_G1
,      TRANSACTION_PHASE_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      PROGRAM_APPLICATION_ID
,      REQUEST_ID
FROM ISC.ISC_DBI_BSA_ORDER_LINES_F;

Dependencies

[top of page]

ISC.ISC_DBI_BSA_ORDER_LINES_F does not reference any database object

ISC.ISC_DBI_BSA_ORDER_LINES_F is referenced by following:

APPS: ISC_DBI_BSA_ORDER_LINES_F; ISC_SAM_000_MV; ISC_SAM_001_MV; ISC_SAM_002_MV; ISC_SAM_003_MV; ISC_SAM_004_MV; ISC_SAM_005_MV; ISC_SAM_007_MV