OracleAppsToday
All about Oracle Apps. API examples, Codes and tweaks, Commands, Tips and Tricks
Showing posts with label
General Ledger
.
Show all posts
Showing posts with label
General Ledger
.
Show all posts
Tuesday, July 1, 2014
Example : How to Generate Code Combination ID's (CCID) from Backend in Oracle R12
›
DECLARE l_code_combination_id NUMBER; l_boolean BOOLEAN; l_segment_array APPS.FND_FLEX_EXT.SEG...
Saturday, May 17, 2014
Mandatory Column For GL_Interface
›
Column Purpose SEGMENT1 through SEGMENT30 Identifies the Accounting Flexfield segment values of the journal C...
Accounting FlexFields of Bank Account in R12
›
alter session set current_schema=apps; SELECT cba.Bank_Account_Name, cbbv.Bank_Name, cbbv.Bank_Branch_Name, cba.Bank_Account_Num...
AR Receipts to Transaction Drill Down
›
select acra.receipt_number, acra.amount, rcta.trx_number, acra.receipt_date, apsa.amount_a...
Join GL tables with XLA (SubLedger Accounting) tables
›
Foreign Keys GL_JE_BATCHES (je_batch_id) => GL_JE_HEADERS (je_batch_id) GL_JE_HEADERS (je_header_id) ...
Drill Down from AR Cash Receipts to GL Ledger R12
›
Query: select distinct t.* from (select gl.name Ledger_Name, (gcc.segment1||'-'|| gcc.segment2||'-'|| ...
Home
View web version