VIEW: APPS.DDR_R_INV_LOC_UNPIVOT_V

Source

View Text - Preformatted

SELECT REC_ID,ORG_CD,BSNS_UNIT_CD,P_INV_LOC_CD,P_INV_LOC_TYP_CD,P_INV_LOC_DESC,P_LAYOUT_SHAPE,P_LNR_SZ,P_SQR_SZ,P_CUBIC_SZ,P_LOC_CORDNT_X ,P_LOC_CORDNT_Y,P_LOC_CORDNT_Z,P_UOM_CD,P_SLNG_LOC_TYP_CD,P_NBR_OF_FCNGS, SRC_SYS_DT,SRC_SYS_IDNT FROM DDR_I_ORG_BSNS_UNIT UNPIVOT ((P_INV_LOC_CD,P_INV_LOC_TYP_CD,P_INV_LOC_DESC,P_LAYOUT_SHAPE,P_LNR_SZ,P_SQR_SZ,P_CUBIC_SZ,P_LOC_CORDNT_X ,P_LOC_CORDNT_Y,P_LOC_CORDNT_Z,P_UOM_CD,P_SLNG_LOC_TYP_CD,P_NBR_OF_FCNGS) FOR P_INV_COMBO IN((INV_LOC_CD_1,INV_LOC_TYP_CD_1,INV_LOC_DESC_1,LAYOUT_SHAPE_1,LNR_SZ_1,SQR_SZ_1,CUBIC_SZ_1,LOC_CORDNT_X_1 ,LOC_CORDNT_Y_1,LOC_CORDNT_Z_1,INV_UOM_CD_1,SLNG_LOC_TYP_CD_1,NBR_OF_FCNGS_1), (INV_LOC_CD_2,INV_LOC_TYP_CD_2,INV_LOC_DESC_2,LAYOUT_SHAPE_2,LNR_SZ_2,SQR_SZ_2,CUBIC_SZ_2,LOC_CORDNT_X_2 ,LOC_CORDNT_Y_2,LOC_CORDNT_Z_2,INV_UOM_CD_2,SLNG_LOC_TYP_CD_2,NBR_OF_FCNGS_2), (INV_LOC_CD_3,INV_LOC_TYP_CD_3,INV_LOC_DESC_3,LAYOUT_SHAPE_3,LNR_SZ_3,SQR_SZ_3,CUBIC_SZ_3,LOC_CORDNT_X_3 ,LOC_CORDNT_Y_3,LOC_CORDNT_Z_3,INV_UOM_CD_3,SLNG_LOC_TYP_CD_3,NBR_OF_FCNGS_3)))

View Text - HTML Formatted

SELECT REC_ID
, ORG_CD
, BSNS_UNIT_CD
, P_INV_LOC_CD
, P_INV_LOC_TYP_CD
, P_INV_LOC_DESC
, P_LAYOUT_SHAPE
, P_LNR_SZ
, P_SQR_SZ
, P_CUBIC_SZ
, P_LOC_CORDNT_X
, P_LOC_CORDNT_Y
, P_LOC_CORDNT_Z
, P_UOM_CD
, P_SLNG_LOC_TYP_CD
, P_NBR_OF_FCNGS
, SRC_SYS_DT
, SRC_SYS_IDNT
FROM DDR_I_ORG_BSNS_UNIT UNPIVOT ((P_INV_LOC_CD
, P_INV_LOC_TYP_CD
, P_INV_LOC_DESC
, P_LAYOUT_SHAPE
, P_LNR_SZ
, P_SQR_SZ
, P_CUBIC_SZ
, P_LOC_CORDNT_X
, P_LOC_CORDNT_Y
, P_LOC_CORDNT_Z
, P_UOM_CD
, P_SLNG_LOC_TYP_CD
, P_NBR_OF_FCNGS) FOR P_INV_COMBO IN((INV_LOC_CD_1
, INV_LOC_TYP_CD_1
, INV_LOC_DESC_1
, LAYOUT_SHAPE_1
, LNR_SZ_1
, SQR_SZ_1
, CUBIC_SZ_1
, LOC_CORDNT_X_1
, LOC_CORDNT_Y_1
, LOC_CORDNT_Z_1
, INV_UOM_CD_1
, SLNG_LOC_TYP_CD_1
, NBR_OF_FCNGS_1)
, (INV_LOC_CD_2
, INV_LOC_TYP_CD_2
, INV_LOC_DESC_2
, LAYOUT_SHAPE_2
, LNR_SZ_2
, SQR_SZ_2
, CUBIC_SZ_2
, LOC_CORDNT_X_2
, LOC_CORDNT_Y_2
, LOC_CORDNT_Z_2
, INV_UOM_CD_2
, SLNG_LOC_TYP_CD_2
, NBR_OF_FCNGS_2)
, (INV_LOC_CD_3
, INV_LOC_TYP_CD_3
, INV_LOC_DESC_3
, LAYOUT_SHAPE_3
, LNR_SZ_3
, SQR_SZ_3
, CUBIC_SZ_3
, LOC_CORDNT_X_3
, LOC_CORDNT_Y_3
, LOC_CORDNT_Z_3
, INV_UOM_CD_3
, SLNG_LOC_TYP_CD_3
, NBR_OF_FCNGS_3)))