VIEW: APPS.DDR_R_INV_RULE_DN_MV#

Source

View Text - Preformatted

select  invrl.ROWID ITM_BU_RL_ROWID
,       inv.ROWID SKU_BU_INV_ROWID
,       inv.RTL_ORG_CD
,       inv.BSNS_UNIT_CD
,       inv.RTL_SKU_ITEM_NBR
,       inv.GLBL_ITEM_ID
,       inv.GLBL_ITEM_ID_TYP
,       nvl(invrl.MIN_STCK_ON_HAND_QTY_PRMRY, 0) as MIN_STCK_ON_HAND_QTY_PRMRY
from    ddr_bs_inv_sku_bu_combs inv                    
,       DDR_R_RTL_SKU_BU_INV_RL invrl
where   inv.BSNS_UNIT_CD = invrl.BSNS_UNIT_CD (+)
and     inv.rtl_org_cd = invrl.rtl_org_cd(+)
and     inv.RTL_SKU_ITEM_NBR = invrl.RTL_SKU_ITEM_NBR (+)
and     inv.glbl_item_id = invrl.glbl_item_id(+)
and     inv.glbl_item_id_typ = invrl.glbl_item_id_typ(+)

View Text - HTML Formatted

SELECT INVRL.ROWID ITM_BU_RL_ROWID
, INV.ROWID SKU_BU_INV_ROWID
, INV.RTL_ORG_CD
, INV.BSNS_UNIT_CD
, INV.RTL_SKU_ITEM_NBR
, INV.GLBL_ITEM_ID
, INV.GLBL_ITEM_ID_TYP
, NVL(INVRL.MIN_STCK_ON_HAND_QTY_PRMRY
, 0) AS MIN_STCK_ON_HAND_QTY_PRMRY FROM DDR_BS_INV_SKU_BU_COMBS INV
, DDR_R_RTL_SKU_BU_INV_RL INVRL WHERE INV.BSNS_UNIT_CD = INVRL.BSNS_UNIT_CD (+) AND INV.RTL_ORG_CD = INVRL.RTL_ORG_CD(+) AND INV.RTL_SKU_ITEM_NBR = INVRL.RTL_SKU_ITEM_NBR (+) AND INV.GLBL_ITEM_ID = INVRL.GLBL_ITEM_ID(+) AND INV.GLBL_ITEM_ID_TYP = INVRL.GLBL_ITEM_ID_TYP(+)