[Home] [Help] [Dependency Information]

TABLE: OKC.OKC_K_LINES_B_TEMP

Object Details

Temporary Table Details

OKC.OKC_K_LINES_B_TEMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

Query Text

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

SELECT ID
,      LINE_NUMBER
,      CHR_ID
,      CLE_ID
,      CLE_ID_RENEWED
,      DNZ_CHR_ID
,      DISPLAY_SEQUENCE
,      STS_CODE
,      TRN_CODE
,      LSE_ID
,      EXCEPTION_YN
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      HIDDEN_IND
,      PRICE_NEGOTIATED
,      PRICE_LEVEL_IND
,      PRICE_UNIT
,      PRICE_UNIT_PERCENT
,      INVOICE_LINE_LEVEL_IND
,      DPAS_RATING
,      TEMPLATE_USED
,      PRICE_TYPE
,      CURRENCY_CODE
,      LAST_UPDATE_LOGIN
,      DATE_TERMINATED
,      START_DATE
,      END_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      CLE_ID_RENEWED_TO
,      PRICE_NEGOTIATED_RENEWED
,      CURRENCY_CODE_RENEWED
,      UPG_ORIG_SYSTEM_REF
,      UPG_ORIG_SYSTEM_REF_ID
,      DATE_RENEWED
,      ORIG_SYSTEM_SOURCE_CODE
,      ORIG_SYSTEM_ID1
,      ORIG_SYSTEM_REFERENCE1
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      PRICE_LIST_ID
,      PRICE_LIST_LINE_ID
,      LINE_LIST_PRICE
,      ITEM_TO_PRICE_YN
,      PRICING_DATE
,      PRICE_BASIS_YN
,      CONFIG_HEADER_ID
,      CONFIG_REVISION_NUMBER
,      CONFIG_COMPLETE_YN
,      CONFIG_VALID_YN
,      CONFIG_TOP_MODEL_LINE_ID
,      CONFIG_ITEM_TYPE
,      CONFIG_ITEM_ID
,      SERVICE_ITEM_YN
,      PH_PRICING_TYPE
,      PH_PRICE_BREAK_BASIS
,      PH_MIN_QTY
,      PH_MIN_AMT
,      PH_QP_REFERENCE_ID
,      PH_VALUE
,      PH_ENFORCE_PRICE_LIST_YN
,      PH_ADJUSTMENT
,      PH_INTEGRATED_WITH_QP
,      CUST_ACCT_ID
,      BILL_TO_SITE_USE_ID
,      INV_RULE_ID
,      LINE_RENEWAL_TYPE_CODE
,      SHIP_TO_SITE_USE_ID
,      PAYMENT_TERM_ID
,      DATE_CANCELLED
,      TERM_CANCEL_SOURCE
,      ANNUALIZED_FACTOR
,      PAYMENT_INSTRUCTION_TYPE
,      CANC_REASON_CODE
,      CANCELLED_AMOUNT
,      LINE_EXISTS_YN
,      DATES_CHANGED_YN
,      GEN_SUBLINE_BSCH_YN
FROM OKC.OKC_K_LINES_B_TEMP;

Dependencies

[top of page]

OKC.OKC_K_LINES_B_TEMP does not reference any database object

OKC.OKC_K_LINES_B_TEMP is referenced by following:

APPS

OKC_K_LINES_B_TEMP