[Home] [Help]
1804: jl_br_ar_bank_occurrences bo,
1805: jl_br_ar_select_accounts_all csc,
1806: jl_br_ar_borderos_all b,
1807: ar_system_parameters_all sys,
1808: gl_date_period_map per1,
1809: gl_sets_of_books gsb
1810: WHERE oc.document_id between l_start_rowid and l_end_rowid
1811: AND nvl(oc.occurrence_status,'CONFIRMED') <> 'CREATED'
1812: And bo.bank_occurrence_code = oc.bank_occurrence_code
1860: And xae.ENTITY_CODE = 'JL_BR_AR_COLL_DOC_OCCS'
1861: And xae.LEDGER_ID = ract.set_of_books_id
1862: And nvl(xae.SOURCE_ID_INT_1,-99) = cd.document_id
1863: And nvl(xae.SOURCE_ID_INT_2,-99) = oc.occurrence_id)) X
1864: LEFT OUTER JOIN gl_date_period_map per
1865: USING (period_set_name, period_type, accounting_date);
1866:
1867: -------------------------------------------------------------------
1868: -- Create the Journal Entry Events and Headers
3118: jl_br_ar_mc_occ_docs mcod,
3119: jl_br_ar_collection_docs_all cd,
3120: ra_customer_trx_all ct,
3121: gl_ledgers lgr,
3122: gl_date_period_map map,
3123: gl_period_statuses gps,
3124: jl_br_ar_distributns_all dist,
3125: ar_mc_payment_schedules ps,
3126: xla_distribution_links dl,
3471: jl_br_ar_mc_occ_docs mcod,
3472: jl_br_ar_collection_docs_all cd,
3473: ra_customer_trx_all ct,
3474: gl_ledgers lgr,
3475: gl_date_period_map map,
3476: gl_period_statuses gps,
3477: jl_br_ar_distributns_all dist,
3478: ar_mc_payment_schedules ps,
3479: xla_distribution_links dl,