Query for Customer Receipt Details

SELECT   acra.cash_receipt_id,
         DECODE (acra.TYPE,
                 'cash', 'cash receipt receipt',
                 'misc', 'miscellaneous',
                 acra.TYPE
                ) receipt_type,
         acra.currency_code, acra.doc_sequence_value receipt_number,
         acra.receipt_number reference_number,
         TRUNC (acra.receipt_date) receipt_date, hp.party_name received_from,
         acra.misc_payment_source, hca.account_number customer_no,
         NVL (acra.amount, 0) entered_amount,
         NVL (acra.amount, 0) * NVL (acra.exchange_rate, 1) functional_amount,
         arm.NAME payment_method, abaa.bank_account_num bank_acc_num,
         abb.bank_name, abb.bank_branch_name, acra.comments description
    FROM ar_cash_receipts_all acra,
         ar_receipt_methods arm,
         ap_bank_accounts_all abaa,
         ap_bank_branches abb,
         hz_cust_accounts hca,
         hz_parties hp
   WHERE acra.pay_from_customer = hca.cust_account_id(+)
     AND acra.org_id = abaa.org_id(+)
     AND hca.party_id = hp.party_id(+)
     AND acra.receipt_method_id = arm.receipt_method_id
     AND acra.remittance_bank_account_id = abaa.bank_account_id
     AND abaa.bank_branch_id = abb.bank_branch_id
ORDER BY TRUNC (acra.receipt_date), acra.doc_sequence_value;

Calculating Weekdays between two dates

Calculating Weekdays between two dates

 

Create this function:

CREATE OR REPLACE FUNCTION totworkdays (fromdate DATE, todate DATE)
   RETURN NUMBER IS
   totalsundays     NUMBER;
   totalsaturdays   NUMBER;
begin
   totalsundays
        := NEXT_DAY (todate - 7, 'sunday')
           - NEXT_DAY (fromdate - 1, 'sunday');
   totalsaturdays
      :=   NEXT_DAY (todate - 7, 'saturday')
         - NEXT_DAY (fromdate - 1, 'saturday');

   RETURN (todate - fromdate - (totalsundays + totalsaturdays) / 7 - 1);
END totworkdays;

Call this function as follows:


declare
lv_tot_work_days number;
begin
lv_tot_work_days := totworkdays ('01-jan-2009', '31-jan-2009');
dbms_output.put_line('Total Work Days: '||lv_tot_work_days);
end;

Snagit Key

Below is the key for Snag It 9 and 11


Snag It 9 Version :
                           Name:4narchy
      Key:BDKYN-AAW7Y-AFSYB-VY6QV-BBA7F
Snag It 11 Version:
Name:4narchy
Key :ZEN5H-24LZK-TNYET-2EGKJ-MMCE4

Oracle Application R12, 7 Buckets Supplier Aging SQL

Below is the link which is used for Payments Aging Report Sql Query:

http://windows7bugs.wordpress.com/2013/03/06/oracle-application-r12-7-buckets-supplier-aging-sql/

Custom Top Creation:

Below is good link for Custom Top Creation.

http://www.appsdba.info/docs/oracle_apps/sysadmin/R12/CREATECUSTOMTOPINR12.pdf

Oracle Dumps for Certification

Below is the link for dumps for Practicing

https://www.logicsmeet.com/dumps/Oracle.aspx

How to download Work flow in Unix Box

Go to temp folder

Run below command for downloading workflow by passing user details along with work flow name.
 

WFLOAD apps/oradb9i 0 Y DOWNLOAD OEOH.wft OEOH