![]() SUM(CASE WHEN wv.currency_type = 'REPORTING' THEN wv.totalamount END) rpt_amt, SUM(CASE WHEN wv.currency_type = 'REPORTING' THEN wv.totalcost END) rpt_totalcost, SUM(CASE WHEN wv.currency_type = 'NATURAL' THEN wv.rate_exchange_rate END) natural_rate, MAX(CASE WHEN wv.currency_type = 'NATURAL'THEN wv.currency_code END) natural_curr, SUM(CASE WHEN wv.currency_type = 'NATURAL' THEN wv.totalamount END) natural_amt, SUM(CASE WHEN wv.currency_type = 'NATURAL' THEN wv.totalcost END) natural_totalcost, SUM(CASE WHEN wv.currency_type = 'HOME' THEN wv.rate_exchange_rate END) home_rate, MAX(CASE WHEN wv.currency_type = 'HOME'THEN wv.currency_code END) home_curr, SUM(CASE WHEN wv.currency_type = 'HOME' THEN wv.totalamount END) home_amt, SUM(CASE WHEN wv.currency_type = 'HOME' THEN wv.totalcost END) home_totalcost, Resclass.resource_class resource_class_id, UPPER(inv.odf_object_code) inv_object_code_upper,ĬASE WHEN t.prexternalid = '~rmw' THEN tname.name ELSE t.prname END task_name,ĬASE WHEN t.prexternalid = '~rmw' THEN 0 ELSE 1 END task_disable, This table stores supplemental accounts payable (AP) information for transactions imported from an AP system.įollowing Query is used to fetch the data from View This table stores the the values for a static lookup type. This table stores information about the project class. This table stores resource class information. This table stores the work in progress (WIP) class information. This table stores the department details for financial properties. This table stores the financial locations. This table stores financial entity details. This table stores the names of type codes. This table stores the transaction class information. This table stores multi-currency values for rows in the PPA_WIP table. A row is created in this table when a new resource is added in the Application. This table stores the resource related information. This table is used to generate lists of tasks and to record and present information on tasks in various views. This table stores CA Clarity PPM-defined data common to all investments ( Projects, Products, Assets, Applicatins etc.). This table stores all primary transactions (Labor, Materials, Equipment, and Expense).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |