VIEW: APPS.PN_LOC_ACC_MAP_V

Source

View Text - Preformatted

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))

View Text - HTML Formatted

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))