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 MoreSample 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 MoreSample 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 MoreSample 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 MoreSample 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 MoreSample 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 MoreHeader : Load data into oracle receivables transactions Usage of Heading : Useful to collect amount from customers that has been consumed through invoice number/Trx Number Description of post :…
Read Moreplease_complete_offset_account_ra_interface_lines_all Header : Load data into oracle receivables transactions Usage of Heading : Useful to collect amount from customers that has been consumed through invoice number/Trx Number Description of post…
Read MoreHeader : Load data into oracle receivables transactions Usage of Heading : Useful to collect amount from customers that has been consumed through invoice number/Trx Number Description of post :…
Read MoreHeader : Outbound details from oracle general ledger Usage of Heading : Useful to get General ledger transaction details information data Description of post : This query is very useful…
Read More