Posts by Brahmaiah kolla

Query to get FA Mass Additions Details

SELECT DISTINCT fma.book_type_code, fma.posting_status, fma.description, fcb.segmnet1 major_category, fcb.segment2 minor_category, fma.fixed_assets_units, fma.fixed_assets_cost, (select segment3   from fa_locations where location_id=fma.location_id) location, fma.date_placed_in_service, fma.asset_number, fma.asset_key_segment1, fma.asset_key_segment2, invoice_number, po_number, vendor_number, queue_name, invoice_date, payables_cost, depreciate_flag,…

Read More

Query to get Asset Remaining Life

SELECT DISTINCT fb.asset_number, fab.book_type_code, (SELECT   CASE WHEN decode(faab.conversion_date, NULL, faab.life_in_months-floor(months_between(fdpp.calender_period_close_date,faab.prorate_date)), faab.life_in_months-floor(months_between(fdpp.calender_period_close_date,faab.deprn_start_date)))<=0 then 0 ELSE decode(faab.conversion_date, NULL, faab.life_in_months-floor(months_between(fdpp.calender_period_close_date,faab.prorate_date)), faab.life_in_months-floor(months_between(fdpp.calender_period_close_date,faab.deprn_start_date))) END FROM apps.fa_books faab, apps.fa_deprn_periods fdpp, apps.fa_additions_bfbb WHERE faab.asset_id=fbb.asset_id   AND…

Read More

Query to get the tax type and tax accounts details.

SELECT hou.name Entity_name, tax_type_id, tax_type_code, tax_type_name, (SELECT concatenated_segments FROMapps.gl_code_combinations_kfv WHEREcode_combination_id=interim_recovery_ccid) interim_recovery_ccid, (SELECT concatenated_segments FROMapps.gl_code_combinations_kfv WHEREcode_combination_id=recovery_ccid) recovery_ccid, (SELECT concatenated_segments FROMapps.gl_code_combinations_kfv WHEREcode_combination_id=interim_liability_ccid) interim_liability_ccid, (SELECT concatenated_segments FROMapps.gl_code_combinations_kfv WHEREcode_combination_id=liability_ccid) liability_ccid FROM apps.jai_tax_types_v tv, apps.jai_tax_accounts…

Read More

Query to get ship to and Dist location mismatch invoices details.

select distinct hou.name,         a.org_id, a.invoice_id, a.invoice_num, a.invoice_date, a.attribute11 ship_to d.segment4 dist_loc, aps.vendor_name, apsa.vendor_site_code from apps.ap_invoices_all a, apps.ap_invoice_lines_all b, apps.ap_invoice_distributions_all c, apps.gl_code_combinations d, apps.hr_operating_units hou, apps.ap_suppliers aps,…

Read More

Query to get Accounting issue invoice details

select org_id, customer_trx_id, sum(tax) tax, sum(rev) rev, sum(rec) rec, sum(tax)+sum(rev) acutal_rec from ( select org_id, customer_trx_id, case when account_class=’TAX’ then sum(amount) else 0 end tax, case when account_class=’REV’ then sum(amount)…

Read More

Query to get the AR Netting details

select * from (select fnar.batch_id, fnar.customer_trx_id, rct.bill_to_customer_id cust_acct_id, rct.bill_to_site_use_id cust_site_use_id, fnar.ar_txn_rank, nvl(fnar.netted_amt,0) as netted_amt, fnb.batch_currency as reckoning_currency, rct.trx_number, rct.invoice_currency_code as transaction_currency, rctt.description as transaction_type, hp.party_name as cust_acct_name, hca.account_number as cust_acct_number,…

Read More

Display the multiple errors in OAF

import com.sun.java.util.collections.ArrayList; import oracle.apps.fnd.framework.OAException; import oracle.apps.fnd.common.MessageToken; ArrayList errorMsg= new ArrayList(); for (int i=0; i< hMember.size(); i++) { MessageToken[] token = {new MessageToken(“USER”, getOADBTransaction().getUserName()),new MessageToken(“NUM”,hMember.getChildNumber())}; errorMsg.add(new OAException((String)(getOADBTransaction().getMessage(“XXFKI”,”XXFKI_ERRORS”,token)))); } OAException.raiseBundledOAException(errorMsg);

Read More

How to change the column header dynamically in advance table.

To change the column of a header dynamically use the following code in your controller. import oracle.apps.fnd.framework.webui.beans.table.OAAdvancedTableBean; import oracle.apps.fnd.framework.webui.beans.table.OAColumnBean; import oracle.apps.fnd.framework.webui.beans.table.OASortableHeaderBean; OAAdvancedTableBean tableBean = (OAAdvancedTableBean)webBean.findIndexedChildRecursive(“VendordtlRN”); OAColumnBean columnBean = (OAColumnBean)tableBean.findIndexedChildRecursive(“SupplierID”); OASortableHeaderBean…

Read More

Lower Deduction Cost

Lower Deduction Cost Details Introduction: This report will provide LDC details. Cause of the issue: To get the remaining amount pan wise. How do we solve: So, extract the LDC…

Read More

Supplier Contact Details

Supplier Contact Details Introduction: This report will provide active supplier contact details. Cause of the issue: To apply TDS tax deduction against open invoice. How do we solve: So, extract…

Read More