VIEW: APPS.DDR_R_ORG_BSNS_ENT_OPT_V

Source

View Text - Preformatted

SELECT MFG_ORG_CD,ORG_BSNS_ENT_ID,ORG_CD,BSNS_ENT_CD,ORG_LVL_ID,LVL_CD,BSNS_ENT_NAME,BSNS_ENT_DESC,BSNS_ENT_NAME_PHNTC,BSNS_ENT_HEAD_NAME,BSNS_ENT_PLANNING,BSNS_ENT_ADDR_L1,BSNS_ENT_CITY_CD,BSNS_ENT_STATE_CD,BSNS_ENT_POSTAL_CD,BSNS_ENT_COUNTRY_CD,BSNS_ENT_PRNT_CD,BSNS_ENT_TYPE,HRCHY_CD,ORG_HCHY_ID,BSNS_ENT_PRNT_AUX_CD,EFF_FROM_DT,EFF_TO_DT FROM DDR_R_ORG_BSNS_ENT UNION SELECT '-1',-1,'-1','-1',-1,'-1','-1','-1','-1','-1','-1','-1','-1','-1','-1','-1','-1','-1','-1',-1,'-1',TO_DATE('01-JAN-1900','DD-MON-YYYY') as EFF_FROM_DT,TO_DATE('01-JAN-2400','DD-MON-YYYY') as EFF_TO_DT FROM DUAL

View Text - HTML Formatted

SELECT MFG_ORG_CD
, ORG_BSNS_ENT_ID
, ORG_CD
, BSNS_ENT_CD
, ORG_LVL_ID
, LVL_CD
, BSNS_ENT_NAME
, BSNS_ENT_DESC
, BSNS_ENT_NAME_PHNTC
, BSNS_ENT_HEAD_NAME
, BSNS_ENT_PLANNING
, BSNS_ENT_ADDR_L1
, BSNS_ENT_CITY_CD
, BSNS_ENT_STATE_CD
, BSNS_ENT_POSTAL_CD
, BSNS_ENT_COUNTRY_CD
, BSNS_ENT_PRNT_CD
, BSNS_ENT_TYPE
, HRCHY_CD
, ORG_HCHY_ID
, BSNS_ENT_PRNT_AUX_CD
, EFF_FROM_DT
, EFF_TO_DT
FROM DDR_R_ORG_BSNS_ENT UNION SELECT '-1'
, -1
, '-1'
, '-1'
, -1
, '-1'
, '-1'
, '-1'
, '-1'
, '-1'
, '-1'
, '-1'
, '-1'
, '-1'
, '-1'
, '-1'
, '-1'
, '-1'
, '-1'
, -1
, '-1'
, TO_DATE('01-JAN-1900'
, 'DD-MON-YYYY') AS EFF_FROM_DT
, TO_DATE('01-JAN-2400'
, 'DD-MON-YYYY') AS EFF_TO_DT
FROM DUAL