GL Flexi ield Query with additional details
GL module used to maintain credit and Debit details in oracle. Gl code combinations are used maintain details of company with respect to legal entity level. This script used to…
Read MoreAP PO Vendor Creation interface with additional attributes
Payables modules are used to create supplier related information in oracle. In this module we can create supplier invoice bank etc will be maintained. This script used to create Supplier…
Read MoreInventory Lot Creation Interface
Inventory module used to create items in oracle. This module will link with AP, PO, GL modules. In inventory we have lot concepts where we will create lots , so…
Read MoreQuery to find Tax Recoverable
Query to find Tax Recoverable SELECT NVL (attribute_value, ‘N’) FROM jai_item_templ_hdr_v jih, jai_item_templ_dtls_v jid WHERE 1 = 1 AND jih.template_hdr_id = jid.template_hdr_id AND jid.attribute_code = ‘RECOVERABLE’ AND jih.inventory_item_id = lv_inv_item_id…
Read MoreQuery to Find HSN Code
Query to Find HSN Code SELECT REPORTING_CODE FROM jai_reporting_codes jrc, jai_reporting_types jrt WHERE jrc.reporting_type_id = jrt.reporting_type_id AND jrt.reporting_type_code = ‘GST_HSN_CODE’ AND TRUNC (SYSDATE) BETWEEN jrt.effective_from AND NVL (jrt.effective_to, TRUNC (SYSDATE…
Read MoreCall Auto invoice for Order number Range
Sample Call Auto invoice for Order number Range PROCEDURE xx_bdg_ar_autoinvoice ( errbuf OUT VARCHAR2, retcode OUT VARCHAR2, p_org_id NUMBER ) AS l_responsibility_id NUMBER; l_application_id NUMBER; l_user_id NUMBER; l_request_id NUMBER; l_batch_source…
Read MoreShip Confirm
Sample script for Ship confirm PROCEDURE xx_bdg_ship_confirm ( errbuf OUT VARCHAR2, retcode OUT VARCHAR2, p_org_id NUMBER ) AS x_return_status VARCHAR2 (2); x_msg_count NUMBER; x_msg_data VARCHAR2 (2000); p_api_version_number NUMBER := 1.0;…
Read MorePick Release
Sample script for Pick Release PROCEDURE xx_bdg_sin_delv_picrelease ( errbuf OUT VARCHAR2, retcode OUT VARCHAR2, p_org_id NUMBER ) AS x_return_status VARCHAR2 (2); x_msg_count NUMBER; x_msg_data VARCHAR2 (2000); p_api_version_number NUMBER := 1.0;…
Read MoreBook Sales Order
Sample script to book the sales Order PROCEDURE xx_book_bdg_so ( errbuf OUT VARCHAR2, retcode OUT VARCHAR2, p_org_id NUMBER ) AS v_api_version_number NUMBER := 1; v_return_status VARCHAR2 (2000); v_msg_count NUMBER; v_msg_data…
Read MoreReserve Lot number for the order
Sample script for Reserve Lot number for the order PROCEDURE xx_bdg_Reserve_attribs ( errbuf OUT VARCHAR2, retcode OUT VARCHAR2, p_org_id NUMBER ) IS v_api_version_number NUMBER := 1; v_return_status VARCHAR2 (2000); v_msg_count…
Read More