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

TABLE: PN.PN_LOC_ACC_MAP_ALL

Object Details
Object Name: PN_LOC_ACC_MAP_ALL
Object Type: TABLE
Owner: PN
FND Design Data: TablePN.PN_LOC_ACC_MAP_ALL
Subobject Name:
Status: VALID


The table stores the information for mapping of expense accounts to the location for the specified accounting period. This is used when you extract the expense amount from GL to the PN_REC_EXP_ITF table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PN_LOC_ACC_MAP_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOC_ACC_MAP_ID
Columns
Name Datatype Length Mandatory Comments
LOC_ACC_MAP_ID NUMBER (15) Yes Unique location mapping identifier for the expense account mapping with location.
LOC_ACC_MAP_HDR_ID NUMBER (15) Yes Mapping identifier of the parent mapping to which the detail line belongs to.
LAST_UPDATE_DATE DATE
Yes Standard Who column.
LAST_UPDATED_BY NUMBER
Yes Standard Who column.
CREATION_DATE DATE
Yes Standard Who column.
CREATED_BY NUMBER
Yes Standard Who column.
LAST_UPDATE_LOGIN NUMBER

Standard Who column.
PROPERTY_ID NUMBER (15)
Property identifier of the property for the account mapping.
LOCATION_ID NUMBER (15)
Location identifier of the location for the account mapping.
ACCOUNT_LOW VARCHAR2 (240)
The GL account from range for mapping the account.
ACCOUNT_HIGH VARCHAR2 (240)
The GL account to range for mapping the account.
EXPENSE_TYPE_CODE VARCHAR2 (30) Yes The expense type associated with the location and GL account range combination.
EFFECTIVE_FROM_DATE DATE
Yes The date from which the accounting period is effective.
EFFECTIVE_TO_DATE DATE
Yes The Date to which the accounting period is effective.
RECOVERABLE_FLAG VARCHAR2 (1)
The flag to indicate whether the expenses are recoverable.
SEGMENT1_LOW VARCHAR2 (25)
Key flexfield segment.
SEGMENT1_HIGH VARCHAR2 (25)
Key flexfield segment.
SEGMENT2_LOW VARCHAR2 (25)
Key flexfield segment.
SEGMENT2_HIGH VARCHAR2 (25)
Key flexfield segment.
SEGMENT3_LOW VARCHAR2 (25)
Key flexfield segment.
SEGMENT3_HIGH VARCHAR2 (25)
Key flexfield segment.
SEGMENT4_LOW VARCHAR2 (25)
Key flexfield segment.
SEGMENT4_HIGH VARCHAR2 (25)
Key flexfield segment.
SEGMENT5_LOW VARCHAR2 (25)
Key flexfield segment.
SEGMENT5_HIGH VARCHAR2 (25)
Key flexfield segment.
SEGMENT6_LOW VARCHAR2 (25)
Key flexfield segment.
SEGMENT6_HIGH VARCHAR2 (25)
Key flexfield segment.
SEGMENT7_LOW VARCHAR2 (25)
Key flexfield segment.
SEGMENT7_HIGH VARCHAR2 (25)
Key flexfield segment.
SEGMENT8_LOW VARCHAR2 (25)
Key flexfield segment.
SEGMENT8_HIGH VARCHAR2 (25)
Key flexfield segment.
SEGMENT9_LOW VARCHAR2 (25)
Key flexfield segment.
SEGMENT9_HIGH VARCHAR2 (25)
Key flexfield segment.
SEGMENT10_LOW VARCHAR2 (25)
Key flexfield segment.
SEGMENT10_HIGH VARCHAR2 (25)
Key flexfield segment.
SEGMENT11_LOW VARCHAR2 (25)
Key flexfield segment.
SEGMENT11_HIGH VARCHAR2 (25)
Key flexfield segment.
SEGMENT12_LOW VARCHAR2 (25)
Key flexfield segment.
SEGMENT12_HIGH VARCHAR2 (25)
Key flexfield segment.
SEGMENT13_LOW VARCHAR2 (25)
Key flexfield segment.
SEGMENT13_HIGH VARCHAR2 (25)
Key flexfield segment.
SEGMENT14_LOW VARCHAR2 (25)
Key flexfield segment.
SEGMENT14_HIGH VARCHAR2 (25)
Key flexfield segment.
SEGMENT15_LOW VARCHAR2 (25)
Key flexfield segment.
SEGMENT15_HIGH VARCHAR2 (25)
Key flexfield segment.
SEGMENT16_LOW VARCHAR2 (25)
Key flexfield segment.
SEGMENT16_HIGH VARCHAR2 (25)
Key flexfield segment.
SEGMENT17_LOW VARCHAR2 (25)
Key flexfield segment.
SEGMENT17_HIGH VARCHAR2 (25)
Key flexfield segment.
SEGMENT18_LOW VARCHAR2 (25)
Key flexfield segment.
SEGMENT18_HIGH VARCHAR2 (25)
Key flexfield segment.
SEGMENT19_LOW VARCHAR2 (25)
Key flexfield segment.
SEGMENT19_HIGH VARCHAR2 (25)
Key flexfield segment.
SEGMENT20_LOW VARCHAR2 (25)
Key flexfield segment.
SEGMENT20_HIGH VARCHAR2 (25)
Key flexfield segment.
SEGMENT21_LOW VARCHAR2 (25)
Key flexfield segment.
SEGMENT21_HIGH VARCHAR2 (25)
Key flexfield segment.
SEGMENT22_LOW VARCHAR2 (25)
Key flexfield segment.
SEGMENT22_HIGH VARCHAR2 (25)
Key flexfield segment.
SEGMENT23_LOW VARCHAR2 (25)
Key flexfield segment.
SEGMENT23_HIGH VARCHAR2 (25)
Key flexfield segment.
SEGMENT24_LOW VARCHAR2 (25)
Key flexfield segment.
SEGMENT24_HIGH VARCHAR2 (25)
Key flexfield segment.
SEGMENT25_LOW VARCHAR2 (25)
Key flexfield segment.
SEGMENT25_HIGH VARCHAR2 (25)
Key flexfield segment.
SEGMENT26_LOW VARCHAR2 (25)
Key flexfield segment.
SEGMENT26_HIGH VARCHAR2 (25)
Key flexfield segment.
SEGMENT27_LOW VARCHAR2 (25)
Key flexfield segment.
SEGMENT27_HIGH VARCHAR2 (25)
Key flexfield segment.
SEGMENT28_LOW VARCHAR2 (25)
Key flexfield segment.
SEGMENT28_HIGH VARCHAR2 (25)
Key flexfield segment.
SEGMENT29_LOW VARCHAR2 (25)
Key flexfield segment.
SEGMENT29_HIGH VARCHAR2 (25)
Key flexfield segment.
SEGMENT30_LOW VARCHAR2 (25)
Key flexfield segment.
SEGMENT30_HIGH VARCHAR2 (25)
Key flexfield segment.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield segment.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfields segment.
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment.
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment.
ORG_ID NUMBER (15)
Organization identifier.
Query Text

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


SELECT LOC_ACC_MAP_ID
,      LOC_ACC_MAP_HDR_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PROPERTY_ID
,      LOCATION_ID
,      ACCOUNT_LOW
,      ACCOUNT_HIGH
,      EXPENSE_TYPE_CODE
,      EFFECTIVE_FROM_DATE
,      EFFECTIVE_TO_DATE
,      RECOVERABLE_FLAG
,      SEGMENT1_LOW
,      SEGMENT1_HIGH
,      SEGMENT2_LOW
,      SEGMENT2_HIGH
,      SEGMENT3_LOW
,      SEGMENT3_HIGH
,      SEGMENT4_LOW
,      SEGMENT4_HIGH
,      SEGMENT5_LOW
,      SEGMENT5_HIGH
,      SEGMENT6_LOW
,      SEGMENT6_HIGH
,      SEGMENT7_LOW
,      SEGMENT7_HIGH
,      SEGMENT8_LOW
,      SEGMENT8_HIGH
,      SEGMENT9_LOW
,      SEGMENT9_HIGH
,      SEGMENT10_LOW
,      SEGMENT10_HIGH
,      SEGMENT11_LOW
,      SEGMENT11_HIGH
,      SEGMENT12_LOW
,      SEGMENT12_HIGH
,      SEGMENT13_LOW
,      SEGMENT13_HIGH
,      SEGMENT14_LOW
,      SEGMENT14_HIGH
,      SEGMENT15_LOW
,      SEGMENT15_HIGH
,      SEGMENT16_LOW
,      SEGMENT16_HIGH
,      SEGMENT17_LOW
,      SEGMENT17_HIGH
,      SEGMENT18_LOW
,      SEGMENT18_HIGH
,      SEGMENT19_LOW
,      SEGMENT19_HIGH
,      SEGMENT20_LOW
,      SEGMENT20_HIGH
,      SEGMENT21_LOW
,      SEGMENT21_HIGH
,      SEGMENT22_LOW
,      SEGMENT22_HIGH
,      SEGMENT23_LOW
,      SEGMENT23_HIGH
,      SEGMENT24_LOW
,      SEGMENT24_HIGH
,      SEGMENT25_LOW
,      SEGMENT25_HIGH
,      SEGMENT26_LOW
,      SEGMENT26_HIGH
,      SEGMENT27_LOW
,      SEGMENT27_HIGH
,      SEGMENT28_LOW
,      SEGMENT28_HIGH
,      SEGMENT29_LOW
,      SEGMENT29_HIGH
,      SEGMENT30_LOW
,      SEGMENT30_HIGH
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORG_ID
FROM PN.PN_LOC_ACC_MAP_ALL;

Dependencies

[top of page]

PN.PN_LOC_ACC_MAP_ALL does not reference any database object

PN.PN_LOC_ACC_MAP_ALL is referenced by following:

SchemaPN
ViewPN_LOC_ACC_MAP_ALL#