VIEW: APPS.BOM_CTO_SRC_ORGS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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