eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKI_REFRESH_PVT dependencies on GL_PERIODS

Line 2651: , gl_periods spd

2647: , oks_k_headers_b hoks -- 11510 Changes
2648: , oki_job_run_dtl jrd -- 11510 Changes
2649: , okc_k_party_roles_b cpl
2650: , okc_statuses_b sts
2651: , gl_periods spd
2652: , gl_periods spd1 -- 11510 Changes
2653: , okc_k_rel_objs ro
2654: , okx_order_headers_v oh
2655: , okc_governances og -- 11510 Changes

Line 2652: , gl_periods spd1 -- 11510 Changes

2648: , oki_job_run_dtl jrd -- 11510 Changes
2649: , okc_k_party_roles_b cpl
2650: , okc_statuses_b sts
2651: , gl_periods spd
2652: , gl_periods spd1 -- 11510 Changes
2653: , okc_k_rel_objs ro
2654: , okx_order_headers_v oh
2655: , okc_governances og -- 11510 Changes
2656: , ( SELECT ol.subject_chr_id, decode(count(1),0,'Y','N') is_new_yn

Line 2721: FROM gl_periods cpd

2717: (SELECT cpd.period_num
2718: ,cpd.period_name
2719: ,cpd.quarter_num
2720: ,cpd.period_year
2721: FROM gl_periods cpd
2722: ,gl_sets_of_books sob
2723: WHERE shd.close_date between cpd.start_date and cpd.end_date+0.99999
2724: and cpd.period_type = sob.accounted_period_type
2725: and cpd.period_set_name = sob.period_set_name

Line 3109: , gl_periods spd

3105: , okc_k_headers_b khr
3106: , oks_k_headers_b hoks -- 11510 Changes
3107: , okc_k_party_roles_b cpl
3108: , okc_statuses_b sts
3109: , gl_periods spd
3110: , gl_periods spd1 -- 11510 Changes
3111: , okc_k_rel_objs ro
3112: , okx_order_headers_v oh
3113: , okc_governances og -- From oki_pricing_rule

Line 3110: , gl_periods spd1 -- 11510 Changes

3106: , oks_k_headers_b hoks -- 11510 Changes
3107: , okc_k_party_roles_b cpl
3108: , okc_statuses_b sts
3109: , gl_periods spd
3110: , gl_periods spd1 -- 11510 Changes
3111: , okc_k_rel_objs ro
3112: , okx_order_headers_v oh
3113: , okc_governances og -- From oki_pricing_rule
3114: , ( SELECT /*+ leading(jrd) full(jrd) cardinality(jrd,1)*/

Line 3182: FROM gl_periods cpd

3178: (SELECT cpd.period_num
3179: ,cpd.period_name
3180: ,cpd.quarter_num
3181: ,cpd.period_year
3182: FROM gl_periods cpd
3183: ,gl_sets_of_books sob
3184: WHERE shd.close_date between cpd.start_date and cpd.end_date+0.99999
3185: and cpd.period_type = sob.accounted_period_type
3186: and cpd.period_set_name = sob.period_set_name

Line 4158: ,gl_periods epd

4154: ,okc_k_items cim
4155: ,csi_item_instances cii
4156: ,okc_statuses_b sts
4157: /*11510 changes added*/
4158: ,gl_periods epd
4159: ,(select distinct object_cle_id cle_id from okc_operation_lines
4160: where active_yn = 'Y' ) exp
4161: where 1 = 1
4162: and cii.instance_id = to_number(cim.object1_id1)

Line 4545: , gl_periods epd

4541: , csi_item_instances cii
4542: , okc_statuses_b sts
4543: , oki_job_run_dtl jrd
4544: /*11510 changes added*/
4545: , gl_periods epd
4546: ,(select distinct object_cle_id cle_id from okc_operation_lines
4547: where active_yn = 'Y' ) exp --Bug Fix 3469671 code changes
4548: WHERE
4549: cii.instance_id = to_number(cim.object1_id1)