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

TABLE: ISC.ISC_DBI_TMP_BSA_ORDER_LINES

Object Details
Object Name: ISC_DBI_TMP_BSA_ORDER_LINES
Object Type: TABLE
Owner: ISC
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.

Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 30
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ISC_DBI_TMP_BSA_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_INTERFACE ColumnBATCH_ID
ColumnBLANKET_LINE_ID
ColumnORDER_LINE_ID
Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER

Batch Id
ORDER_LINE_ID NUMBER

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 blanket
AGREEMENT_TYPE_ID NUMBER

Blanket Transaction Type identifier
SOLD_TO_ORG_ID NUMBER

Sold to customer
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
ACCUMULATED_FULFILLED_AMT_G NUMBER

Accumulated fulfilled amount for the BSA in primary global currency
ACCUMULATED_FULFILLED_AMT_G1 NUMBER

Accumulated fulfilled amount for the BSA in secondary global currency
H_CNT NUMBER

Number of order lines for blanket
L_CNT NUMBER

Number of order lines for blanket line
TRANSACTIONAL_CURR_CODE VARCHAR2 (15)
Currency for the blanket
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 BATCH_ID
,      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
,      AGREEMENT_TYPE_ID
,      SOLD_TO_ORG_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
,      ACCUMULATED_FULFILLED_AMT_G
,      ACCUMULATED_FULFILLED_AMT_G1
,      H_CNT
,      L_CNT
,      TRANSACTIONAL_CURR_CODE
,      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_TMP_BSA_ORDER_LINES;

Dependencies

[top of page]

ISC.ISC_DBI_TMP_BSA_ORDER_LINES does not reference any database object

ISC.ISC_DBI_TMP_BSA_ORDER_LINES is referenced by following:

SchemaAPPS
SynonymISC_DBI_TMP_BSA_ORDER_LINES