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: GL.GL_BC_PACKET_ARRIVAL_ORDER

Object Details

Object Name:	GL_BC_PACKET_ARRIVAL_ORDER
Object Type:	TABLE
Owner:	GL
FND Design Data:	SQLGL.GL_BC_PACKET_ARRIVAL_ORDER
Subobject Name:
Status:	VALID

GL_BC_PACKET_ARRIVAL_ORDER keeps track of the order in which budgetary control packets need to be processed. Each packet has a sequence number, with the higher priority being given to packets with the lower arrival sequence.
GL_BC_PACKET_ARRIVAL_ORDER is also used to determine the impact of budgetary control packets on one another. The AFFECT_FUNDS_FLAG lets the Funds Checker determine if a packet already processed affects funds available.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GL_BC_PACKET_ARRIVAL_ORDER_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PACKET_ID
GL_BC_PACKET_ARRIVAL_ORDER_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	ARRIVAL_SEQ
GL_BC_PACKET_ARRIVAL_ORDER_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	LEDGER_ID AFFECT_FUNDS_FLAG ARRIVAL_SEQ PACKET_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PACKET_ID	NUMBER	(15)	Yes	Budgetary control packet defining column
LEDGER_ID	NUMBER	(15)	Yes	Ledger defining column
ARRIVAL_SEQ	NUMBER	(15)	Yes	Budgetary control packet arrival order
AFFECT_FUNDS_FLAG	VARCHAR2	(1)	Yes	Affect packet has on funds availability of later arriving packets
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column

Query Text

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


SELECT PACKET_ID
,      LEDGER_ID
,      ARRIVAL_SEQ
,      AFFECT_FUNDS_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM GL.GL_BC_PACKET_ARRIVAL_ORDER;

Dependencies

[top of page]

GL.GL_BC_PACKET_ARRIVAL_ORDER does not reference any database object

GL.GL_BC_PACKET_ARRIVAL_ORDER is referenced by following:

GL: GL_BC_PACKET_ARRIVAL_ORDER#