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.JL_CO_GL_NIT_MANAGEMENT dependencies on GL_CONSOLIDATION

Line 490: From gl_consolidation

486: And ent.entity_id = aeh.entity_id
487: And (aeh.ledger_id = g_parameter_rec.set_of_books_id
488: OR
489: aeh.ledger_id In (Select from_ledger_id
490: From gl_consolidation
491: Where to_ledger_id = g_parameter_rec.set_of_books_id)
492: )
493: AND aeh.ae_header_id = ael.ae_header_id
494: And ael.application_id = 200

Line 710: FROM gl_consolidation

706: AND aeh.application_id = ael.application_id
707: --bug8680825
708: /*and (ent.ledger_id = g_parameter_rec.set_of_books_id
709: or ent.ledger_id in (SELECT from_ledger_id
710: FROM gl_consolidation
711: WHERE to_ledger_id = g_parameter_rec.set_of_books_id))*/
712: AND ent.entity_code = 'AP_INVOICES'
713: AND i.invoice_id = ent.source_id_int_1
714: AND ent.entity_id = aeh.entity_id

Line 719: FROM gl_consolidation

715: --AND AEH.ledger_id = ent.ledger_id --bug8680825
716: AND (aeh.ledger_id = g_parameter_rec.set_of_books_id
717: OR
718: aeh.ledger_id IN (SELECT from_ledger_id
719: FROM gl_consolidation
720: WHERE to_ledger_id = g_parameter_rec.set_of_books_id)
721: )
722: AND aeh.ae_header_id = ael.ae_header_id
723: AND aeh.upg_batch_id is null

Line 772: FROM gl_consolidation

768: ent.application_id = 200
769: --bug8680825
770: /*and (ent.ledger_id = g_parameter_rec.set_of_books_id
771: or ent.ledger_id in (SELECT from_ledger_id
772: FROM gl_consolidation
773: WHERE to_ledger_id = g_parameter_rec.set_of_books_id))*/
774:
775: AND ent.entity_code = 'AP_PAYMENTS'
776: AND c.check_id = ent.source_id_int_1

Line 783: FROM gl_consolidation

779: --AND AEH.ledger_id = ent.ledger_id --bug8680825
780: AND (aeh.ledger_id = g_parameter_rec.set_of_books_id
781: OR
782: aeh.ledger_id IN (SELECT from_ledger_id
783: FROM gl_consolidation
784: WHERE to_ledger_id = g_parameter_rec.set_of_books_id)
785: )
786: and aeh.ae_header_id = ael.ae_header_id
787: and ael.application_id = 200

Line 833: FROM gl_consolidation

829: --bug8680825
830: /*and (ent.ledger_id = g_parameter_rec.set_of_books_id
831: ---AND lnk.source_distribution_type = 'AP_PREPAY' ---bug 7428486
832: or ent.ledger_id in (SELECT from_ledger_id
833: FROM gl_consolidation
834: WHERE to_ledger_id = g_parameter_rec.set_of_books_id))*/
835: AND ent.entity_code = 'AP_INVOICES'
836: AND i.invoice_id = ent.source_id_int_1
837: AND ent.entity_id = aeh.entity_id

Line 842: FROM gl_consolidation

838: --AND AEH.ledger_id = ent.ledger_id --bug8680825
839: AND (aeh.ledger_id = g_parameter_rec.set_of_books_id
840: OR
841: aeh.ledger_id IN (SELECT from_ledger_id
842: FROM gl_consolidation
843: WHERE to_ledger_id = g_parameter_rec.set_of_books_id)
844: )
845: AND aeh.ae_header_id = ael.ae_header_id
846: AND aeh.upg_batch_id is null

Line 900: FROM gl_consolidation

896: AND ent.entity_id = aeh.entity_id
897: AND (aeh.ledger_id = g_parameter_rec.set_of_books_id
898: OR
899: aeh.ledger_id IN (SELECT from_ledger_id
900: FROM gl_consolidation
901: WHERE to_ledger_id = g_parameter_rec.set_of_books_id)
902: )
903: AND aeh.ae_header_id = ael.ae_header_id
904: AND aeh.upg_batch_id is not null

Line 962: FROM gl_consolidation

958: AND apida.invoice_distribution_id = ap_trx.trx_dist_id;
959: --bug8680825
960: /*AND (apida.set_of_books_id = g_parameter_rec.set_of_books_id
961: OR apida.set_of_books_id in (SELECT from_ledger_id
962: FROM gl_consolidation
963: WHERE to_ledger_id = g_parameter_rec.set_of_books_id));*/
964: EXCEPTION
965: WHEN OTHERS THEN
966: --l_supplier_num := NULL;

Line 1951: FROM gl_consolidation

1947: ent.application_id = 222
1948: --bug8680825
1949: /*and (ent.ledger_id = g_parameter_rec.set_of_books_id
1950: or ent.ledger_id in (SELECT from_ledger_id
1951: FROM gl_consolidation
1952: WHERE to_ledger_id = g_parameter_rec.set_of_books_id))*/
1953:
1954: -- and ent.entity_code = 'TRANSACTIONS'
1955: --and i.invoice_id = ent.source_id_int_1

Line 1962: FROM gl_consolidation

1958: AND aeh.ae_header_id = ael.ae_header_id
1959: AND (aeh.ledger_id = g_parameter_rec.set_of_books_id --bug8680825
1960: OR
1961: aeh.ledger_id IN (SELECT from_ledger_id
1962: FROM gl_consolidation
1963: WHERE to_ledger_id = g_parameter_rec.set_of_books_id)
1964: )
1965: AND ael.application_id = 222
1966: AND R.gl_sl_link_id = AEL.gl_sl_link_id

Line 3175: FROM gl_consolidation

3171: AND aeh.ae_header_id = ael.ae_header_id
3172: AND (aeh.ledger_id = g_parameter_rec.set_of_books_id --bug8680825
3173: OR
3174: aeh.ledger_id IN (SELECT from_ledger_id
3175: FROM gl_consolidation
3176: WHERE to_ledger_id = g_parameter_rec.set_of_books_id))
3177: AND ael.application_id = 222
3178: AND R.gl_sl_link_id = AEL.gl_sl_link_id
3179: AND R.je_header_id = j_line.je_header_id