VIEW: APPS.DDR_L_LKUP_DFLT

Source

View Text - Preformatted

SELECT ORG.ORG_CD, MST.MFG_ORG_CD, MST.LKUP_CD, MST.LKUP_NAME FROM (SELECT MFG_ORG_CD, ORG_CD FROM DDR_R_ORG UNION SELECT '-1', '-1' FROM DUAL ) ORG JOIN (SELECT '-1' ORG_CD, MFG_ORG_CD, LKUP_CD, LKUP_NAME FROM DDR_R_LKUP_MST MST WHERE LKUP_CD LIKE 'DFLT%' AND LKUP_TYP_CD = 'SYS_PARAM' ) MST ON MST.MFG_ORG_CD=ORG.MFG_ORG_CD OR MST.ORG_CD =ORG.ORG_CD

View Text - HTML Formatted

SELECT ORG.ORG_CD
, MST.MFG_ORG_CD
, MST.LKUP_CD
, MST.LKUP_NAME
FROM (SELECT MFG_ORG_CD
, ORG_CD
FROM DDR_R_ORG UNION SELECT '-1'
, '-1'
FROM DUAL ) ORG JOIN (SELECT '-1' ORG_CD
, MFG_ORG_CD
, LKUP_CD
, LKUP_NAME
FROM DDR_R_LKUP_MST MST
WHERE LKUP_CD LIKE 'DFLT%'
AND LKUP_TYP_CD = 'SYS_PARAM' ) MST ON MST.MFG_ORG_CD=ORG.MFG_ORG_CD OR MST.ORG_CD =ORG.ORG_CD