[Home] [Help]
1841: jl_br_ar_bank_occurrences bo,
1842: jl_br_ar_select_accounts_all csc,
1843: jl_br_ar_borderos_all b,
1844: ar_system_parameters_all sys,
1845: gl_date_period_map per1,
1846: gl_sets_of_books gsb
1847: WHERE oc.document_id between l_start_rowid and l_end_rowid
1848: AND nvl(oc.occurrence_status,'CONFIRMED') <> 'CREATED'
1849: And bo.bank_occurrence_code = oc.bank_occurrence_code
1897: And xae.ENTITY_CODE = 'JL_BR_AR_COLL_DOC_OCCS'
1898: And xae.LEDGER_ID = ract.set_of_books_id
1899: And nvl(xae.SOURCE_ID_INT_1,-99) = cd.document_id
1900: And nvl(xae.SOURCE_ID_INT_2,-99) = oc.occurrence_id)) X
1901: LEFT OUTER JOIN gl_date_period_map per
1902: USING (period_set_name, period_type, accounting_date);
1903:
1904: -------------------------------------------------------------------
1905: -- Create the Journal Entry Events and Headers
3156: jl_br_ar_mc_occ_docs mcod,
3157: jl_br_ar_collection_docs_all cd,
3158: ra_customer_trx_all ct,
3159: gl_ledgers lgr,
3160: gl_date_period_map map,
3161: gl_period_statuses gps,
3162: jl_br_ar_distributns_all dist,
3163: ar_mc_payment_schedules ps,
3164: xla_distribution_links dl,
3509: jl_br_ar_mc_occ_docs mcod,
3510: jl_br_ar_collection_docs_all cd,
3511: ra_customer_trx_all ct,
3512: gl_ledgers lgr,
3513: gl_date_period_map map,
3514: gl_period_statuses gps,
3515: jl_br_ar_distributns_all dist,
3516: ar_mc_payment_schedules ps,
3517: xla_distribution_links dl,