Friday 22 January 2016

Oracle Property table list in oracle apps

Property:

PN_PROPERTIES_ALL
PN_LOCATIONS_ALL

Leases :

PN_LEASES_ALL
PN_LEASE_DETAILS_ALL
PN_OPTIONS_ALL
PN_PAYMENT_TERMS_ALL
PN_DISTRIBUTIONS_ALL

Variable Rent Agreement:

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

Full list is here:

PN_ACCOUNTING_EVENTS_ALL
PN_ADDRESSES_ALL
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_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_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_PHONES_ALL
PN_PROPERTIES_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
PN_REC_EXP_ITF
PN_REC_EXPCL_DTL_ALL
PN_REC_EXPCL_DTLLN_ALL
PN_REC_EXPCL_DTLACC_ALL
PN_REC_ARCL_ALL
PN_REC_ARCL_EXC_ALL
PN_REC_EXP_LINE_ALL
PN_REC_EXP_LINE_DTL_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_DTL_ALL
PN_REC_ARCL_DTLLN_ALL
PN_REC_EXPCL_ALL
PN_REC_EXPCL_TYPE_ALL
PN_REC_EXPCL_INC_ALL
PN_LOC_ACC_MAP_ALL
PN_LOC_ACC_MAP_HDR_ALL
PN_REC_CALC_PERIODS_ALL
PN_REC_PERIOD_BILL_ALL
PN_REC_PERIOD_LINES_ALL
PN_REC_LINBILL_ALL
PN_PAY_GROUP_RULES
PN_PAY_GROUP_BYS
PN_ADJUSTMENT_DETAILS
PN_ADJUSTMENT_SUMMARIES
PN_DISTRIBUTIONS_HISTORY
PN_PAYMENT_TERMS_HISTORY
PN_VAR_BKHD_DEFAULTS_ALL
PN_VAR_TEMPLATES_ALL
PN_VAR_CONSTR_TEMPLATES_ALL
PN_VAR_CONSTR_DEFAULTS_ALL
PN_VAR_LINE_TEMPLATES_ALL
PN_VAR_BKDT_DEFAULTS_ALL
PN_VAR_TRX_DETAILS_ALL
PN_VAR_TRX_HEADERS_ALL
PN_VAR_ABAT_DEFAULTS_ALL
PN_VAR_DEDUCT_ARCH_ALL
PN_RENT_INCREASE_SUMMARY_ITF
PN_VAR_VOL_ARCH_ALL
PN_OPEX_AGREEMENTS_ALL
PN_OPEX_PRORAT_BASIS_DTLS_ALL
PN_OPEX_EST_PAYMENTS_ALL
PN_OPEX_CRITICAL_DATES_ALL
PN_OPEX_NOTES_ALL
PN_OPEX_RECON_ALL
PN_OPEX_RECON_PRTBS_ALL
PN_OPEX_RECON_EXP_GRP_ALL
PN_OPEX_RECON_DETAILS_ALL
PN_OPEX_EXP_GRPS_ALL
PN_OPEX_RECON_CRDT_ALL
PN_VAR_REPORT_DATES_ALL
PN_RENT_INCREASE_DETAIL_ITF
PN_RENT_INCREASE_DETAILACC_ITF
PN_VAR_LINE_DEFAULTS_ALL

No comments:

Post a Comment