Introduction: This script will help to extract the price adjustment not populated in order lines for the Customer have the Accrual in Trade Management Script: 1. Modifiers Exist For Customer,…
Read MoreIntroduction: This Post illustrates the steps to Update the schedule ship date in Order Lines using API. Script to Update the Scheduled Ship Date in Order Lines DECLARE p_scheduled_ship_date DATE…
Read MoreThe below is the query which will provide the supplier bank details: SELECT vendor_name supplier_name, segment1 supplier_number, ass.vendor_site_code site_code, ieba.bank_account_name, ieba.bank_account_num, ieba.masked_bank_account_num, (select user_name from apps.fnd_user where user_id=ieba.last_updated_by) updated_by, to_char(ieba.last_update_date,’dd-Mon-yy…
Read MoreIntroduction: This Post illustrates the steps required to upload the GL budget data using the interface program. Steps Create the Staging Table. Compile the given Package. Register the Concurrent Program…
Read MoreAIM: Bellow query is used for getting the data of AR Collection report for last four weeks in account receivable. Script: select ( SELECT TERRITORY_SHORT_NAME FROM fnd_territories_vl WHERE TERRITORY_CODE=COUNTRY.COUNTRY)COUNTRY, CURRENCY_CODE,…
Read MoreAIM: This query is used for Iexpence Report query. Script: select APERH.EMPLOYEE_ID ,APERH.INVOICE_NUM EXPENSE_NUMBER ,DECODE(APERH.WORKFLOW_APPROVED_FLAG,’S’,’SAVED’,’I’,’IMPLICIT SAVE’,’R’,’MANAGER REJECTED’,’M’,’MANAGER APPROVED’,’P’ ,’PAYABLES APPROVED’,’A’,’AUTO APPROVED’,’W’,’WITHDRAWN’,’Y’,’APPROVED’,’IN PROGRESS’) INVOICE_STATUS ,aperh.expense_status_code ,APERH.CREATION_DATE ,OVERRIDE_APPROVER_NAME APPROVER_NAME , CASE WHEN…
Read MoreAIM: This query is used for RA Customer transaction in Account receivable. Script : SELECT hp.party_name CUSTOMER_NAME, rcta.TRX_NUMBER INVOICE_NUMBER, rcta.trx_date INVOICE_DATE, (SELECT SUM (extended_amount) FROM ra_customer_trx_lines_all ct WHERE ct.customer_trx_id =…
Read MoreAIM: This query is used for getting the data of AR Receipt in account receivable. Script: SELECT ABA.NAME Receipt_Batch ,DECODE(ACRA.STATUS,’APP’,’APPLIED’,’UNID’,’UNIDENTIFIED’,’UNAPP’,’UNAPPLIED’,’REV’,’REVERSED’,ACRA.STATUS) STATE ,acra.RECEIPT_NUMBER ,ACRA.COMMENTS ,sum(unapp.amount_applied) Unapplied_Amount ,ACRA.TYPE ,ACRA.AMOUNT RECEIPT_AMOUNT ,ARM.NAME RECEIPT_MENTHOD…
Read MoreThis Query is used for getting the AP invoice for TDS during the current financial Year. Script: SELECT SEGMENT1 SUPPLIER_NUMBER ,VENDOR_NAME SUPPLIER_NAME ,ACTUAL_SECTION_CODE SECTION_CODE ,aia.invoice_num ,aia.invoice_date , jt.TAX_AMOUNT tax_amount ,SUM(JT.AMOUNT) …
Read MoreAIM: Component is used for Create the Requisition against the Blanket Purchase Agreement For different Locations. SCRIPT: CREATE OR REPLACE PACKAGE BODY APPS.XXTTK_BPO_PKG IS PROCEDURE XXTTK_REQ ( ERRORBUF OUT VARCHAR2…
Read More