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: OKS.OKS_INT_HEADER_STG_TEMP

Object Details

Object Name:	OKS_INT_HEADER_STG_TEMP
Object Type:	TABLE
Owner:	OKS
FND Design Data:	OKS.OKS_INT_HEADER_STG_TEMP
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length
HEADER_INTERFACE_ID	NUMBER
HEADER_INTERFACE_ROWID	ROWID	(10)
CONTRACT_NUMBER	VARCHAR2	(120)
CONTRACT_NUMBER_MODIFIER	VARCHAR2	(120)
INTERFACE_STATUS	VARCHAR2	(1)
CATEGORY	VARCHAR2	(30)
STATUS_CODE	VARCHAR2	(30)
START_DATE	DATE
END_DATE	DATE
KNOWN_AS	VARCHAR2	(300)
DESCRIPTION	VARCHAR2	(1995)
INV_ORGANIZATION_ID	NUMBER
OPERATING_UNIT_ID	NUMBER
BILL_TO_SITE_USAGE_ID	NUMBER
SHIP_TO_SITE_USAGE_ID	NUMBER
CONTRACT_CURRENCY_CODE	VARCHAR2	(15)
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)
CURRENCY_CONVERSION_RATE	NUMBER
CURRENCY_CONVERSION_DATE	DATE
PRICE_LIST_ID	NUMBER
PAYMENT_TERMS_ID	NUMBER	(15)
PAYMENT_INSTRUCTION	VARCHAR2	(3)
PO_REQUIRED	VARCHAR2	(3)
PAYMENT_INSTRUCTION_DETAILS	VARCHAR2	(150)
INVOICING_RULE_ID	NUMBER	(15)
SERVICE_CHRG_PREPAY_REQ	VARCHAR2	(1)
RENEWAL_PROCESS	VARCHAR2	(30)
APPROVAL_REQUIRED	VARCHAR2	(30)
RENEW_UP_TO	DATE
DATE_APPROVED	DATE
DATE_SIGNED	DATE
DATE_CANCELED	DATE
CANCELLATION_REASON	VARCHAR2	(30)
QA_CHECKLIST	NUMBER
PAYMENT_METHOD_CODE	VARCHAR2	(30)
COMMITMENT_ID	NUMBER
TAX_EXEMPTION_CONTROL	VARCHAR2	(30)
TAX_EXEMPTION_NUMBER	VARCHAR2	(80)
EXEMPT_REASON_CODE	VARCHAR2	(30)
BILL_SERVICES	VARCHAR2	(1)
BILLING_TRANSACTION_TYPE_ID	NUMBER
ACCOUNTING_RULE_ID	NUMBER
HOLD_CREDITS	VARCHAR2	(1)
SUMMARY_PRINT	VARCHAR2	(1)
SUMMARY_TRANSACTIONS	VARCHAR2	(1)
SERVICE_CHARGES_PO_REQUIRED	VARCHAR2	(1)
SERVICE_CHARGES_PO_NUMBER	VARCHAR2	(240)
PRICING_METHOD	VARCHAR2	(30)
RENEWAL_PRICE_LIST_ID	NUMBER
RENEWAL_MARKUP	NUMBER
RENEWAL_BILLING_PROFILE_ID	NUMBER
RENEWAL_PO_NUMBER	VARCHAR2	(240)
RENEWAL_PO_REQUIRED	VARCHAR2	(1)
RENEWAL_GRACE_DURATION	NUMBER
RENEWAL_GRACE_PERIOD	VARCHAR2	(30)
RENEWAL_ESTIMATED_PERCENT	NUMBER
RENEWAL_ESTIMATED_DURATION	NUMBER
RENEWAL_ESTIMATED_PERIOD	VARCHAR2	(30)
QUOTE_TO_PARTY_SITE	NUMBER
QUOTE_TO_CONTACT	NUMBER
QUOTE_TO_PHONE	NUMBER
QUOTE_TO_FAX	NUMBER
QUOTE_TO_EMAIL	NUMBER
GRACE_DURATION	NUMBER
GRACE_PERIOD	VARCHAR2	(30)
ESTIMATION_PERCENT	NUMBER
ESTIMATION_DATE	DATE
FOLLOW_UP_DUE_DATE	DATE
FOLLOW_UP_ACTION	VARCHAR2	(30)
CUSTOMER_PARTY_ID	NUMBER
THIRD_PARTY_ID	NUMBER
CONTRACT_GROUP_ID	NUMBER
APPROVAL_PROCESS_ID	NUMBER
AGREEMENT_ID	NUMBER
SALESPERSON_ID	NUMBER
CUSTOMER_CONTRACT_ADMIN_ID	NUMBER
SALESGROUP_ID	NUMBER
FULLY_BILLED	VARCHAR2	(1)
SOURCE	VARCHAR2	(80)
DOCUMENT	VARCHAR2	(240)

Query Text

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


SELECT HEADER_INTERFACE_ID
,      HEADER_INTERFACE_ROWID
,      CONTRACT_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      INTERFACE_STATUS
,      CATEGORY
,      STATUS_CODE
,      START_DATE
,      END_DATE
,      KNOWN_AS
,      DESCRIPTION
,      INV_ORGANIZATION_ID
,      OPERATING_UNIT_ID
,      BILL_TO_SITE_USAGE_ID
,      SHIP_TO_SITE_USAGE_ID
,      CONTRACT_CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_DATE
,      PRICE_LIST_ID
,      PAYMENT_TERMS_ID
,      PAYMENT_INSTRUCTION
,      PO_REQUIRED
,      PAYMENT_INSTRUCTION_DETAILS
,      INVOICING_RULE_ID
,      SERVICE_CHRG_PREPAY_REQ
,      RENEWAL_PROCESS
,      APPROVAL_REQUIRED
,      RENEW_UP_TO
,      DATE_APPROVED
,      DATE_SIGNED
,      DATE_CANCELED
,      CANCELLATION_REASON
,      QA_CHECKLIST
,      PAYMENT_METHOD_CODE
,      COMMITMENT_ID
,      TAX_EXEMPTION_CONTROL
,      TAX_EXEMPTION_NUMBER
,      EXEMPT_REASON_CODE
,      BILL_SERVICES
,      BILLING_TRANSACTION_TYPE_ID
,      ACCOUNTING_RULE_ID
,      HOLD_CREDITS
,      SUMMARY_PRINT
,      SUMMARY_TRANSACTIONS
,      SERVICE_CHARGES_PO_REQUIRED
,      SERVICE_CHARGES_PO_NUMBER
,      PRICING_METHOD
,      RENEWAL_PRICE_LIST_ID
,      RENEWAL_MARKUP
,      RENEWAL_BILLING_PROFILE_ID
,      RENEWAL_PO_NUMBER
,      RENEWAL_PO_REQUIRED
,      RENEWAL_GRACE_DURATION
,      RENEWAL_GRACE_PERIOD
,      RENEWAL_ESTIMATED_PERCENT
,      RENEWAL_ESTIMATED_DURATION
,      RENEWAL_ESTIMATED_PERIOD
,      QUOTE_TO_PARTY_SITE
,      QUOTE_TO_CONTACT
,      QUOTE_TO_PHONE
,      QUOTE_TO_FAX
,      QUOTE_TO_EMAIL
,      GRACE_DURATION
,      GRACE_PERIOD
,      ESTIMATION_PERCENT
,      ESTIMATION_DATE
,      FOLLOW_UP_DUE_DATE
,      FOLLOW_UP_ACTION
,      CUSTOMER_PARTY_ID
,      THIRD_PARTY_ID
,      CONTRACT_GROUP_ID
,      APPROVAL_PROCESS_ID
,      AGREEMENT_ID
,      SALESPERSON_ID
,      CUSTOMER_CONTRACT_ADMIN_ID
,      SALESGROUP_ID
,      FULLY_BILLED
,      SOURCE
,      DOCUMENT
FROM OKS.OKS_INT_HEADER_STG_TEMP;

Dependencies

[top of page]

OKS.OKS_INT_HEADER_STG_TEMP does not reference any database object

OKS.OKS_INT_HEADER_STG_TEMP is referenced by following:

OKS: OKS_INT_HEADER_STG_TEMP#