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: CS.CS_TXN_BILLING_OETXN_ALL

Object Details

Object Name:	CS_TXN_BILLING_OETXN_ALL
Object Type:	TABLE
Owner:	CS
FND Design Data:	CS.CS_TXN_BILLING_OETXN_ALL
Subobject Name:
Status:	VALID

This table maps transaction billing types from CS_TXN_BILLING_TYPES to Order Management transaction types by operating unit.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Mandatory	Comments
TXN_BILL_ORDER_ID	NUMBER	Yes	The Transaction Billing Order type identifier.
TXN_BILLING_TYPE_ID	NUMBER		The transaction billing type id for the row being mapped to Order Managemenr.
ORG_ID	NUMBER		Operating Unit of Order and Line type id being mapped.
ORDER_TYPE_ID	NUMBER	Yes	The Order Management transaction header type id.
LINE_TYPE_ID	NUMBER	Yes	The Order Management transaction line type id.
LAST_UPDATE_DATE	DATE	Yes	Standard Who Column.
LAST_UPDATED_BY	NUMBER	Yes	Standard Who Column.
CREATION_DATE	DATE	Yes	Standard Who Column.
CREATED_BY	NUMBER	Yes	Standard Who Column.
LAST_UPDATE_LOGIN	NUMBER		Standard Who Column.
SECURITY_GROUP_ID	NUMBER		Used in hosted environments

Query Text

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


SELECT TXN_BILL_ORDER_ID
,      TXN_BILLING_TYPE_ID
,      ORG_ID
,      ORDER_TYPE_ID
,      LINE_TYPE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM CS.CS_TXN_BILLING_OETXN_ALL;

Dependencies

[top of page]

CS.CS_TXN_BILLING_OETXN_ALL does not reference any database object

CS.CS_TXN_BILLING_OETXN_ALL is referenced by following:

CS: CS_TXN_BILLING_OETXN_ALL#