How can I handle duplicate Integration ID's in Oracle database?
0
CREATE OR REPLACE FORCE EDITIONABLE VIEW VIEW1("CAN_NUM", "J_GROUP", "PI_COMP_DT", "LAST_PI_COMP_DT", "DIFF_DATE", "J_FAM_N", "R_NUM", "LST_SM_DT", "INTEGRATION_ID", "MTVE_NAME", "WRKFLW_NM", "TRK_STS_NAM", "TRK_STEP_NAM", "ACT_CAND") AS
SELECT
ORES.CAN_NUM,
ORES.J_GROUP,
ORES.PI_COMP_DT,
ORES.LAST_PI_COMP_DT,
ORES.DIFF_DATE,
ORES.J_FAM_N,
ORES.R_NUM,
ORES.LST_SM_DT,
ORES.INTEGRATION_ID,
ORES.MTVE_NAME,
ORES.WRKFLW_NM,
ORES.TRK_STS_NAM,
ORES.TRK_STEP_NAM,
CASE WHEN DIFF_DATE = 0 AND PI_COMP_DT = LAST_PI_COMP_DT THEN 1 ELSE 0 END AS ACT_CAND
FROM
(
SELECT *
FROM
(
SELECT IR.*
FROM
(
SELECT
APP_FACT.PI_CANDIDATE_NUM AS CAN_NUM,
JOB_INFO_D.J_GROUP AS J_GROUP,
JOB_INFO_D.J_FAM_N AS J_FAM_N,
REQN_D.R_NUM AS R_NUM,
APP_FACT.LAST_SBM_DT AS LST_SM_DT,
APP_FACT.PI_COMP_DT AS PI_COMP_DT,
APP_FACT.INTEGRATION_ID AS INTEGRATION_ID,
APP_FACT.WRKFLW_NM AS WRKFLW_NM,
APP_FACT.TRK_STS_NAM AS TRK_STS_NAM,
APP_FACT.TRK_STEP_NAM AS TRK_STEP_NAM,
MOTIVES_D.MTVE_NAME AS MTVE_NAME,
CASE
WHEN APP_FACT.INITIAL_APP_MEDIUM_ROW_WID NOT IN
(SELECT ROW_WID FROM WC_APPLICATION_MEDIUM_D WHERE CODE IN ('IMPORT','MATCHED_TO_JOB','RESUME'))
AND APP_FACT.APP_MEDIUM_ROW_WID NOT IN
(SELECT ROW_WID FROM WC_APPLICATION_MEDIUM_D WHERE CODE IN ('IMPORT','MATCHED_TO_JOB','RESUME'))
THEN 1
ELSE null END VALID_CANDIDATE
FROM
ABC_EVENT_F APP_FACT,
DEF_ROD_D REQN_D,
GHI_INFO_D JOB_INFO_D,
JKL_APPLE_MTV_D MOTIVES_D
WHERE APP_FACT.REQUISITION_ROW_WID = REQN_D.ROW_WID
AND APP_FACT.JOB_INFO_ROW_WID = JOB_INFO_D.ROW_WID
AND MOTIVES_D.APP_EVENT_WID =APP_FACT.APPL_CSW_MOTIVES_WID
ORDER BY APP_FACT.PI_CANDIDATE_NUM,JOB_INFO_D.J_GROUP ASC
) IR
WHERE IR.VALID_CANDIDATE = 1
)
MATCH_RECOGNIZE (
PARTITION BY CAN_NUM, J_GROUP ,INTEGRATION_ID
ORDER BY PI_COMP_DT
MEASURES strt.PI_COMP_DT AS LAST_PI_COMP_DT,
TRUNC(PI_COMP_DT) - trunc(strt.PI_COMP_DT) AS DIFF_DATE
ALL ROWS PER MATCH
PATTERN (strt same*)
DEFINE same AS same.PI_COMP_DT <= strt.PI_COMP_DT + 182
) MR
ORDER BY MR.CAN_NUM, MR.J_GROUP,MR.INTEGRATION_ID,MR.PI_COMP_DT
)ORES
UNION ALL
SELECT "CAN_NUM","J_GROUP","PI_COMP_DT","LAST_PI_COMP_DT","DIFF_DATE","J_FAM_N","R_NUM","LST_SM_DT","INTEGRATION_ID","WRKFLW_NM","TRK_STS_NAM","TRK_STEP_NAM","MTVE_NAME","ACT_CAND" FROM
(
SELECT
APP_FACT.PI_CANDIDATE_NUM AS CAN_NUM,
JOB_INFO_D.J_GROUP AS J_GROUP,
APP_FACT.PI_COMP_DT AS PI_COMP_DT,
NULL AS LAST_PI_COMP_DT,
NULL AS DIFF_DATE,
JOB_INFO_D.J_FAM_N AS J_FAM_N,
REQN_D.R_NUM AS R_NUM,
APP_FACT.LAST_SBM_DT AS LST_SM_DT,
APP_FACT.INTEGRATION_ID AS INTEGRATION_ID,
APP_FACT.WRKFLW_NM AS WRKFLW_NM,
APP_FACT.TRK_STS_NAM AS TRK_STS_NAM,
APP_FACT.TRK_STEP_NAM AS TRK_STEP_NAM,
MOTIVES_D.MTVE_NAME AS MTVE_NAME,
CASE
WHEN APP_FACT.INITIAL_APP_MEDIUM_ROW_WID IN
(SELECT ROW_WID FROM WC_APPLICATION_MEDIUM_D WHERE CODE IN ('IMPORT','MATCHED_TO_JOB','RESUME'))
OR APP_FACT.APP_MEDIUM_ROW_WID IN
(SELECT ROW_WID FROM WC_APPLICATION_MEDIUM_D WHERE CODE IN ('IMPORT','MATCHED_TO_JOB','RESUME'))
THEN 0
ELSE null END ACT_CAND
FROM
ABC_EVENT_F APP_FACT,
DEF_ROD_D REQN_D,
GHI_INFO_D JOB_INFO_D,
JKL_APPLE_MTV_D MOTIVES_D
WHERE APP_FACT.REQUISITION_ROW_WID = REQN_D.ROW_WID
AND APP_FACT.JOB_INFO_ROW_WID = JOB_INFO_D.ROW_WID
AND MOTIVES_D.APP_EVENT_WID = APP_FACT.APPL_CSW_MOTIVES_WID
ORDER BY APP_FACT.PI_CANDIDATE_NUM,APP_FACT.INTEGRATION_ID,JOB_INFO_D.J_GROUP ASC
) IR1 WHERE IR1.ACT_CAND = 0;
oracle plsql-developer
edited 6 mins ago
McNets
15k41858
asked 1 hour ago
SlySly
63
add a comment |
0
CREATE OR REPLACE FORCE EDITIONABLE VIEW VIEW1("CAN_NUM", "J_GROUP", "PI_COMP_DT", "LAST_PI_COMP_DT", "DIFF_DATE", "J_FAM_N", "R_NUM", "LST_SM_DT", "INTEGRATION_ID", "MTVE_NAME", "WRKFLW_NM", "TRK_STS_NAM", "TRK_STEP_NAM", "ACT_CAND") AS
SELECT
ORES.CAN_NUM,
ORES.J_GROUP,
ORES.PI_COMP_DT,
ORES.LAST_PI_COMP_DT,
ORES.DIFF_DATE,
ORES.J_FAM_N,
ORES.R_NUM,
ORES.LST_SM_DT,
ORES.INTEGRATION_ID,
ORES.MTVE_NAME,
ORES.WRKFLW_NM,
ORES.TRK_STS_NAM,
ORES.TRK_STEP_NAM,
CASE WHEN DIFF_DATE = 0 AND PI_COMP_DT = LAST_PI_COMP_DT THEN 1 ELSE 0 END AS ACT_CAND
FROM
(
SELECT *
FROM
(
SELECT IR.*
FROM
(
SELECT
APP_FACT.PI_CANDIDATE_NUM AS CAN_NUM,
JOB_INFO_D.J_GROUP AS J_GROUP,
JOB_INFO_D.J_FAM_N AS J_FAM_N,
REQN_D.R_NUM AS R_NUM,
APP_FACT.LAST_SBM_DT AS LST_SM_DT,
APP_FACT.PI_COMP_DT AS PI_COMP_DT,
APP_FACT.INTEGRATION_ID AS INTEGRATION_ID,
APP_FACT.WRKFLW_NM AS WRKFLW_NM,
APP_FACT.TRK_STS_NAM AS TRK_STS_NAM,
APP_FACT.TRK_STEP_NAM AS TRK_STEP_NAM,
MOTIVES_D.MTVE_NAME AS MTVE_NAME,
CASE
WHEN APP_FACT.INITIAL_APP_MEDIUM_ROW_WID NOT IN
(SELECT ROW_WID FROM WC_APPLICATION_MEDIUM_D WHERE CODE IN ('IMPORT','MATCHED_TO_JOB','RESUME'))
AND APP_FACT.APP_MEDIUM_ROW_WID NOT IN
(SELECT ROW_WID FROM WC_APPLICATION_MEDIUM_D WHERE CODE IN ('IMPORT','MATCHED_TO_JOB','RESUME'))
THEN 1
ELSE null END VALID_CANDIDATE
FROM
ABC_EVENT_F APP_FACT,
DEF_ROD_D REQN_D,
GHI_INFO_D JOB_INFO_D,
JKL_APPLE_MTV_D MOTIVES_D
WHERE APP_FACT.REQUISITION_ROW_WID = REQN_D.ROW_WID
AND APP_FACT.JOB_INFO_ROW_WID = JOB_INFO_D.ROW_WID
AND MOTIVES_D.APP_EVENT_WID =APP_FACT.APPL_CSW_MOTIVES_WID
ORDER BY APP_FACT.PI_CANDIDATE_NUM,JOB_INFO_D.J_GROUP ASC
) IR
WHERE IR.VALID_CANDIDATE = 1
)
MATCH_RECOGNIZE (
PARTITION BY CAN_NUM, J_GROUP ,INTEGRATION_ID
ORDER BY PI_COMP_DT
MEASURES strt.PI_COMP_DT AS LAST_PI_COMP_DT,
TRUNC(PI_COMP_DT) - trunc(strt.PI_COMP_DT) AS DIFF_DATE
ALL ROWS PER MATCH
PATTERN (strt same*)
DEFINE same AS same.PI_COMP_DT <= strt.PI_COMP_DT + 182
) MR
ORDER BY MR.CAN_NUM, MR.J_GROUP,MR.INTEGRATION_ID,MR.PI_COMP_DT
)ORES
UNION ALL
SELECT "CAN_NUM","J_GROUP","PI_COMP_DT","LAST_PI_COMP_DT","DIFF_DATE","J_FAM_N","R_NUM","LST_SM_DT","INTEGRATION_ID","WRKFLW_NM","TRK_STS_NAM","TRK_STEP_NAM","MTVE_NAME","ACT_CAND" FROM
(
SELECT
APP_FACT.PI_CANDIDATE_NUM AS CAN_NUM,
JOB_INFO_D.J_GROUP AS J_GROUP,
APP_FACT.PI_COMP_DT AS PI_COMP_DT,
NULL AS LAST_PI_COMP_DT,
NULL AS DIFF_DATE,
JOB_INFO_D.J_FAM_N AS J_FAM_N,
REQN_D.R_NUM AS R_NUM,
APP_FACT.LAST_SBM_DT AS LST_SM_DT,
APP_FACT.INTEGRATION_ID AS INTEGRATION_ID,
APP_FACT.WRKFLW_NM AS WRKFLW_NM,
APP_FACT.TRK_STS_NAM AS TRK_STS_NAM,
APP_FACT.TRK_STEP_NAM AS TRK_STEP_NAM,
MOTIVES_D.MTVE_NAME AS MTVE_NAME,
CASE
WHEN APP_FACT.INITIAL_APP_MEDIUM_ROW_WID IN
(SELECT ROW_WID FROM WC_APPLICATION_MEDIUM_D WHERE CODE IN ('IMPORT','MATCHED_TO_JOB','RESUME'))
OR APP_FACT.APP_MEDIUM_ROW_WID IN
(SELECT ROW_WID FROM WC_APPLICATION_MEDIUM_D WHERE CODE IN ('IMPORT','MATCHED_TO_JOB','RESUME'))
THEN 0
ELSE null END ACT_CAND
FROM
ABC_EVENT_F APP_FACT,
DEF_ROD_D REQN_D,
GHI_INFO_D JOB_INFO_D,
JKL_APPLE_MTV_D MOTIVES_D
WHERE APP_FACT.REQUISITION_ROW_WID = REQN_D.ROW_WID
AND APP_FACT.JOB_INFO_ROW_WID = JOB_INFO_D.ROW_WID
AND MOTIVES_D.APP_EVENT_WID = APP_FACT.APPL_CSW_MOTIVES_WID
ORDER BY APP_FACT.PI_CANDIDATE_NUM,APP_FACT.INTEGRATION_ID,JOB_INFO_D.J_GROUP ASC
) IR1 WHERE IR1.ACT_CAND = 0;
oracle plsql-developer
edited 6 mins ago
McNets
15k41858
asked 1 hour ago
SlySly
63
How do you expect anyone to help you without showing your table definitions and the query?
– mustaccio
33 mins ago
I have added my code that I am running to create the view,
– Sly
14 mins ago
add a comment |
0
0
0
CREATE OR REPLACE FORCE EDITIONABLE VIEW VIEW1("CAN_NUM", "J_GROUP", "PI_COMP_DT", "LAST_PI_COMP_DT", "DIFF_DATE", "J_FAM_N", "R_NUM", "LST_SM_DT", "INTEGRATION_ID", "MTVE_NAME", "WRKFLW_NM", "TRK_STS_NAM", "TRK_STEP_NAM", "ACT_CAND") AS
SELECT
ORES.CAN_NUM,
ORES.J_GROUP,
ORES.PI_COMP_DT,
ORES.LAST_PI_COMP_DT,
ORES.DIFF_DATE,
ORES.J_FAM_N,
ORES.R_NUM,
ORES.LST_SM_DT,
ORES.INTEGRATION_ID,
ORES.MTVE_NAME,
ORES.WRKFLW_NM,
ORES.TRK_STS_NAM,
ORES.TRK_STEP_NAM,
CASE WHEN DIFF_DATE = 0 AND PI_COMP_DT = LAST_PI_COMP_DT THEN 1 ELSE 0 END AS ACT_CAND
FROM
(
SELECT *
FROM
(
SELECT IR.*
FROM
(
SELECT
APP_FACT.PI_CANDIDATE_NUM AS CAN_NUM,
JOB_INFO_D.J_GROUP AS J_GROUP,
JOB_INFO_D.J_FAM_N AS J_FAM_N,
REQN_D.R_NUM AS R_NUM,
APP_FACT.LAST_SBM_DT AS LST_SM_DT,
APP_FACT.PI_COMP_DT AS PI_COMP_DT,
APP_FACT.INTEGRATION_ID AS INTEGRATION_ID,
APP_FACT.WRKFLW_NM AS WRKFLW_NM,
APP_FACT.TRK_STS_NAM AS TRK_STS_NAM,
APP_FACT.TRK_STEP_NAM AS TRK_STEP_NAM,
MOTIVES_D.MTVE_NAME AS MTVE_NAME,
CASE
WHEN APP_FACT.INITIAL_APP_MEDIUM_ROW_WID NOT IN
(SELECT ROW_WID FROM WC_APPLICATION_MEDIUM_D WHERE CODE IN ('IMPORT','MATCHED_TO_JOB','RESUME'))
AND APP_FACT.APP_MEDIUM_ROW_WID NOT IN
(SELECT ROW_WID FROM WC_APPLICATION_MEDIUM_D WHERE CODE IN ('IMPORT','MATCHED_TO_JOB','RESUME'))
THEN 1
ELSE null END VALID_CANDIDATE
FROM
ABC_EVENT_F APP_FACT,
DEF_ROD_D REQN_D,
GHI_INFO_D JOB_INFO_D,
JKL_APPLE_MTV_D MOTIVES_D
WHERE APP_FACT.REQUISITION_ROW_WID = REQN_D.ROW_WID
AND APP_FACT.JOB_INFO_ROW_WID = JOB_INFO_D.ROW_WID
AND MOTIVES_D.APP_EVENT_WID =APP_FACT.APPL_CSW_MOTIVES_WID
ORDER BY APP_FACT.PI_CANDIDATE_NUM,JOB_INFO_D.J_GROUP ASC
) IR
WHERE IR.VALID_CANDIDATE = 1
)
MATCH_RECOGNIZE (
PARTITION BY CAN_NUM, J_GROUP ,INTEGRATION_ID
ORDER BY PI_COMP_DT
MEASURES strt.PI_COMP_DT AS LAST_PI_COMP_DT,
TRUNC(PI_COMP_DT) - trunc(strt.PI_COMP_DT) AS DIFF_DATE
ALL ROWS PER MATCH
PATTERN (strt same*)
DEFINE same AS same.PI_COMP_DT <= strt.PI_COMP_DT + 182
) MR
ORDER BY MR.CAN_NUM, MR.J_GROUP,MR.INTEGRATION_ID,MR.PI_COMP_DT
)ORES
UNION ALL
SELECT "CAN_NUM","J_GROUP","PI_COMP_DT","LAST_PI_COMP_DT","DIFF_DATE","J_FAM_N","R_NUM","LST_SM_DT","INTEGRATION_ID","WRKFLW_NM","TRK_STS_NAM","TRK_STEP_NAM","MTVE_NAME","ACT_CAND" FROM
(
SELECT
APP_FACT.PI_CANDIDATE_NUM AS CAN_NUM,
JOB_INFO_D.J_GROUP AS J_GROUP,
APP_FACT.PI_COMP_DT AS PI_COMP_DT,
NULL AS LAST_PI_COMP_DT,
NULL AS DIFF_DATE,
JOB_INFO_D.J_FAM_N AS J_FAM_N,
REQN_D.R_NUM AS R_NUM,
APP_FACT.LAST_SBM_DT AS LST_SM_DT,
APP_FACT.INTEGRATION_ID AS INTEGRATION_ID,
APP_FACT.WRKFLW_NM AS WRKFLW_NM,
APP_FACT.TRK_STS_NAM AS TRK_STS_NAM,
APP_FACT.TRK_STEP_NAM AS TRK_STEP_NAM,
MOTIVES_D.MTVE_NAME AS MTVE_NAME,
CASE
WHEN APP_FACT.INITIAL_APP_MEDIUM_ROW_WID IN
(SELECT ROW_WID FROM WC_APPLICATION_MEDIUM_D WHERE CODE IN ('IMPORT','MATCHED_TO_JOB','RESUME'))
OR APP_FACT.APP_MEDIUM_ROW_WID IN
(SELECT ROW_WID FROM WC_APPLICATION_MEDIUM_D WHERE CODE IN ('IMPORT','MATCHED_TO_JOB','RESUME'))
THEN 0
ELSE null END ACT_CAND
FROM
ABC_EVENT_F APP_FACT,
DEF_ROD_D REQN_D,
GHI_INFO_D JOB_INFO_D,
JKL_APPLE_MTV_D MOTIVES_D
WHERE APP_FACT.REQUISITION_ROW_WID = REQN_D.ROW_WID
AND APP_FACT.JOB_INFO_ROW_WID = JOB_INFO_D.ROW_WID
AND MOTIVES_D.APP_EVENT_WID = APP_FACT.APPL_CSW_MOTIVES_WID
ORDER BY APP_FACT.PI_CANDIDATE_NUM,APP_FACT.INTEGRATION_ID,JOB_INFO_D.J_GROUP ASC
) IR1 WHERE IR1.ACT_CAND = 0;
oracle plsql-developer
edited 6 mins ago
McNets
15k41858
asked 1 hour ago
SlySly
63
CREATE OR REPLACE FORCE EDITIONABLE VIEW VIEW1("CAN_NUM", "J_GROUP", "PI_COMP_DT", "LAST_PI_COMP_DT", "DIFF_DATE", "J_FAM_N", "R_NUM", "LST_SM_DT", "INTEGRATION_ID", "MTVE_NAME", "WRKFLW_NM", "TRK_STS_NAM", "TRK_STEP_NAM", "ACT_CAND") AS
SELECT
ORES.CAN_NUM,
ORES.J_GROUP,
ORES.PI_COMP_DT,
ORES.LAST_PI_COMP_DT,
ORES.DIFF_DATE,
ORES.J_FAM_N,
ORES.R_NUM,
ORES.LST_SM_DT,
ORES.INTEGRATION_ID,
ORES.MTVE_NAME,
ORES.WRKFLW_NM,
ORES.TRK_STS_NAM,
ORES.TRK_STEP_NAM,
CASE WHEN DIFF_DATE = 0 AND PI_COMP_DT = LAST_PI_COMP_DT THEN 1 ELSE 0 END AS ACT_CAND
FROM
(
SELECT *
FROM
(
SELECT IR.*
FROM
(
SELECT
APP_FACT.PI_CANDIDATE_NUM AS CAN_NUM,
JOB_INFO_D.J_GROUP AS J_GROUP,
JOB_INFO_D.J_FAM_N AS J_FAM_N,
REQN_D.R_NUM AS R_NUM,
APP_FACT.LAST_SBM_DT AS LST_SM_DT,
APP_FACT.PI_COMP_DT AS PI_COMP_DT,
APP_FACT.INTEGRATION_ID AS INTEGRATION_ID,
APP_FACT.WRKFLW_NM AS WRKFLW_NM,
APP_FACT.TRK_STS_NAM AS TRK_STS_NAM,
APP_FACT.TRK_STEP_NAM AS TRK_STEP_NAM,
MOTIVES_D.MTVE_NAME AS MTVE_NAME,
CASE
WHEN APP_FACT.INITIAL_APP_MEDIUM_ROW_WID NOT IN
(SELECT ROW_WID FROM WC_APPLICATION_MEDIUM_D WHERE CODE IN ('IMPORT','MATCHED_TO_JOB','RESUME'))
AND APP_FACT.APP_MEDIUM_ROW_WID NOT IN
(SELECT ROW_WID FROM WC_APPLICATION_MEDIUM_D WHERE CODE IN ('IMPORT','MATCHED_TO_JOB','RESUME'))
THEN 1
ELSE null END VALID_CANDIDATE
FROM
ABC_EVENT_F APP_FACT,
DEF_ROD_D REQN_D,
GHI_INFO_D JOB_INFO_D,
JKL_APPLE_MTV_D MOTIVES_D
WHERE APP_FACT.REQUISITION_ROW_WID = REQN_D.ROW_WID
AND APP_FACT.JOB_INFO_ROW_WID = JOB_INFO_D.ROW_WID
AND MOTIVES_D.APP_EVENT_WID =APP_FACT.APPL_CSW_MOTIVES_WID
ORDER BY APP_FACT.PI_CANDIDATE_NUM,JOB_INFO_D.J_GROUP ASC
) IR
WHERE IR.VALID_CANDIDATE = 1
)
MATCH_RECOGNIZE (
PARTITION BY CAN_NUM, J_GROUP ,INTEGRATION_ID
ORDER BY PI_COMP_DT
MEASURES strt.PI_COMP_DT AS LAST_PI_COMP_DT,
TRUNC(PI_COMP_DT) - trunc(strt.PI_COMP_DT) AS DIFF_DATE
ALL ROWS PER MATCH
PATTERN (strt same*)
DEFINE same AS same.PI_COMP_DT <= strt.PI_COMP_DT + 182
) MR
ORDER BY MR.CAN_NUM, MR.J_GROUP,MR.INTEGRATION_ID,MR.PI_COMP_DT
)ORES
UNION ALL
SELECT "CAN_NUM","J_GROUP","PI_COMP_DT","LAST_PI_COMP_DT","DIFF_DATE","J_FAM_N","R_NUM","LST_SM_DT","INTEGRATION_ID","WRKFLW_NM","TRK_STS_NAM","TRK_STEP_NAM","MTVE_NAME","ACT_CAND" FROM
(
SELECT
APP_FACT.PI_CANDIDATE_NUM AS CAN_NUM,
JOB_INFO_D.J_GROUP AS J_GROUP,
APP_FACT.PI_COMP_DT AS PI_COMP_DT,
NULL AS LAST_PI_COMP_DT,
NULL AS DIFF_DATE,
JOB_INFO_D.J_FAM_N AS J_FAM_N,
REQN_D.R_NUM AS R_NUM,
APP_FACT.LAST_SBM_DT AS LST_SM_DT,
APP_FACT.INTEGRATION_ID AS INTEGRATION_ID,
APP_FACT.WRKFLW_NM AS WRKFLW_NM,
APP_FACT.TRK_STS_NAM AS TRK_STS_NAM,
APP_FACT.TRK_STEP_NAM AS TRK_STEP_NAM,
MOTIVES_D.MTVE_NAME AS MTVE_NAME,
CASE
WHEN APP_FACT.INITIAL_APP_MEDIUM_ROW_WID IN
(SELECT ROW_WID FROM WC_APPLICATION_MEDIUM_D WHERE CODE IN ('IMPORT','MATCHED_TO_JOB','RESUME'))
OR APP_FACT.APP_MEDIUM_ROW_WID IN
(SELECT ROW_WID FROM WC_APPLICATION_MEDIUM_D WHERE CODE IN ('IMPORT','MATCHED_TO_JOB','RESUME'))
THEN 0
ELSE null END ACT_CAND
FROM
ABC_EVENT_F APP_FACT,
DEF_ROD_D REQN_D,
GHI_INFO_D JOB_INFO_D,
JKL_APPLE_MTV_D MOTIVES_D
WHERE APP_FACT.REQUISITION_ROW_WID = REQN_D.ROW_WID
AND APP_FACT.JOB_INFO_ROW_WID = JOB_INFO_D.ROW_WID
AND MOTIVES_D.APP_EVENT_WID = APP_FACT.APPL_CSW_MOTIVES_WID
ORDER BY APP_FACT.PI_CANDIDATE_NUM,APP_FACT.INTEGRATION_ID,JOB_INFO_D.J_GROUP ASC
) IR1 WHERE IR1.ACT_CAND = 0;
oracle plsql-developer
oracle plsql-developer
edited 6 mins ago
McNets
15k41858
asked 1 hour ago
SlySly
63
edited 6 mins ago
McNets
15k41858
asked 1 hour ago
SlySly
63
edited 6 mins ago
McNets
15k41858
edited 6 mins ago
McNets
15k41858
edited 6 mins ago
McNets
15k41858
15k41858
asked 1 hour ago
SlySly
63
asked 1 hour ago
SlySly
63
asked 1 hour ago
SlySly
63
63
How do you expect anyone to help you without showing your table definitions and the query?
– mustaccio
33 mins ago
I have added my code that I am running to create the view,
– Sly
14 mins ago
add a comment |
How do you expect anyone to help you without showing your table definitions and the query?
– mustaccio
33 mins ago
I have added my code that I am running to create the view,
– Sly
14 mins ago
How do you expect anyone to help you without showing your table definitions and the query?
– mustaccio
33 mins ago
How do you expect anyone to help you without showing your table definitions and the query?
– mustaccio
33 mins ago
I have added my code that I am running to create the view,
– Sly
14 mins ago
I have added my code that I am running to create the view,
– Sly
14 mins ago
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f226788%2fhow-can-i-handle-duplicate-integration-ids-in-oracle-database%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f226788%2fhow-can-i-handle-duplicate-integration-ids-in-oracle-database%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
How do you expect anyone to help you without showing your table definitions and the query?
– mustaccio
33 mins ago
I have added my code that I am running to create the view,
– Sly
14 mins ago