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]

VIEW: APPS.IGS_FI_BILL

Object Details

Object Name:	IGS_FI_BILL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_FI_BILL
Subobject Name:
Status:	VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

This is a flat view on the Multi Org table IGS_FI_BILL_ALL.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BILL_ID	NUMBER		Yes	A Sequence Generated Number that records the Primary Key
ORG_ID	NUMBER	(15)		The Org ID Column for Multi Org functionality
BILL_NUMBER	VARCHAR2	(50)	Yes	Bill number that the charge belongs to. Will be Sequence Generated and the same as Bill ID. Can be used if there is a requirement of Bill Number format being specified by the customer.
BILL_DATE	DATE		Yes	The date on which the Bill has been generated.
DUE_DATE	DATE		Yes	The date on which the payments against the Bill is due.
PERSON_ID	NUMBER	(15)	Yes	The Person being Billed
SUBACCOUNT_ID	NUMBER	(15)		OBSOLETE. The Sub Account for which the Bill is being generated.
BILL_FROM_DATE	DATE			The date from which the charges are included for Billing
OPENING_BALANCE	NUMBER		Yes	The Opening Balance for the Bill
CUT_OFF_DATE	DATE		Yes	The Cut Off Date till which the transactions were included in the Bill.
CLOSING_BALANCE	NUMBER		Yes	The Closing Balance for the Bill.
PRINTED_FLAG	VARCHAR2	(1)	Yes	Denotes whether the Bill has been printed and can have values ('Y','N') For Site Specific use. Default value is 'N'
PRINT_DATE	DATE			The date on which the Bill was printed.
TO_PAY_AMOUNT	NUMBER			The amount due for the particular bill calculated using the planned credits for the person.
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
REQUEST_ID	NUMBER	(15)		Standard Concurrent Request WHO Column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Concurrent Request WHO Column
PROGRAM_ID	NUMBER	(15)		Standard Concurrent Request WHO Column
PROGRAM_UPDATE_DATE	DATE			Standard Concurrent Request WHO Column

Query Text

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


SELECT BILL_ID
,      ORG_ID
,      BILL_NUMBER
,      BILL_DATE
,      DUE_DATE
,      PERSON_ID
,      SUBACCOUNT_ID
,      BILL_FROM_DATE
,      OPENING_BALANCE
,      CUT_OFF_DATE
,      CLOSING_BALANCE
,      PRINTED_FLAG
,      PRINT_DATE
,      TO_PAY_AMOUNT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM APPS.IGS_FI_BILL;

Dependencies

[top of page]

APPS.IGS_FI_BILL references the following:

APPS: IGS_FI_BILL_ALL

APPS.IGS_FI_BILL is referenced by following:

APPS: IGS_FI_BILL_EXTRACT - show dependent code; IGS_FI_PRC_FIN_LT_CHG - show dependent code