NAME: Export Locations and Space Allocations To Interface Tables
SHORT CODE: PNEXPCAD
MODULE: Oracle Property Manager

Description: Export Locations and Space Allocations To Interface Tables
Navigation: Oracle Property Manager Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• LOCN_OR_SPC_FLAG : Flag indicating whether you are exporting location or space assignment data
• P_BATCH_NAME : Name of batch
• P_LOCN_TYPE : Type of location to be exported, for example, building or land
• P_LOCN_CODE_FROM : The first location of a range of locations to be exported
• P_LOCN_CODE_TO : The last location of a range of locations to be exported
• P_LAST_UPDATE_FROM : The earliest date on which locations were updated. Use this parameter in conjunction with P_LAST_UPDATE_TO to export locations updated within a specific period.
• P_LAST_UPDATE_TO : The earliest date on which locations were updated. Use this parameter in conjunction with P_LAST_UPDATE_FROM to export locations updated within a specific period.
• P_AS_OF_DATE : Current date. Date as of which locations or space assignments are updated