You are browsing the archive for PN.

by oracleguru

Property Manager Tables

ORACLE APPS COMMUNITY > Tutorial > PN

Oracle Property Manager Tables:

  • PN_ACCOUNTING_EVENTS_ALL
  • PN_ADDRESSES_ALL
  • PN_ADJUSTMENT_DETAILS
  • PN_ADJUSTMENT_SUMMARIES
  • PN_AE_HEADERS_ALL
  • PN_AE_LINES_ALL
  • PN_COMPANIES_ALL
  • PN_COMPANY_SITES_ALL
  • PN_CONTACTS_ALL
  • PN_CONTACT_ASSIGNMENTS_ALL
  • PN_CONTACT_ASSIGN_HISTORY
  • PN_CURRENCIES
  • PN_DISTRIBUTIONS_ALL
  • PN_DISTRIBUTIONS_HISTORY
  • PN_EMP_SPACE_ASSIGN_ITF
  • PN_INDEX_EXCLUDE_TERM_ALL
  • PN_INDEX_HISTORY_HEADERS
  • PN_INDEX_HISTORY_LINES
  • PN_INDEX_LEASES_ALL
  • PN_INDEX_LEASE_CONSTRAINTS_ALL
  • PN_INDEX_LEASE_PERIODS_ALL
  • PN_INDEX_LEASE_TERMS_ALL
  • PN_INSURANCE_REQUIREMENTS_ALL
  • PN_INSUR_REQUIRE_HISTORY
  • PN_LANDLORD_SERVICES_ALL
  • PN_LANDLORD_SERVICE_HISTORY
  • PN_LEASES_ALL
  • PN_LEASE_CHANGES_ALL
  • PN_LEASE_DETAILS_ALL
  • PN_LEASE_DETAILS_HISTORY
  • PN_LEASE_MILESTONES_ALL
  • PN_LEASE_OPTIONS_ITF
  • PN_LEASE_TRANSACTIONS_ALL
  • PN_LOCATIONS_ALL
  • PN_LOCATIONS_ITF
  • PN_LOCATION_FEATURES_ALL
  • PN_LOCATION_PARKS
  • PN_LOC_ACC_MAP_ALL
  • PN_LOC_ACC_MAP_HDR_ALL
  • PN_MILESTONES_ITF
  • PN_NOTE_DETAILS
  • PN_NOTE_HEADERS
  • PN_OPTIONS_ALL
  • PN_OPTIONS_HISTORY
  • PN_PAYMENT_ITEMS_ALL
  • PN_PAYMENT_ITEMS_EFC
  • PN_PAYMENT_SCHEDULES_ALL
  • PN_PAYMENT_TERMS_ALL
  • PN_PAYMENT_TERMS_EFC
  • PN_PAYMENT_TERMS_HISTORY
  • PN_PAY_GROUP_BYS
  • PN_PAY_GROUP_RULES
  • PN_PHONES_ALL
  • PN_PROPERTIES_ALL
  • PN_REC_AGREEMENTS_ALL
  • PN_REC_AGR_LINABAT_ALL
  • PN_REC_AGR_LINAREA_ALL
  • PN_REC_AGR_LINCONST_ALL
  • PN_REC_AGR_LINES_ALL
  • PN_REC_AGR_LINEXP_ALL
  • PN_REC_ARCL_ALL
  • PN_REC_ARCL_DTLLN_ALL
  • PN_REC_ARCL_DTL_ALL
  • PN_REC_ARCL_EXC_ALL
  • PN_REC_CALC_PERIODS_ALL
  • PN_REC_EXPCL_ALL
  • PN_REC_EXPCL_DTLACC_ALL
  • PN_REC_EXPCL_DTLLN_ALL
  • PN_REC_EXPCL_DTL_ALL
  • PN_REC_EXPCL_INC_ALL
  • PN_REC_EXPCL_TYPE_ALL
  • PN_REC_EXP_ITF
  • PN_REC_EXP_LINE_ALL
  • PN_REC_EXP_LINE_DTL_ALL
  • PN_REC_LINBILL_ALL
  • PN_REC_PERIOD_BILL_ALL
  • PN_REC_PERIOD_LINES_ALL
  • PN_RENT_ROLL_LEASE_EXP_ITF
  • PN_RIGHTS_ALL
  • PN_RIGHTS_HISTORY
  • PN_SET_MILESTONES
  • PN_SET_TYPES
  • PN_SPACE_ALLOCATIONS_ALL
  • PN_SPACE_ALLOC_ITF
  • PN_SPACE_ASSIGN_CUST_ALL
  • PN_SPACE_ASSIGN_EMP_ALL
  • PN_SPACE_ASSIGN_LEASE_ITF
  • PN_SPACE_ASSIGN_LOC_ITF
  • PN_SPACE_UTIL_LEASE_ITF
  • PN_SPACE_UTIL_LOC_ITF
  • PN_SYSTEM_SETUP_OPTIONS
  • PN_TENANCIES_ALL
  • PN_TENANCIES_HISTORY
  • PN_TERM_TEMPLATES_ALL
  • PN_VAR_ABATEMENTS_ALL
  • PN_VAR_BKPTS_DET_ALL
  • PN_VAR_BKPTS_HEAD_ALL
  • PN_VAR_CONSTRAINTS_ALL
  • PN_VAR_DEDUCTIONS_ALL
  • PN_VAR_GRP_DATES_ALL
  • PN_VAR_LINES_ALL
  • PN_VAR_PERIODS_ALL
  • PN_VAR_RENTS_ALL
  • PN_VAR_RENT_DATES_ALL
  • PN_VAR_RENT_INV_ALL
  • PN_VAR_RENT_SUMM_ALL
  • PN_VAR_VOL_HIST_ALL
  • PN_VOL_HIST_BATCH_ITF
  • PN_VOL_HIST_LINES_ITF

Tags: No Comments »

by oracleguru

Property Manager Descriptive Flex Fields

ORACLE APPS COMMUNITY > Tutorial > PN

Oracle Property Manager module DFF list:

DFF View DFF CODE NAME DFF name
PN_ADDRESSES_ALL_DFV Flexible Address Format Flexible Address Format
PN_COMPANIES_ALL_DFV PN_COMPANIES Company Information
PN_COMPANY_SITES_ALL_DFV PN_COMPANY_SITES Lease Company Site
PN_CONTACTS_ALL_DFV PN_CONTACTS Contact Information
PN_CONTACT_ASSIGNMENTS_ALL_DFV PN_CONTACT_ASSIGNMENTS Contact Assignments
PN_INSURANCE_REQUIREMENTS__DFV PN_INSURANCE_REQUIREMNTS Insurance Requirements
PN_LANDLORD_SERVICES_ALL_DFV PN_LANDLORD_SERVICES Landlord Services
PN_LEASE_CHANGES_ALL_DFV PN_LEASE_CHANGES Lease Changes
PN_LEASE_DETAILS_ALL_DFV PN_LEASE_DETAILS Lease
PN_LEASE_MILESTONES_ALL_DFV PN_LEASE_MILESTONES Milestones Information
PN_LOCATIONS_ALL_DFV PN_LOCATIONS Locations
PN_LOCATION_FEATURES_ALL_DFV PN_LOCATION_FEATURES Location Features
PN_LOCATION_PARKS_DFV PN_LOCATION_PARKS Regions and Office Parks
PN_OPTIONS_ALL_DFV PN_OPTIONS Lease Option Information
PN_PAYMENT_SCHEDULES_ALL_DFV PN_PAYMENT_SCHEDULES Payment Schedule Information
PN_PAYMENT_TERMS_ALL_DFV PN_PAYMENT_TERMS Payment Terms
PN_PHONES_ALL_DFV PN_PHONES Phone Information
PN_SPACE_ALLOCATIONS_ALL_DFV PN_SPACE_ALLOCATIONS Space Assignments
PN_TENANCIES_ALL_DFV PN_TENANCIES Tenancies
PN_RIGHTS_ALL_DFV PN_RIGHTS Lease Rights Information
PN_PROPERTIES_ALL_DFV PN_PROPERTIES Property Information
PN_SPACE_ASSIGN_EMP_ALL_DFV PNTSPACE_EMP PNTSPACE_EMP
PN_SPACE_ASSIGN_CUST_ALL_DFV PNTSPACE_CUST PNTSPACE_CUST
PN_TERM_TEMPLATES_ALL_DFV PN_TERM_TEMPLATES Term Templates
PN_DISTRIBUTIONS_ALL_DFV PN_DISTRIBUTION_FLEX Distributions Flexfield
PN_INDEX_LEASES_ALL_DFV PN_INDEX_AGREEMENT Index Agreement
PN_INDEX_LEASE_CONSTRAINTS_DFV PN_INDEX_CONSTRAINTS Index Constraints
PN_INDEX_LEASE_PERIODS_ALL_DFV PN_INDEX_PERIODS Index Periods
PN_INDEX_LEASES_ALL1_DFV PN_INDEX_RENT Index Rent
PN_INDEX_HISTORY_HEADERS_DFV PN_INDEX_HISTORY_HEADERS Index History Headers
PN_PAY_GROUP_RULES_DFV PN_PAY_GROUP_RULES Invoice Grouping Rules
PN_PAY_GROUP_BYS_DFV PN_PAY_GROUP_BYS Optional Grouping Characteristics
PN_NOTE_HEADERS_DFV PN_NOTE_HEADERS Notes
PN_VAR_RENTS_ALL_DFV PN_VAR_RENTS Variable Rent
PN_VAR_PERIODS_ALL_DFV PN_VAR_PERIODS Period
PN_VAR_CONSTRAINTS_ALL_DFV PN_VAR_CONSTRAINTS Constraints
PN_VAR_LINES_ALL_DFV PN_VAR_LINES Line Items
PN_VAR_VOL_HIST_ALL_DFV PN_VAR_VOL_HIST Volume History
PN_VAR_BKPTS_HEAD_ALL_DFV PN_VAR_BKPTS_HEAD Breakpoints
PN_VAR_BKPTS_DET_ALL_DFV PN_VAR_BKPTS_DETAIL Breakpoints Details
PN_VAR_DEDUCTIONS_ALL_DFV PN_VAR_DEDUCTIONS Deductions
PN_VAR_RENT_INV_ALL_DFV PN_VAR_ADJUST Adjustment History
PN_LOC_ACC_MAP_HDR_ALL_DFV PN_LOC_ACC_MAP_HDR Location Account Mapping Header
PN_LOC_ACC_MAP_ALL_DFV PN_LOC_ACC_MAP Location Account Mapping
PN_VAR_BKHD_DEFAULTS_ALL_DFV pn_var_bkhd_def Breakpoint Header Defaults
PN_VAR_BKDT_DEFAULTS_ALL_DFV pn_var_bkdt_def Breakpoint Details Defaults
PN_VAR_CONSTR_DEFAULTS_ALL_DFV PN_VAR_CON_DEF Constraints Defaults
PN_VAR_LINE_TEMPLATES_ALL_DFV pn_var_line_temp_def Variable Rent Line Template
PN_VAR_TEMPLATES_ALL_DFV pn_var_templates_def Variable Rent Template
PN_VAR_LINE_DEFAULTS_ALL_DFV PN_VAR_LINE_DEF Line Defaults
PN_PAYMENT_ITEMS_ALL_DFV PN_PAYMENT_ITEMS Payment Item Flexfield
PN_PAYMENT_TERMS_HISTORY_DFV PN_PAYMENT_TERMS_HISTORY Terms History
PN_DISTRIBUTIONS_HISTORY_DFV PN_DISTRIBUTIONS_HISTORY Distributions History

Tags: , , No Comments »

by oracleguru

Property Manager Profile Options

ORACLE APPS COMMUNITY > Tutorial > PN

Oracle Property Manager Profile Options

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
PN_VOLUME_STATUS_DEFAULT PN: Volume Status Default
PN_AREA_TYPE PN: Area Type in Annual Per Area
PN_IR_TERM_END_DATE PN: End Date For Base Year Reference Rent Increase Terms
PN_CHG_TEN_WHEN_LEASE_CHG PN: Change Tenancy Dates When Lease Dates Change
PN_TENANCY_UPDATE PN: Tenancy Update
PN_VALIDATE_ASSIGN_CC PN: Validate Assignment Cost Centers
PN_RENT_INCREASE_TERM_END_DATE PN: Rent Increase Term End Date
PN_RI_BACKBILL_TYPE PN: Rent Increase Calculated After Assessment Date
PN_VAR_CALCULATE_ALL_OPTION PN: Show Calculate and Calculate All Buttons for Variable Rent
PN_ERLY_TMNT_B4_LST_APP_SCHD PN: Allow Early Termination Before Last Approved Schedule
PN_VAR_VOL_INV_PRD PN: Require Volume For Entire Invoice Period

Tags: , No Comments »