Pages

▼
Showing posts with label AR. Show all posts
Showing posts with label AR. Show all posts

Find AR Invoice Post to GL Query

›
---AR Invoice is Posted to GL Query SELECT arc.customer_name,          rct.trx_number,          rct.trx_date,          rctt.name trx_name,  ...

AR Customer ALL Amount Details Query

›
 Select sum (invoice_amount) , sum(pending_amt) pay, sum (on_account) advanc , (sum(pending_amt) - sum (on_account)) bal From ( SELECT disti...

AR Debtors Ledger(Outstanding Bills) ALL Query

›
  --- Following Query for Inv, Credit memo . Debit Memo , Deposit  SELECT   b.org_id,hzca.cust_account_id customer_id,          hzca.account...

AR Customer Prepayment Aging Report Query

›
  SELECT customer_number, customer_name, paymt, day_030, day_031_060,        day_061_090, day_091_120, day_121_150, day_151_180, day_181, no...

Find the Operating Unit with AR and AP and Company Code and Location

›
---Find the Operating Unit with AR and AP and Company code and Location SELECT DISTINCT hrl.country,                 hroutl_bg.NAME bg,  ...

Order To Bill_to and Ship_to Customer Address

›
----------------------Bill To Customer------------------------------- SELECT hp.party_name,        hp.party_number,        hca.account_n...

How to find Company Address in a database function

›
/***** Company Ship to Location *********/ Create Or Replace Function COMPANY_ADDRESS(P_LOCATION_ID NUMBER) RETURN VARCHAR2 AS COMPANY ...

How to Find Customers in Oracle Apps a Single Query or View

›
CREATE OR REPLACE FORCE VIEW APPS.PARTY_CUST_V (    PARTY_NAME,    PARTY_NUMBER,    ACCOUNT_NUMBER,    CUST_ACCOUNT_ID,    CUSTOMER_C...