Showing posts with label Property Management. Show all posts
Showing posts with label Property Management. Show all posts

December 24, 2011

Important Tables in PM

PN_LEASES_ALL
PN_LEASE_DETAILS_ALL
PN_LEASE_DETAILS_HISTORY
PN_LOCATIONS_ALL
PN_PROPERTIES_ALL
PN_ADDRESSES_ALL
at No comments:
Labels:
Subscribe to: Posts (Atom)

COALESCE-SQL

Coalesce- return the null values from the expression. It works similar to a case statement where if expression 1 is false then goes to expr...

  • Custom Report Notes:
    While Registering the report to instance we need to make sure od date format: 1.The default type is YYYY/MM/DD HH24:MI:SS   go to propert...
  • Order To Cash
    Order to cash normally refer to the process in which taking customer sale order via different sales channel like email, internet, sales pers...
  • Number into word
    This is easily done with the following command: select to_char(to_date('56789','J'),'JSP') from dual / TO_CHAR...