[Home] [Help]
215: , jcc.project_number
216: , jcc.project_id
217: , substr(ffv.COMPILED_VALUE_ATTRIBUTES,5,1) account_type
218: FROM ja_cn_code_combination_v jcc
219: , FND_FLEX_VALUES ffv
220: WHERE jcc.ledger_id = p_ledger_id
221: AND ffv.PARENT_FLEX_VALUE_LOW IS NULL
222: AND ffv.FLEX_VALUE_SET_ID = pc_flex_value_set_id
223: AND ffv.flex_value = jcc.account_segment
238: , jcc.project_number
239: , jcc.project_id
240: , substr(ffv.COMPILED_VALUE_ATTRIBUTES,5,1) account_type
241: FROM ja_cn_code_combination_v jcc
242: , FND_FLEX_VALUES ffv
243: WHERE jcc.ledger_id = p_ledger_id
244: AND ffv.PARENT_FLEX_VALUE_LOW IS NULL
245: AND ffv.FLEX_VALUE_SET_ID = pc_flex_value_set_id
246: AND ffv.flex_value = jcc.account_segment
514: WHERE ledger_id = p_ledger_id
515: AND legal_entity_id = p_legal_entity_ID
516: AND period_name = p_period_name
517: AND EXISTS(SELECT *
518: FROM FND_FLEX_VALUES ffv
519: WHERE PARENT_FLEX_VALUE_LOW IS NULL
520: AND FLEX_VALUE_SET_ID = l_flex_value_set_id
521: AND ffv.flex_value = jab.account_segment
522: AND substr(COMPILED_VALUE_ATTRIBUTES,5,1) IN ('R','E')
564: , l_ret_project_number
565: , l_ret_project_id
566: , l_ret_account_type
567: FROM ja_cn_code_combination_v jcc
568: , FND_FLEX_VALUES ffv
569: WHERE jcc.CODE_COMBINATION_ID = l_RET_EARN_CODE_COMBINATION_ID
570: AND jcc.ledger_id = p_ledger_id
571: AND ffv.PARENT_FLEX_VALUE_LOW IS NULL
572: AND ffv.FLEX_VALUE_SET_ID = l_flex_value_set_id
612: , l_ret_project_number
613: , l_ret_project_id
614: , l_ret_account_type
615: FROM ja_cn_code_combination_v jcc
616: , FND_FLEX_VALUES ffv
617: WHERE jcc.CODE_COMBINATION_ID = l_RET_EARN_CODE_COMBINATION_ID
618: AND jcc.ledger_id = p_ledger_id
619: AND ffv.PARENT_FLEX_VALUE_LOW IS NULL
620: AND ffv.FLEX_VALUE_SET_ID = l_flex_value_set_id
1530: , jcc.SEGMENT28
1531: , jcc.SEGMENT29
1532: , jcc.SEGMENT30
1533: FROM ja_cn_code_combination_v jcc
1534: , FND_FLEX_VALUES ffv
1535: , ja_cn_periods jcp
1536: , gl_balances gb
1537: , ja_cn_code_combination_v jcc1
1538: WHERE jcc.ledger_id = p_ledger_id --parameter: p_ledger_id
1757: , jcc.SEGMENT28
1758: , jcc.SEGMENT29
1759: , jcc.SEGMENT30
1760: FROM ja_cn_code_combination_v jcc
1761: , FND_FLEX_VALUES ffv
1762: , ja_cn_periods jcp
1763: WHERE jcc.ledger_id = p_ledger_id
1764: AND ffv.PARENT_FLEX_VALUE_LOW IS NULL
1765: AND ffv.FLEX_VALUE_SET_ID = l_flex_value_set_id
1897: , jcc.SEGMENT28
1898: , jcc.SEGMENT29
1899: , jcc.SEGMENT30
1900: FROM ja_cn_code_combination_v jcc
1901: , FND_FLEX_VALUES ffv
1902: , ja_cn_periods jcp
1903: WHERE jcc.ledger_id = p_ledger_id
1904: AND ffv.PARENT_FLEX_VALUE_LOW IS NULL
1905: AND ffv.FLEX_VALUE_SET_ID = l_flex_value_set_id
2301: WHERE jcb.ledger_id = p_ledger_id
2302: AND jcb.legal_entity_id = p_legal_entity_ID
2303: AND EXISTS (SELECT jcp.ledger_id
2304: FROM ja_cn_periods jcp
2305: , fnd_flex_values ffv
2306: WHERE jcp.period_name=jcb.period_name
2307: AND jcp.ledger_id = p_ledger_id
2308: AND jcp.period_num BETWEEN l_period_num AND l_last_period_num
2309: AND ffv.flex_value_set_id = l_flex_value_set_id
2374: , SYSDATE
2375: , fnd_global.LOGIN_ID
2376: FROM gl_balances gb
2377: , ja_cn_code_combination_v jcc
2378: , fnd_flex_values ffv
2379: WHERE gb.ledger_id = p_ledger_id
2380: AND jcc.ledger_id = p_ledger_id
2381: AND gb.code_combination_id = jcc.CODE_COMBINATION_ID
2382: AND jcc.account_segment = ffv.flex_value
2398: WHERE jcb.ledger_id = p_ledger_id
2399: AND jcb.legal_entity_id = p_legal_entity_ID
2400: AND EXISTS (SELECT jcp.ledger_id
2401: FROM ja_cn_periods jcp
2402: , fnd_flex_values ffv
2403: WHERE jcp.period_name=jcb.period_name
2404: AND jcp.ledger_id = p_ledger_id
2405: AND jcp.period_num BETWEEN l_period_num AND l_last_period_num
2406: AND ffv.flex_value_set_id = l_flex_value_set_id
2420: SELECT H.PARENT_FLEX_VALUE
2421: , V.FLEX_VALUE
2422: , V.SUMMARY_FLAG
2423: , substr(v2.compiled_value_attributes,5,1)
2424: FROM FND_FLEX_VALUES V
2425: , FND_FLEX_VALUE_NORM_HIERARCHY H
2426: , FND_FLEX_VALUES V2
2427: WHERE v.flex_value_set_id = l_flex_value_set_id
2428: AND h.flex_value_set_id = l_flex_value_set_id
2422: , V.SUMMARY_FLAG
2423: , substr(v2.compiled_value_attributes,5,1)
2424: FROM FND_FLEX_VALUES V
2425: , FND_FLEX_VALUE_NORM_HIERARCHY H
2426: , FND_FLEX_VALUES V2
2427: WHERE v.flex_value_set_id = l_flex_value_set_id
2428: AND h.flex_value_set_id = l_flex_value_set_id
2429: AND V.FLEX_VALUE BETWEEN H.CHILD_FLEX_VALUE_LOW AND H.CHILD_FLEX_VALUE_HIGH
2430: AND ((V.SUMMARY_FLAG = 'Y' AND H.RANGE_ATTRIBUTE = 'P') OR
2450: , v.FLEX_VALUE
2451: , v.SUMMARY_FLAG
2452: , jca.parent_type
2453: FROM JA_CN_ACCOUNT_CHILDREN_GT jca
2454: , FND_FLEX_VALUES v
2455: , FND_FLEX_VALUE_NORM_HIERARCHY h
2456: WHERE jca.child_account = h.parent_flex_value
2457: AND v.flex_value_set_id = l_flex_value_set_id
2458: AND h.flex_value_set_id = l_flex_value_set_id
2682: , fnd_global.LOGIN_ID
2683: FROM ja_cn_periods jcp
2684: , ja_cn_account_balances jca
2685: , FND_FLEX_VALUE_CHILDREN_V ffvc
2686: , fnd_flex_values ffv
2687: WHERE jca.account_segment = ffvc.flex_value*/
2688:
2689: IF( G_PROC_LEVEL >= g_debug_devel )
2690: THEN
2840: --l_last_open_period_year ja_cn_periods.period_name%TYPE;
2841: --l_last_open_period ja_cn_periods.period_name%TYPE;
2842: l_period_year ja_cn_periods.period_year%TYPE;
2843: l_period_num ja_cn_periods.period_num%TYPE;
2844: l_flex_value_set_id FND_FLEX_VALUES.Flex_Value_Set_Id%TYPE;
2845: l_row_count NUMBER;
2846: l_balance_rec cnao_balance_rec;
2847:
2848: l_earliest_changed_year ja_cn_periods.period_year%TYPE;
2918: , jjl.segment30
2919: , jjl.ACCOUNT_SEGMENT
2920: , jjl.period_name
2921: FROM JA_CN_JOURNAL_LINES jjl
2922: , FND_FLEX_VALUES ffv
2923: WHERE jjl.ledger_id = p_ledger_id
2924: AND jjl.legal_entity_id = p_legal_entity_ID
2925: AND jjl.status = 'U'
2926: AND ffv.PARENT_FLEX_VALUE_LOW IS NULL