DBA Data[Home] [Help] [Dependency Information]

TABLE: PA.PA_BC_PACKET_ARRIVAL_ORDER

Object Details
Object Name: PA_BC_PACKET_ARRIVAL_ORDER
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_BC_PACKET_ARRIVAL_ORDER
Subobject Name:
Status: VALID


PA_BC_PACKET_ARRIVAL_ORDER keeps track of the order in which in which the budgetary control packets need to be processed. Each packet has a sequence number with higher priority given to the packets with lower arrival sequence.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_BC_PACKET_ARRIVAL_ORDER_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPACKET_ID
PA_BC_PACKET_ARRIVAL_ORDER_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnARRIVAL_SEQ
PA_BC_PACKET_ARRIVAL_ORDER_U3 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSET_OF_BOOKS_ID
ColumnAFFECT_FUNDS_FLAG
ColumnARRIVAL_SEQ
ColumnPACKET_ID
Columns
Name Datatype Length Mandatory Comments
PACKET_ID NUMBER (15) Yes Budgetary control packet identifier
SET_OF_BOOKS_ID NUMBER (15)
Accounting Books Identifier
ARRIVAL_SEQ NUMBER
Yes Budgetary control packet arrival order
AFFECT_FUNDS_FLAG VARCHAR2 (1)
Affect this packet has on funds availability of later arriving packets.
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER (15)
Standard Who Column
Query Text

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


SELECT PACKET_ID
,      SET_OF_BOOKS_ID
,      ARRIVAL_SEQ
,      AFFECT_FUNDS_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM PA.PA_BC_PACKET_ARRIVAL_ORDER;

Dependencies

[top of page]

PA.PA_BC_PACKET_ARRIVAL_ORDER does not reference any database object

PA.PA_BC_PACKET_ARRIVAL_ORDER is referenced by following:

SchemaPA
ViewPA_BC_PACKET_ARRIVAL_ORDER#