RA----> AR -----> HZ ----> Link - Oracle Concepts For You

Home » Ar_cash_receipts_all And Hz_cust_accounts » RA----> AR -----> HZ ----> Link - Oracle Concepts For You

Maybe your like

Wednesday, 10 August 2011

RA----> AR -----> HZ ----> Link

SELECT * FROM ar_cash_receipts_all cr, ar_cash_receipt_history_all crh_current, ar_receivable_applications_all apa, ar_payment_schedules_all psa, ar_lookups l_class, ra_customer_trx_all trx, ra_customer_trx_lines_all trxl, hz_cust_accounts cust, hz_parties party, hz_cust_site_uses_all su, hz_locations loc, hz_cust_acct_sites_all cas, hz_party_sites ps WHERE 1 = 1 AND crh_current.cash_receipt_id = cr.cash_receipt_id AND crh_current.current_record_flag = 'Y' AND 'Cleared' = arpt_sql_func_util.get_lookup_meaning ('RECEIPT_CREATION_STATUS', crh_current.status ) AND cr.pay_from_customer = cust.cust_account_id AND cust.party_id = party.party_id AND su.site_use_id = cr.customer_site_use_id AND cust.party_id = party.party_id AND cust.cust_account_id = cas.cust_account_id AND su.site_use_code = 'BILL_TO' AND su.cust_acct_site_id = cas.cust_acct_site_id AND cas.party_site_id = ps.party_site_id AND loc.location_id = ps.location_id AND cr.cash_receipt_id = apa.cash_receipt_id AND trx.customer_trx_id = trxl.customer_trx_id AND trx.customer_trx_id = psa.customer_trx_id AND psa.CLASS = l_class.lookup_code AND apa.applied_payment_schedule_id = psa.payment_schedule_id AND trxl.line_type = 'LINE' AND l_class.lookup_type = 'INV/CM' ORDER BY cr.attribute5 ASC; Posted by at 11:25

No comments:

Post a Comment

Newer Post Older Post Home Subscribe to: Post Comments (Atom)

About Me

My photo Elangovan Ragavan இளங்கோவன் ராகவன் எண்ணிய முடிதல் வேண்டும், நல்லவே யெண்ணல் வேண்டும்; திண்ணிய நெஞ்சம் வேண்டும், தெளிந்த நல் லறிவு வேண்டும்; பண்ணிய பாவமெல்லாம் பரிதி முன் பனியே போல, நண்ணிய நின்மு னிங்கு நசித்திட வேண்டும் அன்னாய்! View my complete profile

Oracle GRC

Oracle GRC Oracle Advanced Controls 11g Applications Certified Implementation Specialist

Followers

Live Viewers

Total Pageviews

Labels

  • .lst file (1)
  • About Page in OAF (3)
  • ADF (2)
  • Advanced Collections (1)
  • Advanced PL/SQL (18)
  • AIGS (10)
  • AIM Document (3)
  • Alert (7)
  • AME (17)
  • AOL (6)
  • AP Functional Accounting (17)
  • AP Payments (6)
  • AP_Module (84)
  • APEX (70)
  • API'S / INTREFACES (77)
  • Application Short Name (2)
  • approved supplier list (2)
  • APPS (11)
  • AR Functional (10)
  • AR_Query (72)
  • Back-to-Back Order Cycle (2)
  • Bank Query (34)
  • BOM (2)
  • Cash Management (8)
  • concurrent program (49)
  • Contorl file ctl (7)
  • Contorl file SQL *Loader (4)
  • Current Login Users (1)
  • custom.pll (7)
  • Customer (13)
  • Data Extraction (57)
  • Data Model (2)
  • Date Format (7)
  • DBA (114)
  • DELETE_QUERY (3)
  • DFF (7)
  • Documents (1)
  • DROP SHIP Order Flow (1)
  • Dummy Table (1)
  • EAM (16)
  • elango (6)
  • ERROR (28)
  • Executable (21)
  • FA (18)
  • FlexFields (8)
  • FND LOG (1)
  • FND_LOAD (13)
  • form personalization (52)
  • Forms (23)
  • FSG Report (1)
  • FUNCTIONAL (130)
  • gl (84)
  • GL Accounting (12)
  • GL Flow (3)
  • Global (1)
  • GRC (31)
  • GRC Function (1)
  • GRC Gertification (1)
  • GRC Screen (13)
  • GRC Tech (20)
  • HRMS (87)
  • Hyperion (7)
  • HZ TO ORG (1)
  • ICX - Oracle Self-Service Web Applications (2)
  • iExpenses (8)
  • IF (1)
  • India Localization (5)
  • Inventory_Details (69)
  • iprocurement (4)
  • ITEM_TEMPLATE (1)
  • java (8)
  • Legal entity (1)
  • Lexical & Bind (2)
  • LINKS IN ALL TABLES (6)
  • Lookup value (1)
  • Materialized View (2)
  • MO:Security Profile (2)
  • Multi-Org (24)
  • My Favorited Links (2)
  • MY FAVOURITES (2)
  • O2C CYCLE (28)
  • OBIEE (74)
  • ODI (1)
  • OM (23)
  • OM Setup (9)
  • Oracle (2)
  • ORACLE -Orbital Relational Analytical Computing Logical Equation (5)
  • Oracle Certification (1)
  • Oracle Discoverer (4)
  • Oracle Interview Questions (45)
  • Oracle Pricing (9)
  • Oracle Property Manager (5)
  • Oracle Setup Steps (1)
  • Oracle Standard Reports (25)
  • org (5)
  • OUM Methodology (1)
  • Outlook (1)
  • Output type in Oracle (1)
  • P2P Cycle (17)
  • Password in EBS (3)
  • Payroll (2)
  • Personalize OAF Pages (16)
  • PL/SQL (53)
  • PO (83)
  • Printer Assign process (1)
  • profile (10)
  • Projects (58)
  • Pure Silence for Life... :) (1)
  • QUERY (3)
  • R12 (3)
  • RDF report (5)
  • Receipt (1)
  • Reconciled Payments (2)
  • REPORT (15)
  • REPORT NAMES (1)
  • REPORT_QUERY (12)
  • request group (2)
  • Request Set (3)
  • Reset the po (2)
  • Responsibility (24)
  • RICE (1)
  • Row count (1)
  • Shell Script (6)
  • Shortcut Key (1)
  • SLA (13)
  • SOB (3)
  • SQL (98)
  • SRW.user_exit (2)
  • SUB_QUERY (1)
  • Supplier (29)
  • sysadmin (17)
  • Tables (71)
  • TAX (17)
  • TCA R12 (7)
  • technical (4)
  • Time Formets (3)
  • TOAD (3)
  • Trace (3)
  • UPDATE QUERY (20)
  • User Hooks (1)
  • USER_RES_MENU (14)
  • Valueset (18)
  • Videos (6)
  • VPD in Oracle (1)
  • Web ADI in Oracle (4)
  • Windows XP (1)
  • WIP (2)
  • Workflow (5)
  • XLA_SUB_LEDGER (20)
  • xml (91)

Blog Archive

  • ▼  2011 (239)
    • ▼  August (16)
      • Puchasing and Payables Module: Technical Details
      • po headers based sub query
      • Before report trigger to show the parameter using ...
      • APIL PO RECEIPT REJECTION REPORT(PO-RCV-INV)_LINK
      • Customer details of an order
      • Querys
      • XML_Functionalitys _Tutorial
      • TAX Find Report_Query
      • HOW TO CREATE A SUPPLIER IN FUNCTIONAL
      • PROJECT MODULE TABLES
      • Oracle HRMS Tables
      • RA----> AR -----> HZ ----> Link
      • Request Set
      • Set Operations
      • Date format query
      • Create AR Invoice using API

Tag » Ar_cash_receipts_all And Hz_cust_accounts