API to Assign Item to Inventory
DECLARE g_user_id fnd_user.user_id%TYPE :=NULL; l_appl_id fnd_application.application_id%TYPE; l_resp_id …
Read MoreAPI Create a valid category set
DECLARE l_return_status VARCHAR2(80); l_error_code NUMBER; l_msg_count NUMBER; l_msg_data …
Read MoreAll approved requisition report for the month including PO
SELECT R.SEGMENT1 “Req number”, Rl.Line_Num “Req line”, rl.suggested_vendor_product_code supplier_item, (SELECT DISTINCT Description FROM Apps.Mtl_Categories WHERE Category_Id=Rl.Category_Id ) “Req Line Category Description”, (SELECT DISTINCT…
Read MoreSales Revenue Straight Line Calculation Report
<?xml version = ‘1.0’ encoding = ‘UTF-8’?> <!– +======================================================================+ –> <!– | Copyright (c) 2005, 2015 Oracle and/or its affiliates. | –> <!– | …
Read MoreApproved Requisition Report
<dataTemplate name=”POREQAPPR” version=”1.0″> <parameters> <parameter name=”P_APPROVED_FROM_DT” dataType=”DATE”/> <parameter name=”P_APPROVED_TO_DT” dataType=”DATE”/> </parameters> <dataQuery> <sqlStatement name=”Q_HEAD_PARAMTERS”> <![CDATA[ Select to_char(:P_APPROVED_FROM_DT,’DD-Mon-RRRR’) FROM_DATE,to_char(:P_APPROVED_TO_DT,’DD-Mon-RRRR’) TO_DATE from dual ]]> </sqlStatement> <sqlStatement name=”Q_1″> <![CDATA[ /* Formatted on 2019/02/19…
Read MoreCustomer Credit Snapshot
Report will fetch and display all customer credit card snap shot details in excel format <?xml version=”1.0″ encoding=”UTF-8″ ?> <!– $Header: ARXCCS_XML.xml 120.0 2007/12/27 15:07:07 abraghun noship $ –> <!–…
Read MoreEasy to Create or Customize Interactive Reports
Steps Navigate to the Welcome dashboard. Click your name in the global area and select Edit Current Page. Click Change Layout and select Two columns, narrow left. Click Add Content for the narrow column. The Reports and…
Read MoreTVA AP VAT Report
This report will fetch all VAT details in AP module <dataTemplate name=”IRNGLBFRTVAAP” version=”1.0″> <parameters> <parameter name=”P_ACCT_FROM_DT” dataType=”DATE”/> <parameter name=”P_ACCT_TO_DT” dataType=”DATE”/> </parameters> <dataQuery> <sqlStatement name=”Q_HEAD_PARAMTERS”> <![CDATA[ Select to_char(:P_ACCT_FROM_DT,’DD-Mon-RRRR’) FROM_DATE,to_char(:P_ACCT_TO_DT,’DD-Mon-RRRR’) TO_DATE from…
Read MoreAPI to Update Customer Account in TCA R12
SET SERVEROUTPUT ON; DECLARE p_cust_account_rec HZ_CUST_ACCOUNT_V2PUB.CUST_ACCOUNT_REC_TYPE; p_object_version_number NUMBER; x_return_status VARCHAR2(2000); x_msg_count NUMBER; x_msg_data VARCHAR2(2000); BEGIN — Setting the Context — mo_global.init(‘AR’); fnd_global.apps_initialize ( user_id => 1318 ,resp_id => 50559 ,resp_appl_id => 222); mo_global.set_policy_context(‘S’,204); fnd_global.set_nls_context(‘AMERICAN’); — Initializing the Mandatory API parameters p_cust_account_rec.cust_account_id := 150734; p_cust_account_rec.customer_type := ‘R’; — Should be available…
Read MoreHow to Convert Comma Separated Values into Table using 'REGEXP_SUBSTR'
WITH csv AS (SELECT ‘AA,BB,CC,D33D,EE,FFDD,MM,GG’ AS csvdata FROM DUAL) SELECT REGEXP_SUBSTR (csv.csvdata, ‘[^,]+’, 1, LEVEL) pivot_char FROM DUAL, csv CONNECT BY REGEXP_SUBSTR (csv.csvdata,'[^,]+’,…
Read More