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: FV.FV_REIMB_ACTIVITY_TEMP

Object Details

Object Name:	FV_REIMB_ACTIVITY_TEMP
Object Type:	TABLE
Owner:	FV
FND Design Data:	FV.FV_REIMB_ACTIVITY_TEMP
Subobject Name:
Status:	VALID

Table to store data reported on Reimbursable Activity Report

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
REIMB_AGREEMENT_NUM	VARCHAR2	(20)		Reimbursable Agreement Number
CONTRACT_NUMBER	VARCHAR2	(50)		Purchase Order number
START_DATE	DATE			Start Date
END_DATE	DATE			End Date
BILLING_LIMIT	NUMBER			Billing Limit
AMOUNT_OBLIGATION	NUMBER			Obligated Amount
AMOUNT_EXPENDED	NUMBER			Expended Amount
AMOUNT_UNFILLED_ORDER	NUMBER			Unfilled Order Amount
AMOUNT_ADVANCE_COLLECTED	NUMBER			Advance Amount Collected
AMOUNT_ADVANCE_APPLIED	NUMBER			Applied Advance Amount
AMOUNT_ADVANCE_BALANCE	NUMBER			Balance Advance Amount
AMOUNT_EARNED	NUMBER			Earned Amount
AMOUNT_BILLED	NUMBER			Billed Amount
AMOUNT_RECEIVABLE_COLLECTED	NUMBER			Receivable Amount Collected
AMOUNT_RECEIVABLE_BALANCE	NUMBER			Balance Receivable Amount
AMOUNT_AGREEMENT	NUMBER			Agreement Amount
REQUEST_ID	NUMBER	(15)		Request ID
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID)
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATE_DATE	DATE		Yes	Standard who column - date when a user last updated this row.
SEGMENT1	VARCHAR2	(30)		Segment 1
SEGMENT2	VARCHAR2	(30)		Segment 2
SEGMENT3	VARCHAR2	(30)		Segment 3
SEGMENT4	VARCHAR2	(30)		Segment 4
SEGMENT5	VARCHAR2	(30)		Segment 5
SEGMENT6	VARCHAR2	(30)		Segment 6
SEGMENT7	VARCHAR2	(30)		Segment 7
SEGMENT8	VARCHAR2	(30)		Segment 8
SEGMENT9	VARCHAR2	(30)		Segment 9
SEGMENT10	VARCHAR2	(30)		Segment 10
SEGMENT11	VARCHAR2	(30)		Segment 11
SEGMENT12	VARCHAR2	(30)		Segment 12
SEGMENT13	VARCHAR2	(30)		Segment 13
SEGMENT14	VARCHAR2	(30)		Segment 14
SEGMENT15	VARCHAR2	(30)		Segment 15
SEGMENT16	VARCHAR2	(30)		Segment 16
SEGMENT17	VARCHAR2	(30)		Segment 17
SEGMENT18	VARCHAR2	(30)		Segment 18
SEGMENT19	VARCHAR2	(30)		Segment 19
SEGMENT20	VARCHAR2	(30)		Segment 20
SEGMENT21	VARCHAR2	(30)		Segment 21
SEGMENT22	VARCHAR2	(30)		Segment 22
SEGMENT23	VARCHAR2	(30)		Segment 23
SEGMENT24	VARCHAR2	(30)		Segment 24
SEGMENT25	VARCHAR2	(30)		Segment 25
SEGMENT26	VARCHAR2	(30)		Segment 26
SEGMENT27	VARCHAR2	(30)		Segment 27
SEGMENT28	VARCHAR2	(30)		Segment 28
SEGMENT29	VARCHAR2	(30)		Segment 29
SEGMENT30	VARCHAR2	(30)		Segment 30
REPORTED_FLAG	VARCHAR2	(1)		Reported Flag

Query Text

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


SELECT REIMB_AGREEMENT_NUM
,      CONTRACT_NUMBER
,      START_DATE
,      END_DATE
,      BILLING_LIMIT
,      AMOUNT_OBLIGATION
,      AMOUNT_EXPENDED
,      AMOUNT_UNFILLED_ORDER
,      AMOUNT_ADVANCE_COLLECTED
,      AMOUNT_ADVANCE_APPLIED
,      AMOUNT_ADVANCE_BALANCE
,      AMOUNT_EARNED
,      AMOUNT_BILLED
,      AMOUNT_RECEIVABLE_COLLECTED
,      AMOUNT_RECEIVABLE_BALANCE
,      AMOUNT_AGREEMENT
,      REQUEST_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
,      REPORTED_FLAG
FROM FV.FV_REIMB_ACTIVITY_TEMP;

Dependencies

[top of page]

FV.FV_REIMB_ACTIVITY_TEMP does not reference any database object

FV.FV_REIMB_ACTIVITY_TEMP is referenced by following:

FV: FV_REIMB_ACTIVITY_TEMP#