View: BOM_CTO_SRC_ORGS

Product:	BOM - Bills of Material
Description:	BOM_CTO_SRC_ORGS
Implementation/DBA Data:	APPS.BOM_CTO_SRC_ORGS

View Text

SELECT BCSO.LINE_ID LINE_ID
, BCSO.TOP_MODEL_LINE_ID TOP_MODEL_LINE_ID
, DECODE(BCMO.GROUP_REFERENCE_ID
, NULL
, -1
, BCMO.REFERENCE_ID) REFENCE_ID
, DECODE(BCMO.GROUP_REFERENCE_ID
, NULL
, BCSO.GROUP_REFERENCE_ID
, BCMO.GROUP_REFERENCE_ID) GROUP_REFERENCE_ID
, DECODE(BCMO.GROUP_REFERENCE_ID
, NULL
, BCSO.CREATE_BOM
, BCMO.CREATE_BOM) CREATE_BOM
, DECODE(BCMO.GROUP_REFERENCE_ID
, NULL
, BCSO.COST_ROLLUP
, BCMO.COST_ROLLUP) COST_ROLLUP
, DECODE(BCMO.GROUP_REFERENCE_ID
, NULL
, BCSO.CONFIG_ITEM_ID
, BCMO.CONFIG_ITEM_ID) CONFIG_ITEM_ID
, DECODE(BCMO.GROUP_REFERENCE_ID
, NULL
, BCSO.CREATE_SRC_RULES
, BCMO.CREATE_SRC_RULES) CREATE_SRC_RULES
, DECODE(BCMO.GROUP_REFERENCE_ID
, NULL
, BCSO.MODEL_ITEM_ID
, BCMO.MODEL_ITEM_ID) MODEL_ITEM_ID
, DECODE(BCMO.GROUP_REFERENCE_ID
, NULL
, BCSO.ORGANIZATION_ID
, BCMO.ORGANIZATION_ID) ORGANIZATION_ID
, DECODE(BCMO.GROUP_REFERENCE_ID
, NULL
, BCSO.ORGANIZATION_TYPE
, BCMO.ORGANIZATION_TYPE) ORGANIZATION_TYPE
, DECODE(BCMO.GROUP_REFERENCE_ID
, NULL
, BCSO.RANK
, BCMO.RANK) RANK
, DECODE(BCMO.GROUP_REFERENCE_ID
, NULL
, BCSO.RCV_ORG_ID
, BCMO.RCV_ORG_ID) RCV_ORG_ID
, DECODE(BCMO.GROUP_REFERENCE_ID
, NULL
, BCSO.LAST_UPDATED_BY
, BCMO.LAST_UPDATED_BY) LAST_UPDATED_BY
, DECODE(BCMO.GROUP_REFERENCE_ID
, NULL
, BCSO.CREATION_DATE
, BCMO.CREATION_DATE) CREATION_DATE
, DECODE(BCMO.GROUP_REFERENCE_ID
, NULL
, BCSO.CREATED_BY
, BCMO.CREATED_BY) CREATED_BY
, DECODE(BCMO.GROUP_REFERENCE_ID
, NULL
, BCSO.LAST_UPDATE_LOGIN
, BCMO.LAST_UPDATE_LOGIN) LAST_UPDATE_LOGIN
, DECODE(BCMO.GROUP_REFERENCE_ID
, NULL
, BCSO.REQUEST_ID
, BCMO.REQUEST_ID) REQUEST_ID
, DECODE(BCMO.GROUP_REFERENCE_ID
, NULL
, BCSO.PROGRAM_APPLICATION_ID
, BCMO.PROGRAM_APPLICATION_ID) PROGRAM_APPLICATION_ID
, DECODE(BCMO.GROUP_REFERENCE_ID
, NULL
, BCSO.PROGRAM_ID
, BCMO.PROGRAM_ID) PROGRAM_ID
, DECODE(BCMO.GROUP_REFERENCE_ID
, NULL
, BCSO.PROGRAM_UPDATE_DATE
, BCMO.PROGRAM_UPDATE_DATE) PROGRAM_UPDATE_DATE
, DECODE(BCMO.GROUP_REFERENCE_ID
, NULL
, BCSO.LAST_UPDATE_DATE
, BCMO.LAST_UPDATE_DATE) LAST_UPDATE_DATE
FROM BOM_CTO_SRC_ORGS_B BCSO
, BOM_CTO_MODEL_ORGS BCMO
WHERE BCMO.GROUP_REFERENCE_ID (+)= BCSO.GROUP_REFERENCE_ID

Columns