[Home] [Help]
65: gl_ledgers_public_v s,
66: fa_deprn_periods dp,
67: fa_book_controls bc,
68: (SELECT DISTINCT slga.ledger_id
69: FROM fii_slg_assignments slga,
70: fii_source_ledger_groups fslg
71: WHERE slga.source_ledger_group_id = fslg.source_ledger_group_id
72: AND fslg.usage_code = g_usage_code) fset
73: WHERE s.ledger_id = fset.ledger_id
86: s.name
87: FROM gl_period_statuses ps,
88: gl_ledgers_public_v s,
89: (SELECT DISTINCT slga.ledger_id
90: FROM fii_slg_assignments slga,
91: fii_source_ledger_groups fslg
92: WHERE slga.source_ledger_group_id = fslg.source_ledger_group_id
93: AND fslg.usage_code =g_usage_code) fset
94: WHERE s.ledger_id = fset.ledger_id
104: s.name
105: FROM gl_period_statuses ps,
106: gl_ledgers_public_v s,
107: (SELECT DISTINCT slga.ledger_id
108: FROM fii_slg_assignments slga,
109: fii_source_ledger_groups fslg
110: WHERE slga.source_ledger_group_id = fslg.source_ledger_group_id
111: AND fslg.usage_code = g_usage_code) fset
112: WHERE s.ledger_id = fset.ledger_id
581: ra_cust_trx_types_all ctt,
582: ra_cust_trx_line_gl_dist_all ctlgd,
583: gl_code_combinations glcc,
584: fii_gl_ccid_dimensions ccdim,
585: fii_slg_assignments slga,
586: fii_source_ledger_groups fslg,
587: -- fii_fin_cat_type_assgns ffcta,
588: ra_customer_trx_lines_all ctl_parent,
589: gl_ledgers_public_v sob,
856: ar_adjustments_all adj,
857: ar_distributions_all ad,
858: gl_code_combinations gcc,
859: fii_gl_ccid_dimensions ccdim,
860: fii_slg_assignments slga,
861: fii_source_ledger_groups fslg,
862: -- fii_fin_cat_type_assgns ffcta,
863: ra_customer_trx_all ct,
864: -- ra_customer_trx_lines_all ctl,
1126: ccdim.prod_category_id y_prod_category_id,
1127: slga.ledger_id y_ledger_id
1128: -- ffcta.fin_cat_type_code y_fin_cat_type_code
1129: from fii_source_ledger_groups fslg,
1130: fii_slg_assignments slga,
1131: fii_gl_ccid_dimensions ccdim
1132: -- fii_fin_cat_type_assgns ffcta
1133: where (slga.bal_seg_value_id = ccdim.company_id
1134: OR slga.bal_seg_value_id = -1
1777: adj.adjustment_id
1778: from ra_customer_trx_all t,
1779: ar_adjustments_all adj,
1780: ( select distinct ledger_id
1781: from fii_slg_assignments slga,
1782: fii_source_ledger_groups fslg
1783: where slga.source_ledger_group_id = fslg.source_ledger_group_id
1784: and fslg.usage_code = :a
1785: ) lidset
1813: 7,
1814: t.adjustment_id
1815: FROM ar_adjustments_all t,
1816: ( select distinct ledger_id
1817: from fii_slg_assignments slga,
1818: fii_source_ledger_groups fslg
1819: where slga.source_ledger_group_id = fslg.source_ledger_group_id
1820: AND fslg.usage_code = :a
1821: ) lidset
1855: ctl.customer_trx_line_id
1856: FROM ra_customer_trx_all ct,
1857: ra_customer_trx_lines_all ctl,
1858: ( select distinct ledger_id
1859: from fii_slg_assignments slga,
1860: fii_source_ledger_groups fslg
1861: where slga.source_ledger_group_id = fslg.source_ledger_group_id
1862: and fslg.usage_code = :a
1863: ) lidset
1870: 8,
1871: ct.customer_trx_line_id
1872: FROM ra_customer_trx_lines_all ct,
1873: ( select distinct ledger_id
1874: from fii_slg_assignments slga,
1875: fii_source_ledger_groups fslg
1876: where slga.source_ledger_group_id = fslg.source_ledger_group_id
1877: and fslg.usage_code = :d
1878: ) lidset
1921: dup.view_type_id,
1922: aeh.ae_header_id
1923: FROM xla_ae_headers aeh,
1924: ( select /*+ no_merge */ distinct ledger_id
1925: from fii_slg_assignments slga,
1926: fii_source_ledger_groups fslg
1927: where slga.source_ledger_group_id = fslg.source_ledger_group_id
1928: and fslg.usage_code = :m
1929: ) lidset,
1958: dup.view_type_id,
1959: aeh.ae_header_id
1960: FROM xla_ae_headers aeh,
1961: ( select distinct ledger_id
1962: from fii_slg_assignments slga,
1963: fii_source_ledger_groups fslg
1964: where slga.source_ledger_group_id = fslg.source_ledger_group_id
1965: and fslg.usage_code = :a
1966: ) lidset,
3263: sh.booked_date)), to_date(null)) REV_BOOKED_DATE,
3264: decode(ctl.interface_line_context, 'ORDER ENTRY',ctl.interface_line_attribute6,
3265: null) CHILD_ORDER_LINE_ID
3266: FROM (select /*+ PARALLEL(a) */ * from fii_source_ledger_groups a) fslg,
3267: (select /*+ PARALLEL(a) */ * from fii_slg_assignments a) slga,
3268: (select /*+ PARALLEL(a) */ * from fii_gl_ccid_dimensions a) ccdim,
3269: -- (select /*+ PARALLEL(a) */ * from fii_fin_cat_type_assgns a) ffcta,
3270: (select /*+ PARALLEL(a) */ * from gl_code_combinations a) gcc,
3271: (
3288: FROM ar_adjustments_all adj,
3289: ar_distributions_all ad,
3290: (
3291: select /*+ no_merge use_hash(slga,fslg) */ distinct ledger_id
3292: from fii_slg_assignments slga, fii_source_ledger_groups fslg
3293: where slga.source_ledger_group_id = fslg.source_ledger_group_id
3294: and fslg.usage_code = g_usage_code
3295: ) lidset,
3296: ACCNT_CLASS AC,
3345: AC.Fin_Cat_Type_Code
3346: FROM ra_cust_trx_line_gl_dist_all ctlgd,
3347: (
3348: select /*+ no_merge use_hash(slga,fslg) */ distinct ledger_id
3349: from fii_slg_assignments slga, fii_source_ledger_groups fslg
3350: where slga.source_ledger_group_id = fslg.source_ledger_group_id
3351: and fslg.usage_code = g_usage_code
3352: ) lidset,
3353: ACCNT_CLASS AC,
3955: l_last_start_date := l_last_start_date1;
3956: SELECT trunc(min(stu.start_date))
3957: INTO l_gl_from_date1
3958: FROM gl_period_statuses stu,
3959: fii_slg_assignments slga,
3960: fii_source_ledger_groups fslg
3961: WHERE slga.ledger_id = stu.set_of_books_id
3962: AND slga.source_ledger_group_id = fslg.source_ledger_group_id
3963: AND fslg.usage_code = g_usage_code
4009: l_last_start_date := LEAST (l_last_start_date2, l_last_period_to2);
4010: SELECT trunc(min(stu.start_date))
4011: INTO l_gl_from_date2
4012: FROM gl_period_statuses stu,
4013: fii_slg_assignments slga,
4014: fii_source_ledger_groups fslg
4015: WHERE slga.ledger_id = stu.set_of_books_id
4016: AND slga.source_ledger_group_id = fslg.source_ledger_group_id
4017: AND fslg.usage_code = g_usage_code