Auto Apply given receipts to Invoices
CREATE OR REPLACE PACKAGE BODY APPS.XX_RECEIPT_APPLICATION_PKG IS PROCEDURE MAIN( errbuf OUT VARCHAR2, retcode …
Read MoreAuto Apply given Credit memos to the Invoices
CREATE OR REPLACE PACKAGE BODY APPS.XX_CN_CM_APPLICATION_PKG IS PROCEDURE MAIN(errbuf OUT VARCHAR2,retcode OUT NUMBER,PR_GL_DATE IN VARCHAR2) IS v_count number(20):=0; v_date date :=fnd_date.canonical_to_date(PR_GL_DATE); v_end_date date; v_period_status …
Read MoreHow to Delete Stuckked/corrupted Lock Box Transmission format
select * from APPS.AR_TRANSMISSIONS_ALL where TRANSMISSION_NAME=’IMCC161107′; delete from apps.ar_transmissions_all where transmission_name=’IMCC161107′ select * from apps.ar_payments_interface_all where ORG_ID=82 and TRANSMISSION_ID=12172459; Thanks, Nagaraju M
Read MoreInactive Customer Open Balances
select * from apps.ap_expense_report_headers_all where report_header_id = ”; select * from hz_cust_accounts where account_number like ‘07724.0M978%’; select hca.account_number ,count(rct.trx_number) ,substr(to_char(rct.trx_Date,’DD/MM/YYYY’),4,2) ,sum(rgl.amount) ,sum(amount_due_remaining) OPEN_BL ,sum(rgl.amount)-sum(amount_due_remaining) CLOSED_BL ,rct.invoice_currency_code ,rct.org_id from apps.ra_customer_trx_all rct,…
Read MoreHow to Extract of all OU Wise Internal bank Accounts
SELECT cba.bank_account_name , cba.bank_account_id, cba.bank_account_name_alt, cba.bank_account_num , ou.name “OU NAME”, cba.multi_currency_allowed_flag , cba.zero_amount_allowed , cba.account_classification , bb.bank_name , cba.bank_id, bb.bank_number,…
Read MoreHow to Extract All the Asset Categories Book Wise with all Code Combinations.
gl3.segment1||’-‘||gl3.SEGMENT2||’-‘||gl3.SEGMENT3||’-‘||gl3.SEGMENT4||’-‘||gl3.SEGMENT5 DEPRN_RESERVE_ACCOUNT, deprn_method, life_in_months, (life_in_months/12) lIFE, prorate_convention_code FROM apps.fa_categories a, apps.FA_CATEGORY_BOOK_DEFAULTS b, apps.fa_category_books c, apps.gl_code_combinations gl1, apps.gl_code_combinations gl2, apps.gl_code_combinations gl3 WHERE a.category_id = b.category_id AND c.category_id = b.category_id AND c.category_id…
Read MoreOPEN PO Details (Standard PO)
SELECT poh.type_lookup_code source_type, prh.segment1 pr_number, trunc(prh.creation_date) pr_date, (select action_date from po_action_history where object_type_code=’REQUISITION’ and action_code=’APPROVE’ and…
Read MoreSales Order Dispatch details (Link between Material Transactions and Invoice)
SELECT oola.line_number, oola.line_id, ooha.orig_sys_document_ref , ooha.order_source_id, ooha.order_number sale_order_no, trunc(ooha.ordered_date) sale_order_date, hp_ship.party_name customer_name, –hl_ship.address1, …
Read MoreOnHand Quantity – With Serial number and Locator
select ohd.item, ohd.item_desc, ohd.org_code, ohd.org_name, ohd.sub_inventory, ohd.locator, msn.serial_number, ohd.item_status, ohd.uom, NVL2(msn.serial_number,1,ohd.total_onhand_qty) onhand_qty, ohd.total_onhand_qty, ohd.total_reserve_qty, ohd.total_transact_qty, mmt.transaction_date stock_in_date, mst.transaction_source_type_name stock_in_type from (SELECT msi.inventory_item_id , (select max(mq.create_transaction_id) from mtl_onhand_quantities mq…
Read MoreAn Introduction to Report Manager in Oracle EBS R12
This article describes Report Manager functionality in Oracle R12 which allows users to primarily publish and store Financial Statements/reports that are written using Financial Statement Generator (FSGs). Note that Report…
Read More