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: TableSQLGL.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GL_BC_PACKET_ARRIVAL_ORDER_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPACKET_ID
GL_BC_PACKET_ARRIVAL_ORDER_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnARRIVAL_SEQ
GL_BC_PACKET_ARRIVAL_ORDER_U3 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLEDGER_ID
ColumnAFFECT_FUNDS_FLAG
ColumnARRIVAL_SEQ
ColumnPACKET_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:

SchemaGL
ViewGL_BC_PACKET_ARRIVAL_ORDER#