Sample Script to Schedule concurrent program from back end Procedure xxTTK_schedule_prog is l_conc_id VARCHAR2(500); l_responsibility_id NUMBER; l_application_id NUMBER; l_user_id NUMBER; l_request_id NUMBER; l_conc_id1 number; l_language VARCHAR2(50); l_territory VARCHAR2(50); l_option_return BOOLEAN;…
Read MoreQuery to find GL Period status SELECT * FROM gl_period_statuses ps, gl_sets_of_books sob, fnd_application_vl fnd WHERE 1=1 and ps.application_id = 101 AND sob.set_of_books_id = (SELECT set_of_books_id FROM org_organization_definitions WHERE ORGANIZATION_CODE…
Read MoreQuery to find Sales Person SELECT hcsu.primary_salesrep_id FROM hz_cust_accounts hca, hz_cust_acct_sites_all hcas, hz_cust_site_uses_all hcsu WHERE hca.cust_account_id = 940301 AND hca.cust_account_id = hcas.cust_account_id AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id AND hcsu.site_use_code = ‘BILL_TO’…
Read MoreQuery to find Third Party Registration SELECT DISTINCT TRIM (TO_CHAR (b.registration_number)) gst_num INTO lv_gst_num FROM jai_party_regs a, jai_party_reg_lines b WHERE 1 = 1 AND a.party_reg_id = b.party_reg_id AND a.party_type_code =…
Read MoreQuery 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 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 More