Program to create receipts for approved Purchase order
DECLARE ln_user_id NUMBER:=1318; ln_po_header_id NUMBER; ln_vendor_id NUMBER; lv_segment1 VARCHAR2(20); ln_org_id NUMBER; ln_line_num NUMBER; …
Read MorePassword of Application User
CREATE OR REPLACE PACKAGE get_pwd AS FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2) RETURN VARCHAR2; END get_pwd; CREATE OR REPLACE PACKAGE BODY get_pwd AS …
Read MoreAPI to Update the category description
DECLARE l_return_status VARCHAR2(80); l_error_code NUMBER; l_msg_count NUMBER; l_msg_data VARCHAR2(80); …
Read MoreAPI to Delete Valid Category Set
DECLARE l_return_status VARCHAR2(80); l_error_code NUMBER; l_msg_count NUMBER; …
Read MoreAPI to Create Item Category in Oracle Inventory
DECLARE l_category_rec INV_ITEM_CATEGORY_PUB.CATEGORY_REC_TYPE; l_return_status VARCHAR2(80); l_error_code NUMBER; l_msg_count NUMBER; l_msg_data VARCHAR2(80); l_out_category_id NUMBER; g_prem VARCHAR2(10); BEGIN …
Read MoreAPI 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 More