APPS.JL_CO_GL_NIT_MANAGEMENT dependencies on GL_CONSOLIDATION

Line 605: FROM gl_consolidation

601: and ent.application_id =aeh.application_id
602: and aeh.application_id = ael.application_id
603: and (ent.ledger_id = g_parameter_rec.set_of_books_id
604: or ent.ledger_id in (SELECT from_ledger_id
605: FROM gl_consolidation
606: WHERE to_ledger_id = g_parameter_rec.set_of_books_id))
607: and ent.entity_code = 'AP_INVOICES'
608: and i.invoice_id = ent.source_id_int_1
609: and ent.entity_id = aeh.entity_id

Line 654: FROM gl_consolidation

650: WHERE
651: ent.application_id = 200
652: and (ent.ledger_id = g_parameter_rec.set_of_books_id
653: or ent.ledger_id in (SELECT from_ledger_id
654: FROM gl_consolidation
655: WHERE to_ledger_id = g_parameter_rec.set_of_books_id))
656:
657: and ent.entity_code = 'AP_PAYMENTS'
658: and c.check_id = ent.source_id_int_1

Line 707: FROM gl_consolidation

703: and aeh.application_id = ael.application_id
704: and (ent.ledger_id = g_parameter_rec.set_of_books_id
705: AND lnk.source_distribution_type = 'AP_PREPAY'
706: or ent.ledger_id in (SELECT from_ledger_id
707: FROM gl_consolidation
708: WHERE to_ledger_id = g_parameter_rec.set_of_books_id))
709: and ent.entity_code = 'AP_INVOICES'
710: and i.invoice_id = ent.source_id_int_1
711: and ent.entity_id = aeh.entity_id

Line 758: FROM gl_consolidation

754: --AND apida.distribution_line_number = ap_trx.trx_dist_id
755: AND apida.invoice_distribution_id = ap_trx.trx_dist_id
756: and (apida.set_of_books_id = g_parameter_rec.set_of_books_id
757: or apida.set_of_books_id in (SELECT from_ledger_id
758: FROM gl_consolidation
759: WHERE to_ledger_id = g_parameter_rec.set_of_books_id));
760:
761: END IF;
762:

Line 1194: FROM gl_consolidation

1190: WHERE
1191: ent.application_id = 222
1192: and (ent.ledger_id = g_parameter_rec.set_of_books_id
1193: or ent.ledger_id in (SELECT from_ledger_id
1194: FROM gl_consolidation
1195: WHERE to_ledger_id = g_parameter_rec.set_of_books_id))
1196:
1197: -- and ent.entity_code = 'TRANSACTIONS'
1198: --and i.invoice_id = ent.source_id_int_1