[Home] [Help] [Dependency Information]
Object Name: | PA_SEGMENT_RULE_PAIRINGS_ALL |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_SEGMENT_RULE_PAIRINGS_ALL |
Subobject Name: | |
Status: | VALID |
PA_SEGMENT_RULE_PAIRINGS_ALL stores implementation-defined
assignments of AutoAccounting rules to accounting
flexfield segments for a specific function
transaction. AutoAccounting uses the rule assigned to
an accounting flexfield segment to derive the segment
value.
.
.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_SEGMENT_RULE_PAIRINGS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
APPLICATION_ID
FUNCTION_CODE FUNCTION_TRANSACTION_CODE ID_FLEX_CODE ID_FLEX_NUM SEGMENT_NUM ORG_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | (15) | Yes | The identifier of the Oracle application that uses the function |
FUNCTION_CODE | VARCHAR2 | (15) | Yes | The identifier of the function of the transaction |
FUNCTION_TRANSACTION_CODE | VARCHAR2 | (30) | Yes | The identifier of the function transaction that is the context in which the rule will be used to derive the segment |
ID_FLEX_CODE | VARCHAR2 | (4) | Yes | The identifier of the key flexfield for which the function is used |
ID_FLEX_NUM | NUMBER | (15) | Yes | The identifier of the key flexfield structure for which the pairing is used |
SEGMENT_NUM | NUMBER | (15) | Yes | The number of the flexfield segment to which the rule is assigned. The number is the (segment number - 1) |
RULE_ID | NUMBER | (15) | Yes | The identifier of the rule that is used to derive the segment value |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CREATION_DATE | DATE | Yes | Standard Who Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who Column |
DISPLAY_FLAG | VARCHAR2 | (1) | Flag that indicates if the segment rule pairing can be viewed in the Assign Rules form. All pairings defined in Oracle Projects can be viewed. Other Oracle applications that use AutoAccounting may provide pairings that cannot be viewed | |
ORG_ID | NUMBER | (15) | Operating unit identifier for multi-organization installations |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, FUNCTION_CODE
, FUNCTION_TRANSACTION_CODE
, ID_FLEX_CODE
, ID_FLEX_NUM
, SEGMENT_NUM
, RULE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, DISPLAY_FLAG
, ORG_ID
FROM PA.PA_SEGMENT_RULE_PAIRINGS_ALL;
PA.PA_SEGMENT_RULE_PAIRINGS_ALL does not reference any database object
PA.PA_SEGMENT_RULE_PAIRINGS_ALL is referenced by following:
|
|
|