Product: | PN - Property Manager |
---|---|
Description: | Stores the information for mapping of expense accounts to the location. |
Implementation/DBA Data: | APPS.PN_LOC_ACC_MAP_V |
SELECT PLAM.LOC_ACC_MAP_ID LOC_ACC_MAP_ID
, PLAM.LOC_ACC_MAP_HDR_ID LOC_ACC_MAP_HDR_ID
, PLMH.MAPPING_NAME MAPPING_NAME
, PLAM.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PLAM.LAST_UPDATED_BY LAST_UPDATED_BY
, PLAM.CREATION_DATE CREATION_DATE
, PLAM.CREATED_BY CREATED_BY
, PLAM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PLAM.PROPERTY_ID PROPERTY_ID
, PR.PROPERTY_NAME PROPERTY_NAME
, PR.PROPERTY_CODE PROPERTY_CODE
, PLAM.LOCATION_ID LOCATION_ID
, (SELECT L1.LOCATION_TYPE_LOOKUP_CODE
FROM PN_LOCATIONS L1
WHERE L1.LOCATION_ID (+)= PLAM.LOCATION_ID
AND ROWNUM = 1) LOCATION_TYPE
, (SELECT LOC.LOCATION_CODE
FROM PN_LOCATIONS LOC
WHERE LOC.LOCATION_ID (+)= PLAM.LOCATION_ID
AND ROWNUM = 1) LOCATION_CODE
, PLAM.ACCOUNT_LOW ACCOUNT_LOW
, PLAM.ACCOUNT_HIGH ACCOUNT_HIGH
, PLAM.EXPENSE_TYPE_CODE EXPENSE_TYPE_CODE
, ETYPE.MEANING EXPENSE_TYPE
, PLAM.EFFECTIVE_FROM_DATE EFFECTIVE_FROM_DATE
, PLAM.EFFECTIVE_TO_DATE EFFECTIVE_TO_DATE
, PLAM.RECOVERABLE_FLAG RECOVERABLE_FLAG
, PLAM.SEGMENT1_LOW SEGMENT1_LOW
, PLAM.SEGMENT1_HIGH SEGMENT1_HIGH
, PLAM.SEGMENT2_LOW SEGMENT2_LOW
, PLAM.SEGMENT2_HIGH SEGMENT2_HIGH
, PLAM.SEGMENT3_LOW SEGMENT3_LOW
, PLAM.SEGMENT3_HIGH SEGMENT3_HIGH
, PLAM.SEGMENT4_LOW SEGMENT4_LOW
, PLAM.SEGMENT4_HIGH SEGMENT4_HIGH
, PLAM.SEGMENT5_LOW SEGMENT5_LOW
, PLAM.SEGMENT5_HIGH SEGMENT5_HIGH
, PLAM.SEGMENT6_LOW SEGMENT6_LOW
, PLAM.SEGMENT6_HIGH SEGMENT6_HIGH
, PLAM.SEGMENT7_LOW SEGMENT7_LOW
, PLAM.SEGMENT7_HIGH SEGMENT7_HIGH
, PLAM.SEGMENT8_LOW SEGMENT8_LOW
, PLAM.SEGMENT8_HIGH SEGMENT8_HIGH
, PLAM.SEGMENT9_LOW SEGMENT9_LOW
, PLAM.SEGMENT9_HIGH SEGMENT9_HIGH
, PLAM.SEGMENT10_LOW SEGMENT10_LOW
, PLAM.SEGMENT10_HIGH SEGMENT10_HIGH
, PLAM.SEGMENT11_LOW SEGMENT11_LOW
, PLAM.SEGMENT11_HIGH SEGMENT11_HIGH
, PLAM.SEGMENT12_LOW SEGMENT12_LOW
, PLAM.SEGMENT12_HIGH SEGMENT12_HIGH
, PLAM.SEGMENT13_LOW SEGMENT13_LOW
, PLAM.SEGMENT13_HIGH SEGMENT13_HIGH
, PLAM.SEGMENT14_LOW SEGMENT14_LOW
, PLAM.SEGMENT14_HIGH SEGMENT14_HIGH
, PLAM.SEGMENT15_LOW SEGMENT15_LOW
, PLAM.SEGMENT15_HIGH SEGMENT15_HIGH
, PLAM.SEGMENT16_LOW SEGMENT16_LOW
, PLAM.SEGMENT16_HIGH SEGMENT16_HIGH
, PLAM.SEGMENT17_LOW SEGMENT17_LOW
, PLAM.SEGMENT17_HIGH SEGMENT17_HIGH
, PLAM.SEGMENT18_LOW SEGMENT18_LOW
, PLAM.SEGMENT18_HIGH SEGMENT18_HIGH
, PLAM.SEGMENT19_LOW SEGMENT19_LOW
, PLAM.SEGMENT19_HIGH SEGMENT19_HIGH
, PLAM.SEGMENT20_LOW SEGMENT20_LOW
, PLAM.SEGMENT20_HIGH SEGMENT20_HIGH
, PLAM.SEGMENT21_LOW SEGMENT21_LOW
, PLAM.SEGMENT21_HIGH SEGMENT21_HIGH
, PLAM.SEGMENT22_LOW SEGMENT22_LOW
, PLAM.SEGMENT22_HIGH SEGMENT22_HIGH
, PLAM.SEGMENT23_LOW SEGMENT23_LOW
, PLAM.SEGMENT23_HIGH SEGMENT23_HIGH
, PLAM.SEGMENT24_LOW SEGMENT24_LOW
, PLAM.SEGMENT24_HIGH SEGMENT24_HIGH
, PLAM.SEGMENT25_LOW SEGMENT25_LOW
, PLAM.SEGMENT25_HIGH SEGMENT25_HIGH
, PLAM.SEGMENT26_LOW SEGMENT26_LOW
, PLAM.SEGMENT26_HIGH SEGMENT26_HIGH
, PLAM.SEGMENT27_LOW SEGMENT27_LOW
, PLAM.SEGMENT27_HIGH SEGMENT27_HIGH
, PLAM.SEGMENT28_LOW SEGMENT28_LOW
, PLAM.SEGMENT28_HIGH SEGMENT28_HIGH
, PLAM.SEGMENT29_LOW SEGMENT29_LOW
, PLAM.SEGMENT29_HIGH SEGMENT29_HIGH
, PLAM.SEGMENT30_LOW SEGMENT30_LOW
, PLAM.SEGMENT30_HIGH SEGMENT30_HIGH
, PLAM.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PLAM.ATTRIBUTE1 ATTRIBUTE1
, PLAM.ATTRIBUTE2 ATTRIBUTE2
, PLAM.ATTRIBUTE3 ATTRIBUTE3
, PLAM.ATTRIBUTE4 ATTRIBUTE4
, PLAM.ATTRIBUTE5 ATTRIBUTE5
, PLAM.ATTRIBUTE6 ATTRIBUTE6
, PLAM.ATTRIBUTE7 ATTRIBUTE7
, PLAM.ATTRIBUTE8 ATTRIBUTE8
, PLAM.ATTRIBUTE9 ATTRIBUTE9
, PLAM.ATTRIBUTE10 ATTRIBUTE10
, PLAM.ATTRIBUTE11 ATTRIBUTE11
, PLAM.ATTRIBUTE12 ATTRIBUTE12
, PLAM.ATTRIBUTE13 ATTRIBUTE13
, PLAM.ATTRIBUTE14 ATTRIBUTE14
, PLAM.ATTRIBUTE15 ATTRIBUTE15
, PLAM.ORG_ID ORG_ID
FROM PN_LOC_ACC_MAP PLAM
, PN_LOC_ACC_MAP_HDR PLMH
, FND_LOOKUPS ETYPE
, PN_PROPERTIES PR
WHERE PLMH.LOC_ACC_MAP_HDR_ID = PLAM.LOC_ACC_MAP_HDR_ID
AND PLAM.PROPERTY_ID = PR.PROPERTY_ID (+)
AND PLAM.EXPENSE_TYPE_CODE = ETYPE.LOOKUP_CODE
AND ETYPE.LOOKUP_TYPE = 'PN_PAYMENT_PURPOSE_TYPE'
AND ETYPE.ENABLED_FLAG = 'Y'
AND TRUNC (SYSDATE) BETWEEN TRUNC (NVL(ETYPE.START_DATE_ACTIVE
, SYSDATE))
AND TRUNC (NVL(ETYPE.END_DATE_ACTIVE
, SYSDATE))