VIEW: APPS.JA_CN_CFSBSV_V

Source

View Text - Preformatted

select  LG.Ledger_Id lg_id ,nbsv.legal_entity_id le_id,nbsv.Segment_Value bsv
from Gl_Ledgers Lg,
     Gl_Ledger_Relationships Rs,
     Gl_Ledger_Norm_Seg_Vals nbsv,
     Gl_Ledgers Lgr_c
WHERE lg.bal_seg_value_option_code='I'
AND Rs.Application_Id = 101
AND Lg.Ledger_Id = Rs.Target_Ledger_Id
AND Rs.Target_Ledger_Id = Lgr_c.Ledger_Id
AND Nvl(Lgr_c.Complete_Flag, 'Y') = 'Y'
AND nbsv.Segment_Type_Code = 'B'
AND Nvl(nbsv.Status_Code, 'I') <> 'D'
and((Rs.Relationship_Type_Code = 'NONE'
AND Rs.Target_Ledger_Id = LG.Ledger_Id)
OR(Rs.Target_Ledger_Category_Code = 'ALC'
AND Rs.Relationship_Type_Code IN ('SUBLEDGER', 'JOURNAL')
AND Rs.Source_Ledger_Id = LG.Ledger_Id))
AND nbsv.ledger_id=Lg.Ledger_Id
union
SELECT lg.ledger_id lg_id,null le_id,ffv.FLEX_VALUE bsv
FROM GL_LEDGERS lg, FND_FLEX_VALUES ffv
WHERE lg.bal_seg_value_option_code='A'
AND ffv.flex_value_set_id = lg.bal_seg_value_set_id
AND ffv.summary_flag = 'N'

View Text - HTML Formatted

SELECT LG.LEDGER_ID LG_ID
, NBSV.LEGAL_ENTITY_ID LE_ID
, NBSV.SEGMENT_VALUE BSV FROM GL_LEDGERS LG
, GL_LEDGER_RELATIONSHIPS RS
, GL_LEDGER_NORM_SEG_VALS NBSV
, GL_LEDGERS LGR_C WHERE LG.BAL_SEG_VALUE_OPTION_CODE='I' AND RS.APPLICATION_ID = 101 AND LG.LEDGER_ID = RS.TARGET_LEDGER_ID AND RS.TARGET_LEDGER_ID = LGR_C.LEDGER_ID AND NVL(LGR_C.COMPLETE_FLAG
, 'Y') = 'Y' AND NBSV.SEGMENT_TYPE_CODE = 'B' AND NVL(NBSV.STATUS_CODE
, 'I') <> 'D' AND((RS.RELATIONSHIP_TYPE_CODE = 'NONE' AND RS.TARGET_LEDGER_ID = LG.LEDGER_ID) OR(RS.TARGET_LEDGER_CATEGORY_CODE = 'ALC' AND RS.RELATIONSHIP_TYPE_CODE IN ('SUBLEDGER'
, 'JOURNAL') AND RS.SOURCE_LEDGER_ID = LG.LEDGER_ID)) AND NBSV.LEDGER_ID=LG.LEDGER_ID UNION SELECT LG.LEDGER_ID LG_ID
, NULL LE_ID
, FFV.FLEX_VALUE BSV FROM GL_LEDGERS LG
, FND_FLEX_VALUES FFV WHERE LG.BAL_SEG_VALUE_OPTION_CODE='A' AND FFV.FLEX_VALUE_SET_ID = LG.BAL_SEG_VALUE_SET_ID AND FFV.SUMMARY_FLAG = 'N'