VIEW: DDR.DDR_R_ITEM_ORG_ASSC_RULE#

Source

View Text - Preformatted

select MFG_ORG_CD MFG_ORG_CD, ITEM_ORG_ASSC_RULE_ID ITEM_ORG_ASSC_RULE_ID, ORG_HRCHY_TYP ORG_HRCHY_TYP, MFG_ITEM_LVL_CD MFG_ITEM_LVL_CD, MFG_PROD_ENT_ID MFG_PROD_ENT_ID, MFG_PROD_ENT_CD MFG_PROD_ENT_CD, PROD_HRCHY_TYP PROD_HRCHY_TYP, RTL_ORG_LVL_CD RTL_ORG_LVL_CD, RTL_BSNS_ENT_ID RTL_BSNS_ENT_ID, RTL_BSNS_ENT_CD RTL_BSNS_ENT_CD, MFG_BSNS_UNIT_ID MFG_BSNS_UNIT_ID, MFG_BSNS_UNIT_CD MFG_BSNS_UNIT_CD, EFF_FROM_DT EFF_FROM_DT, EFF_TO_DT EFF_TO_DT, SRC_SYS_IDNT SRC_SYS_IDNT, SRC_SYS_DT SRC_SYS_DT, CRTD_BY_DSR CRTD_BY_DSR, LAST_UPDT_BY_DSR LAST_UPDT_BY_DSR, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "DDR"."DDR_R_ITEM_ORG_ASSC_RULE"

View Text - HTML Formatted

SELECT MFG_ORG_CD MFG_ORG_CD
, ITEM_ORG_ASSC_RULE_ID ITEM_ORG_ASSC_RULE_ID
, ORG_HRCHY_TYP ORG_HRCHY_TYP
, MFG_ITEM_LVL_CD MFG_ITEM_LVL_CD
, MFG_PROD_ENT_ID MFG_PROD_ENT_ID
, MFG_PROD_ENT_CD MFG_PROD_ENT_CD
, PROD_HRCHY_TYP PROD_HRCHY_TYP
, RTL_ORG_LVL_CD RTL_ORG_LVL_CD
, RTL_BSNS_ENT_ID RTL_BSNS_ENT_ID
, RTL_BSNS_ENT_CD RTL_BSNS_ENT_CD
, MFG_BSNS_UNIT_ID MFG_BSNS_UNIT_ID
, MFG_BSNS_UNIT_CD MFG_BSNS_UNIT_CD
, EFF_FROM_DT EFF_FROM_DT
, EFF_TO_DT EFF_TO_DT
, SRC_SYS_IDNT SRC_SYS_IDNT
, SRC_SYS_DT SRC_SYS_DT
, CRTD_BY_DSR CRTD_BY_DSR
, LAST_UPDT_BY_DSR LAST_UPDT_BY_DSR
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "DDR"."DDR_R_ITEM_ORG_ASSC_RULE"