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 More<?xml version = ‘1.0’ encoding = ‘UTF-8’?> <!– +======================================================================+ –> <!– | Copyright (c) 2005, 2015 Oracle and/or its affiliates. | –> <!– | …
Read More<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 MoreReport 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 MoreSteps 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 MoreThis 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 MoreSET 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 MoreWITH 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 MoreDECLARE v_api_return_status VARCHAR2 (1); v_qty_oh NUMBER; v_qty_res_oh NUMBER; v_qty_res NUMBER; v_qty_sug NUMBER;…
Read MoreInternal Concurrent Manager logfile Error : Routine &ROUTINE has attempted to start the internal concurrent manager. Issue : Users encounter the following error in the Internal Concurrent Manager logfile: Routine…
Read More