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: CE.CE_CP_WORKSHEET_LINES

Object Details

Object Name:	CE_CP_WORKSHEET_LINES
Object Type:	TABLE
Owner:	CE
FND Design Data:	CE.CE_CP_WORKSHEET_LINES
Subobject Name:
Status:	VALID

This table stores the Cash Position worksheet details

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CE_CP_WORKSHEET_LINES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	WORKSHEET_LINE_ID
CE_CP_WORKSHEET_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WORKSHEET_HEADER_ID SOURCE_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
WORKSHEET_HEADER_ID	NUMBER	(15)	Yes	Cash Position worksheet header identifier
WORKSHEET_LINE_ID	NUMBER	(15)	Yes	Cash Position worksheet line identifier
SOURCE_TYPE	VARCHAR2	(15)	Yes	Transaction source type
INCLUDE_FLAG	VARCHAR2	(1)	Yes	Flag to show if the line should be included in the Cash Position result
DESCRIPTION	VARCHAR2	(80)	Yes	Description
LEGAL_ENTITY_ID	NUMBER	(15)		Legal entity identifier
BANK_NAME	VARCHAR2	(60)		Bank name
BANK_ACCOUNT_ID	NUMBER	(15)		Bank account identifier
BALANCE_TYPE	VARCHAR2	(15)		Balance type, CE lookup type BANK_ACC_BAL_TYPE
FLOAT_TYPE	VARCHAR2	(15)		Float type, CE lookup type FLOAT_TYPE
TRX_TYPE	VARCHAR2	(30)		Transaction type
PAYMENT_METHOD	VARCHAR2	(25)		Payment method for APP and PAY
RECEIPT_METHOD_ID	NUMBER	(15)		Payment method for ARR
CLEARED_TRX_FLAG	VARCHAR2	(1)		Include cleared transactions? (Y/N)
OVERDUE_TRX_FLAG	VARCHAR2	(1)		Include overdue transactions? (Y/N)
CUT_OFF_DAYS	NUMBER			Cut off days
EXT_SOURCE_TYPE	VARCHAR2	(30)		External source type for open interface
AMOUNT	NUMBER			Amount for user-defined transactions
PAYROLL_ID	NUMBER	(15)		Payroll identifier
INDICATIVE_FLAG	VARCHAR2	(1)		Include indicative exposures for XTR? (Y/N)
CRITERIA_CATEGORY	VARCHAR2	(30)		External source type descriptive flexfield structure definition column
CRITERIA1	VARCHAR2	(150)		External source type descriptive flexfield segment
CRITERIA2	VARCHAR2	(150)		External source type descriptive flexfield segment
CRITERIA3	VARCHAR2	(150)		External source type descriptive flexfield segment
CRITERIA4	VARCHAR2	(150)		External source type descriptive flexfield segment
CRITERIA5	VARCHAR2	(150)		External source type descriptive flexfield segment
CRITERIA6	VARCHAR2	(150)		External source type descriptive flexfield segment
CRITERIA7	VARCHAR2	(150)		External source type descriptive flexfield segment
CRITERIA8	VARCHAR2	(150)		External source type descriptive flexfield segment
CRITERIA9	VARCHAR2	(150)		External source type descriptive flexfield segment
CRITERIA10	VARCHAR2	(150)		External source type descriptive flexfield segment
CRITERIA11	VARCHAR2	(150)		External source type descriptive flexfield segment
CRITERIA12	VARCHAR2	(150)		External source type descriptive flexfield segment
CRITERIA13	VARCHAR2	(150)		External source type descriptive flexfield segment
CRITERIA14	VARCHAR2	(150)		External source type descriptive flexfield segment
CRITERIA15	VARCHAR2	(150)		External source type descriptive flexfield segment
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CASHPOOL_ID	NUMBER	(15)		Cash pool identifier
TRXN_SUBTYPE_CODE_ID	NUMBER	(15)		Transaction subtype for Cash Management infows and outflows

Query Text

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


SELECT WORKSHEET_HEADER_ID
,      WORKSHEET_LINE_ID
,      SOURCE_TYPE
,      INCLUDE_FLAG
,      DESCRIPTION
,      LEGAL_ENTITY_ID
,      BANK_NAME
,      BANK_ACCOUNT_ID
,      BALANCE_TYPE
,      FLOAT_TYPE
,      TRX_TYPE
,      PAYMENT_METHOD
,      RECEIPT_METHOD_ID
,      CLEARED_TRX_FLAG
,      OVERDUE_TRX_FLAG
,      CUT_OFF_DAYS
,      EXT_SOURCE_TYPE
,      AMOUNT
,      PAYROLL_ID
,      INDICATIVE_FLAG
,      CRITERIA_CATEGORY
,      CRITERIA1
,      CRITERIA2
,      CRITERIA3
,      CRITERIA4
,      CRITERIA5
,      CRITERIA6
,      CRITERIA7
,      CRITERIA8
,      CRITERIA9
,      CRITERIA10
,      CRITERIA11
,      CRITERIA12
,      CRITERIA13
,      CRITERIA14
,      CRITERIA15
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      CASHPOOL_ID
,      TRXN_SUBTYPE_CODE_ID
FROM CE.CE_CP_WORKSHEET_LINES;

Dependencies

[top of page]

CE.CE_CP_WORKSHEET_LINES does not reference any database object

CE.CE_CP_WORKSHEET_LINES is referenced by following:

APPS: CE_CP_WORKSHEET_LINES