OracleAppsToday
All about Oracle Apps. API examples, Codes and tweaks, Commands, Tips and Tricks
Showing posts with label
Receivables
.
Show all posts
Showing posts with label
Receivables
.
Show all posts
Sunday, November 9, 2014
Types of Invoice Class in AR Transaction
›
Invoice : A document that you create that lists amounts owed for the purchases of goods or services, any tax, freight charges and payment te...
6 comments:
Saturday, May 17, 2014
Query to find strategies of a Customer Oracle R12 AR
›
Strategies of a Customer SELECT DISTINCT(ist.cust_account_id), ist.status_code, ist.strategy_id, ist.strategy_template_id, i...
AR Transactions to GL Drill Down
›
select * from RA_CUSTOMER_TRX_ALL where trx_number = &trx_num --pk customer_trx_id ; trx_number=100771 select * from RA_CUST_TRX_LINE...
AR Receipts to Transaction Drill Down
›
select acra.receipt_number, acra.amount, rcta.trx_number, acra.receipt_date, apsa.amount_a...
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