DBA Data[Home] [Help]

APPS.JL_BR_AR_BANK_ACCT_PKG dependencies on JL_REMIT1_GT

Line 1876: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Upgrade_Distributions','Create the Journal Entry Events and Headers. Inserting into xla_events, jl_remit1_gt,xla_ae_headers,jl_remit3_gt');

1872: -- are not added for Events, JE Headers, JE Lines and Dist Links
1873: -- because it is assumed that if the data in transaction entities is not
1874: -- present, then data in rest of the tables is also not present.
1875: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1876: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JL.plsql.JL_BR_AR_BANK_ACCT_PKG.Upgrade_Distributions','Create the Journal Entry Events and Headers. Inserting into xla_events, jl_remit1_gt,xla_ae_headers,jl_remit3_gt');
1877: END IF;
1878:
1879: INSERT ALL
1880: WHEN 1 = 1 THEN

Line 1928: INTO jl_remit1_gt

1924: 222,
1925: TRX_DATE
1926: )
1927: WHEN (JLBR_TRANSFER_TO_GL_FLAG = 'Y') THEN
1928: INTO jl_remit1_gt
1929: (
1930: SET_OF_BOOKS_ID,
1931: ENTITY_ID,
1932: EVENT_TYPE_CODE,

Line 2402: jl_remit1_gt TR2,

2398: 'PAYMENT_AFTER_WRITE_OFF', 'Bank Receipts', 'AUTOMATIC_WRITE_OFF', 'Write-off', 'Bank Charges' )) ||
2399: ' - Invoice ' ||substr(TR2.trx_number,1,15)) DESCRIPTION,
2400: grm.multiplier MULTIPLIER
2401: FROM
2402: jl_remit1_gt TR2,
2403: jl_remit1_gt refTR2,
2404: jl_br_ar_distributns_all dist,
2405: gl_row_multipliers grm
2406: WHERE

Line 2403: jl_remit1_gt refTR2,

2399: ' - Invoice ' ||substr(TR2.trx_number,1,15)) DESCRIPTION,
2400: grm.multiplier MULTIPLIER
2401: FROM
2402: jl_remit1_gt TR2,
2403: jl_remit1_gt refTR2,
2404: jl_br_ar_distributns_all dist,
2405: gl_row_multipliers grm
2406: WHERE
2407: dist.occurrence_id = TR2.occurrence_id