Oracle Application

  select dbms_metadata.get_ddl('VIEW',' PO_LINES_INQ_V','APPS') from dual;

  SELECT     x.process_type       "Name",     decode((         SELECT             '1'         FROM             apps.fnd_co...

TABLE:  RCV_TRANSACTIONS COLUMN: ROUTING_HEADER_ID VALUES:  1 (Standard Receipt),  2 (Inspection Required) And  3 (Direct Delivery). ...