[Home] [Help]
178: , jcc.project_number
179: , jcc.project_id
180: , substr(ffv.COMPILED_VALUE_ATTRIBUTES,5,1) account_type
181: FROM ja_cn_code_combination_v jcc
182: , FND_FLEX_VALUES ffv
183: WHERE jcc.ledger_id = p_ledger_id
184: AND ffv.PARENT_FLEX_VALUE_LOW IS NULL
185: AND ffv.FLEX_VALUE_SET_ID = pc_flex_value_set_id
186: AND ffv.flex_value = jcc.account_segment
201: , jcc.project_number
202: , jcc.project_id
203: , substr(ffv.COMPILED_VALUE_ATTRIBUTES,5,1) account_type
204: FROM ja_cn_code_combination_v jcc
205: , FND_FLEX_VALUES ffv
206: WHERE jcc.ledger_id = p_ledger_id
207: AND ffv.PARENT_FLEX_VALUE_LOW IS NULL
208: AND ffv.FLEX_VALUE_SET_ID = pc_flex_value_set_id
209: AND ffv.flex_value = jcc.account_segment
417: WHERE ledger_id = p_ledger_id
418: AND legal_entity_id = p_legal_entity_ID
419: AND period_name = p_period_name
420: AND EXISTS(SELECT *
421: FROM FND_FLEX_VALUES ffv
422: WHERE PARENT_FLEX_VALUE_LOW IS NULL
423: AND FLEX_VALUE_SET_ID = l_flex_value_set_id
424: AND ffv.flex_value = jab.account_segment
425: AND substr(COMPILED_VALUE_ATTRIBUTES,5,1) IN ('R','E')
467: , l_ret_project_number
468: , l_ret_project_id
469: , l_ret_account_type
470: FROM ja_cn_code_combination_v jcc
471: , FND_FLEX_VALUES ffv
472: WHERE jcc.CODE_COMBINATION_ID = l_RET_EARN_CODE_COMBINATION_ID
473: AND jcc.ledger_id = p_ledger_id
474: AND ffv.PARENT_FLEX_VALUE_LOW IS NULL
475: AND ffv.FLEX_VALUE_SET_ID = l_flex_value_set_id
515: , l_ret_project_number
516: , l_ret_project_id
517: , l_ret_account_type
518: FROM ja_cn_code_combination_v jcc
519: , FND_FLEX_VALUES ffv
520: WHERE jcc.CODE_COMBINATION_ID = l_RET_EARN_CODE_COMBINATION_ID
521: AND jcc.ledger_id = p_ledger_id
522: AND ffv.PARENT_FLEX_VALUE_LOW IS NULL
523: AND ffv.FLEX_VALUE_SET_ID = l_flex_value_set_id
1121: , fnd_global.USER_ID
1122: , SYSDATE
1123: , fnd_global.LOGIN_ID
1124: FROM ja_cn_code_combination_v jcc
1125: , FND_FLEX_VALUES ffv
1126: , ja_cn_periods jcp
1127: WHERE jcc.ledger_id = p_ledger_id
1128: AND ffv.PARENT_FLEX_VALUE_LOW IS NULL
1129: AND ffv.FLEX_VALUE_SET_ID = l_flex_value_set_id
1203: , fnd_global.USER_ID
1204: , SYSDATE
1205: , fnd_global.LOGIN_ID
1206: FROM ja_cn_code_combination_v jcc
1207: , FND_FLEX_VALUES ffv
1208: , ja_cn_periods jcp
1209: WHERE jcc.ledger_id = p_ledger_id
1210: AND ffv.PARENT_FLEX_VALUE_LOW IS NULL
1211: AND ffv.FLEX_VALUE_SET_ID = l_flex_value_set_id
1421: WHERE jcb.ledger_id = p_ledger_id
1422: AND jcb.legal_entity_id = p_legal_entity_ID
1423: AND EXISTS (SELECT jcp.ledger_id
1424: FROM ja_cn_periods jcp
1425: , fnd_flex_values ffv
1426: WHERE jcp.period_name=jcb.period_name
1427: AND jcp.ledger_id = p_ledger_id
1428: AND jcp.period_num BETWEEN l_period_num AND l_last_period_num
1429: AND ffv.flex_value_set_id = l_flex_value_set_id
1494: , SYSDATE
1495: , fnd_global.LOGIN_ID
1496: FROM gl_balances gb
1497: , ja_cn_code_combination_v jcc
1498: , fnd_flex_values ffv
1499: WHERE gb.ledger_id = p_ledger_id
1500: AND jcc.ledger_id = p_ledger_id
1501: AND gb.code_combination_id = jcc.CODE_COMBINATION_ID
1502: AND jcc.account_segment = ffv.flex_value
1518: WHERE jcb.ledger_id = p_ledger_id
1519: AND jcb.legal_entity_id = p_legal_entity_ID
1520: AND EXISTS (SELECT jcp.ledger_id
1521: FROM ja_cn_periods jcp
1522: , fnd_flex_values ffv
1523: WHERE jcp.period_name=jcb.period_name
1524: AND jcp.ledger_id = p_ledger_id
1525: AND jcp.period_num BETWEEN l_period_num AND l_last_period_num
1526: AND ffv.flex_value_set_id = l_flex_value_set_id
1538: SELECT H.PARENT_FLEX_VALUE
1539: , V.FLEX_VALUE
1540: , V.SUMMARY_FLAG
1541: , substr(v2.compiled_value_attributes,5,1)
1542: FROM FND_FLEX_VALUES V
1543: , FND_FLEX_VALUE_NORM_HIERARCHY H
1544: , FND_FLEX_VALUES V2
1545: WHERE v.flex_value_set_id = l_flex_value_set_id
1546: AND h.flex_value_set_id = l_flex_value_set_id
1540: , V.SUMMARY_FLAG
1541: , substr(v2.compiled_value_attributes,5,1)
1542: FROM FND_FLEX_VALUES V
1543: , FND_FLEX_VALUE_NORM_HIERARCHY H
1544: , FND_FLEX_VALUES V2
1545: WHERE v.flex_value_set_id = l_flex_value_set_id
1546: AND h.flex_value_set_id = l_flex_value_set_id
1547: AND V.FLEX_VALUE BETWEEN H.CHILD_FLEX_VALUE_LOW AND H.CHILD_FLEX_VALUE_HIGH
1548: AND ((V.SUMMARY_FLAG = 'Y' AND H.RANGE_ATTRIBUTE = 'P') OR
1568: , v.FLEX_VALUE
1569: , v.SUMMARY_FLAG
1570: , jca.parent_type
1571: FROM JA_CN_ACCOUNT_CHILDREN_GT jca
1572: , FND_FLEX_VALUES v
1573: , FND_FLEX_VALUE_NORM_HIERARCHY h
1574: WHERE jca.child_account = h.parent_flex_value
1575: AND v.flex_value_set_id = l_flex_value_set_id
1576: AND h.flex_value_set_id = l_flex_value_set_id
1735: , fnd_global.LOGIN_ID
1736: FROM ja_cn_periods jcp
1737: , ja_cn_account_balances jca
1738: , FND_FLEX_VALUE_CHILDREN_V ffvc
1739: , fnd_flex_values ffv
1740: WHERE jca.account_segment = ffvc.flex_value*/
1741:
1742: IF( G_PROC_LEVEL >= g_debug_devel )
1743: THEN
1789: --l_last_open_period_year ja_cn_periods.period_name%TYPE;
1790: --l_last_open_period ja_cn_periods.period_name%TYPE;
1791: l_period_year ja_cn_periods.period_year%TYPE;
1792: l_period_num ja_cn_periods.period_num%TYPE;
1793: l_flex_value_set_id FND_FLEX_VALUES.Flex_Value_Set_Id%TYPE;
1794: l_row_count NUMBER;
1795: l_balance_rec cnao_balance_rec;
1796:
1797: l_earliest_changed_year ja_cn_periods.period_year%TYPE;
1838: , jjl.ACCOUNT_SEGMENT
1839: , jjl.period_name
1840: , substr(COMPILED_VALUE_ATTRIBUTES,5,1) account_type
1841: FROM JA_CN_JOURNAL_LINES jjl
1842: , FND_FLEX_VALUES ffv
1843: WHERE jjl.ledger_id = p_ledger_id
1844: AND jjl.legal_entity_id = p_legal_entity_ID
1845: AND jjl.status = 'U'
1846: AND ffv.PARENT_FLEX_VALUE_LOW IS NULL