{"action":"created","issue":{"url":"https://api.github.com/repos/GCSO2/D3S-INVENTORY/issues/99","repository_url":"https://api.github.com/repos/GCSO2/D3S-INVENTORY","labels_url":"https://api.github.com/repos/GCSO2/D3S-INVENTORY/issues/99/labels{/name}","comments_url":"https://api.github.com/repos/GCSO2/D3S-INVENTORY/issues/99/comments","events_url":"https://api.github.com/repos/GCSO2/D3S-INVENTORY/issues/99/events","html_url":"https://github.com/GCSO2/D3S-INVENTORY/issues/99","id":150971981,"number":99,"title":"Cloud: VMRS Screen","user":{"login":"giovanicani","id":5666297,"avatar_url":"https://avatars.githubusercontent.com/u/5666297?v=3","gravatar_id":"","url":"https://api.github.com/users/giovanicani","html_url":"https://github.com/giovanicani","followers_url":"https://api.github.com/users/giovanicani/followers","following_url":"https://api.github.com/users/giovanicani/following{/other_user}","gists_url":"https://api.github.com/users/giovanicani/gists{/gist_id}","starred_url":"https://api.github.com/users/giovanicani/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/giovanicani/subscriptions","organizations_url":"https://api.github.com/users/giovanicani/orgs","repos_url":"https://api.github.com/users/giovanicani/repos","events_url":"https://api.github.com/users/giovanicani/events{/privacy}","received_events_url":"https://api.github.com/users/giovanicani/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/GCSO2/D3S-INVENTORY/labels/work%20in%20progress","name":"work in progress","color":"84b6eb"}],"state":"open","locked":false,"assignee":{"login":"tufailzafar","id":5826517,"avatar_url":"https://avatars.githubusercontent.com/u/5826517?v=3","gravatar_id":"","url":"https://api.github.com/users/tufailzafar","html_url":"https://github.com/tufailzafar","followers_url":"https://api.github.com/users/tufailzafar/followers","following_url":"https://api.github.com/users/tufailzafar/following{/other_user}","gists_url":"https://api.github.com/users/tufailzafar/gists{/gist_id}","starred_url":"https://api.github.com/users/tufailzafar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tufailzafar/subscriptions","organizations_url":"https://api.github.com/users/tufailzafar/orgs","repos_url":"https://api.github.com/users/tufailzafar/repos","events_url":"https://api.github.com/users/tufailzafar/events{/privacy}","received_events_url":"https://api.github.com/users/tufailzafar/received_events","type":"User","site_admin":false},"milestone":null,"comments":5,"created_at":"2016-04-25T20:28:43Z","updated_at":"2016-04-28T10:49:42Z","closed_at":null,"body":"- Move the 3 add buttons on the panel below to save space\r\n- How can I delete a record ? If record is being used, and user tries to delete record, like everywhere else in the system it should let the user know, and only allow deactivation.\r\n- Add a popup on the VMRS Assemblies grid to assign job types. See table script below.\r\n\r\n![image](https://cloud.githubusercontent.com/assets/5666297/14797403/ad65a0ea-0b00-11e6-8136-f0b7630a6e65.png)\r\n\r\n\r\n```sql\r\n\r\nCREATE TABLE pm_vmrs_sys_asy_job_types(create_date        TIMESTAMP WITH TIME ZONE NOT NULL\r\n,create_user         VARCHAR2(30) NOT NULL\r\n,last_update_date    TIMESTAMP WITH TIME ZONE\r\n,last_update_user    VARCHAR2(30)\r\n,ten_id              NUMBER NOT NULL\r\n,vmrsysasyjobtyp_id  NUMBER NOT NULL)\r\nTABLESPACE TCS_01_TS;\r\n/\r\n\r\nALTER TABLE pm_vmrs_sys_asy_job_types ADD (vmrsysass_id NUMBER NOT NULL);\r\nALTER TABLE pm_vmrs_sys_asy_job_types ADD (jobtyp_id NUMBER NOT NULL);\r\n/\r\n\r\nALTER TABLE pm_vmrs_sys_asy_job_types ADD CONSTRAINT vmrsysasyjobtyp_pk PRIMARY KEY (vmrsysasyjobtyp_id);\r\nALTER TABLE pm_vmrs_sys_asy_job_types ADD CONSTRAINT vmrsysasyjobtyp_sysasyjt_uk UNIQUE(vmrsysass_id, jobtyp_id);\r\nALTER TABLE pm_vmrs_sys_asy_job_types ADD CONSTRAINT vmrsysasyjobtyp_ten_fk FOREIGN KEY(ten_id) REFERENCES sys_tenants(ten_id);\r\nALTER TABLE pm_vmrs_sys_asy_job_types ADD CONSTRAINT vmrsysasyjobtyp_jobtyp_fk FOREIGN KEY(jobtyp_id) REFERENCES adm_job_types(jobtyp_id);\r\nALTER TABLE pm_vmrs_sys_asy_job_types ADD CONSTRAINT vmrsysasyjobtyp_vmrsysass_fk FOREIGN KEY(vmrsysass_id) REFERENCES pm_vmrs_system_assemblies(vmrsysass_id);\r\n/\r\n\r\nCREATE OR REPLACE TRIGGER pm_vmrs_sys_asy_job_types_briu\r\nBEFORE INSERT OR UPDATE ON pm_vmrs_sys_asy_job_types\r\nFOR EACH ROW\r\nBEGIN\r\n   IF inserting THEN\r\n      IF :new.vmrsysasyjobtyp_id IS NULL THEN\r\n         :new.vmrsysasyjobtyp_id := oraseq.nextval;\r\n      END IF;\r\n      :new.create_date := systimestamp;\r\n      :new.create_user := NVL(system_functions_pkg.get_context_value('user_user_name'),user);\r\n      IF :new.ten_id is null THEN\r\n         :new.ten_id := system_functions_pkg.get_ten_id_from_context();\r\n      END IF;\r\n   ELSE\r\n      :new.last_update_date := systimestamp;\r\n      :new.last_update_user := NVL(system_functions_pkg.get_context_value('user_user_name'),user);\r\n   END IF;\r\nEND pm_vmrs_sys_asy_job_types_briu;\r\n/\r\n\r\nCREATE OR REPLACE VIEW pm_vmrs_sys_asy_job_types_wv AS\r\nSELECT create_date\r\n      ,create_user\r\n      ,last_update_date\r\n      ,last_update_user\r\n      ,ten_id\r\n      ,vmrsysasyjobtyp_id\r\n      ,vmrsysass_id\r\n      ,jobtyp_id\r\n FROM pm_vmrs_sys_asy_job_types;\r\n/\r\n\r\nGRANT select, update, insert, delete ON tcs_owner.pm_vmrs_sys_asy_job_types_wv TO tcs_default_role;\r\nCREATE OR REPLACE PUBLIC SYNONYM pm_vmrs_sys_asy_job_types_wv FOR tcs_owner.pm_vmrs_sys_asy_job_types_wv;\r\n/\r\n```\r\n\r\nVMRS Assembly should look like this. Associate job type will allow user to select job types associated to that assembly record.\r\n![image](https://cloud.githubusercontent.com/assets/5666297/14797832/9e3fe8e4-0b02-11e6-98d0-634f14fb0b8a.png)\r\n"},"comment":{"url":"https://api.github.com/repos/GCSO2/D3S-INVENTORY/issues/comments/215385978","html_url":"https://github.com/GCSO2/D3S-INVENTORY/issues/99#issuecomment-215385978","issue_url":"https://api.github.com/repos/GCSO2/D3S-INVENTORY/issues/99","id":215385978,"user":{"login":"d3sqa","id":13255706,"avatar_url":"https://avatars.githubusercontent.com/u/13255706?v=3","gravatar_id":"","url":"https://api.github.com/users/d3sqa","html_url":"https://github.com/d3sqa","followers_url":"https://api.github.com/users/d3sqa/followers","following_url":"https://api.github.com/users/d3sqa/following{/other_user}","gists_url":"https://api.github.com/users/d3sqa/gists{/gist_id}","starred_url":"https://api.github.com/users/d3sqa/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/d3sqa/subscriptions","organizations_url":"https://api.github.com/users/d3sqa/orgs","repos_url":"https://api.github.com/users/d3sqa/repos","events_url":"https://api.github.com/users/d3sqa/events{/privacy}","received_events_url":"https://api.github.com/users/d3sqa/received_events","type":"User","site_admin":false},"created_at":"2016-04-28T10:49:41Z","updated_at":"2016-04-28T10:49:41Z","body":"De-associating Job Type from the assembly has been incorporate. Please see screenshots below:\r\n\r\n![image](https://cloud.githubusercontent.com/assets/13255706/14883673/c7edea12-0d58-11e6-8750-1ae5bd76f000.png)\r\n\r\n![image](https://cloud.githubusercontent.com/assets/13255706/14883675/d07de2cc-0d58-11e6-8255-a875216d1463.png)\r\n"}}