CREATE OR REPLACE 
VIEW PROJECT_MST_VW AS
SELECT * FROM `INDEPENDENT_MST` WHERE TYP_ID = 246;


CREATE OR REPLACE VIEW PROJECT_DETAILS_VW AS
SELECT * FROM `prj_req_mst` WHERE REQ_TYPE_ID =246
AND PARENT_ID IS NULL;

CREATE OR REPLACE 
VIEW RELEASE_MST_VW AS
SELECT * FROM `INDEPENDENT_MST` WHERE TYP_ID = 247;


CREATE OR REPLACE VIEW RELEASE_DETAILS_VW AS
SELECT R.* , PD.REQ_TYPE_NM PROJECT_NM 
FROM `prj_req_mst` R, PROJECT_DETAILS_VW PD 
WHERE R.PARENT_ID = PD.PRJ_REQ_ID 
AND PR.REQ_TYPE_ID =247;

CREATE OR REPLACE 
VIEW ITERATION_MST_VW AS
SELECT * FROM `INDEPENDENT_MST` WHERE TYP_ID = 248;


CREATE OR REPLACE VIEW ITERATION_DETAILS_VW AS
SELECT * FROM `prj_req_mst` ID, RELEASE_DETAILS_VW RD
WHERE R.PARENT_ID = PD.PRJ_REQ_ID 
ID.REQ_TYPE_ID =248;

CREATE OR REPLACE 
VIEW SPRINT_MST_VW AS
SELECT * FROM `INDEPENDENT_MST` WHERE TYP_ID = 249;


CREATE OR REPLACE VIEW SPRINT_DETAILS_VW AS
SELECT * FROM `prj_req_mst` WHERE REQ_TYPE_ID =249;

CREATE OR REPLACE 
VIEW TASKLIST_MST_VW AS
SELECT * FROM `INDEPENDENT_MST` WHERE TYP_ID = 250;


CREATE OR REPLACE VIEW TASKLIST_DETAILS_VW AS
SELECT * FROM `prj_req_mst` WHERE REQ_TYPE_ID =250;

CREATE OR REPLACE 
VIEW TASK_MST_VW AS
SELECT * FROM `INDEPENDENT_MST` WHERE TYP_ID = 251;


CREATE OR REPLACE VIEW TASK_DETAILS_VW AS
SELECT * FROM `prj_req_mst` WHERE REQ_TYPE_ID =251;