Query For Customer Receipt Details

Home » Ar_cash_receipts_all And Hz_cust_accounts » Query For Customer Receipt Details

Maybe your like

Apps Query

Developers in 11i/R12 EBS are in a race with the Universe to create better idiot-proof programs, while the Universe is trying to create better idiots. So far the Universe is winning.

  • Home
  • Business
    • Internet
    • Market
    • Stock
  • Downloads
    • Dvd
    • Games
    • Software
      • Office
  • Parent Category
    • Child Category 1
      • Sub Child Category 1
      • Sub Child Category 2
      • Sub Child Category 3
    • Child Category 2
    • Child Category 3
    • Child Category 4
  • Featured
  • Health
    • Childcare
    • Doctors
  • Uncategorized

Recent Posts

Categories

AIM (3) AOL (23) AP (15) API (14) AR (19) CE (1) DFF (1) EAM (1) Enterprises Model (6) FA (18) GL (10) How (15) HRMS (19) IB (1) Info (11) INV (5) Issue (1) Locking (2) Misc (1) More4Apps (1) OE (2) OKC (2) OKE (1) OKS (4) OM (4) Oracle (3) Oracle Applications (10) Oracle Price Lists (1) Oracle Product (1) Payroll (2) PJM (1) PO (7) Project Accounting (2) Query (96) R12 (5) Reconcilation (2) Sample (1) WorkFlow (2) WSH (6)

Definition List

Query for Customer Receipt Details

6:37 AM AR, Query 1 comment 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; Newer Post Older Post Home

1 comments:

  1. bsnssexpertDecember 14, 2021 at 10:21 PM

    Create Fake Receipt | Make a receipt | Make a custom receiptAre you looking for best custom receipts template online where you have complete flexibility to design and create your own receipts? You can find variety of combination food receipt templates, restaurant receipt templates, taxi receipt templates, hotel receipt templates, gas receipt templates, fuel receipt templates, cab receipt templates. It gives variety template with default setting values. On top, user can choose different font types, different font size by section bases in the template. It allows the maximum customize receipts at customer finger tips. It let you create thousands of unique combinations of receipts which can satisfy any receipts in this planet.For More Info:- make a receipt

    ReplyDeleteReplies
      Reply
Add commentLoad more... Newer Post Older Post Home Subscribe to: Post Comments (Atom)

Social Profiles

TwitterFacebookGoogle PlusLinkedInRSS FeedEmail
  • Popular Posts
  • Archives
  • Query : Query to get Person type for All Employees SELECT PAPF.PERSON_ID, PAPF.FIRST_NAME AS FIRST_NAME, PAPF.LAST_NAME AS LAST_NAME, PAPF.EMPLOYEE_NUMBER AS EMPLOYEE_NUMBER, TO_CHAR(PAPF...
  • How : How to enable the DFF for the Lookup? If you want to enable the DFF and enter some additional entries in Lookups you just need to follow the below steps STEPS FOR YOU: Creat...
  • Query : To Check whether Periods of AP/AR/GL/FA/PO is closed? SELECT (SELECT sob.NAME FROM gl.gl_sets_of_books sob WHERE sob.set_of_books_id = a.set_of_books_id) "SOB_Nam...
  • Query : Get the Inventory org Address select * from hr_locations_v hlv, hr_all_organization_units hou WHERE hlv.inventory_organization_id = hou.organization_id AND hlv.locatio...
  • Query : Get the Serial Number for an Order SELECT wl.meaning release_status , wdd.released_status , wdd.source_line_id , wdd.source_code , wser.fm_serial_numbe...
  • Query : Sales Order Hold & Release SELECT OHA.ORDER_NUMBER, HS.HOLD_ENTITY_CODE CREDIT_CHECK_CRITERIA_CODE, FLV.MEANING CREDIT_CHECK_CRITERIA, HD.NAME ...
  • INFO: EMPLOYEE_CATEGORY holds in the table *PER_ALL_ASSIGNMENTS_F Employee Category is a lookup. the value that is in per_all_assignments_f for employee_category is the lookup_code that is stored. FND_COMM...
  • Query : To get Active Employees and Terminated Employees SELECT PAAF.ASSIGNMENT_ID, PAPF.PERSON_ID AS PERSON_ID2, PAPF.FIRST_NAME AS FIRST_NAME, PAPF.LAST_NAME AS LAST_NAME, PAPF.EMAIL_ADDRESS...
  • Query : Relation between Order Number & Contract Number Relation between Order Number (From Order Management) and Contract Number (From Service Contracts module). The relationship is maintained ...
  • Query to find out Move order line details SELECT wnd.delivery_id, ...

Blog Archive

  • ▼  2008 (9)
    • ▼  April (1)
      • Query for Customer Receipt Details

Text Widget

Download

Developers in 11i/R12 EBS are in a race with the Universe to create better idiot-proof programs, while the Universe is trying to create better idiots. So far the Universe is winning..
 

  • Labels

    • AIM
    • AOL
    • AP
    • API
    • AR
    • CE
    • DFF
    • EAM
    • Enterprises Model
    • FA
    • GL
    • How
    • HRMS
    • IB
    • Info
    • INV
    • Issue
    • Locking
    • Misc
    • More4Apps
    • OE
    • OKC
    • OKE
    • OKS
    • OM
    • Oracle
    • Oracle Applications
    • Oracle Price Lists
    • Oracle Product
    • Payroll
    • PJM
    • PO
    • Project Accounting
    • Query
    • R12
    • Reconcilation
    • Sample
    • WorkFlow
    • WSH

  • Pages

    • Home
Copyright © 2013 Apps Query | Powered by Blogger Design by FThemes | Blogger Theme by Lasantha - Distributed by: free blogger templates teachersfree blogger templates xml download | cheap vpn for iran best vpn mac china

Tag » Ar_cash_receipts_all And Hz_cust_accounts