Use the below script to perform duplicate data validation along with numeric data type validation in Javascript. <!–duplicate checking for lpn –> <script> function check_lpn(pThis) { var j_item_id=pThis.id; var k_item_id=’#f02’+j_item_id.substr(3);…
Read MoreUse the below Javascript to identify duplicate data – In this sample code, when user enters order number in the tabular form, an error will be thrown if the order…
Read MoreSELECT shipment_num, shipped_date, stnno, receipt_num, rcvd_date, send_orgid, send_orgname, recv_orgid, recv_org_name, gst_no, segment1, description, lot_num, pri_rec_uom, uomcode, LINK, rcv_qty, iso_price, iso_price_uom, NVL (tax_amount, 0) tax_amount, ((rcv_qty *…
Read MoreThe below query fetches the details of an Invoice along with the HSN Code of a respective item present in an Invoice. GST details can also be fetched. SELECT a.org_id,a.customer_trx_id,a.trx_number…
Read MoreThe below query fetches the data of purchase order wherein those items present in purchase order needs to be returned to Supplier because of some damage caused to goods etc..…
Read MoreThe below query fetches the details of a tax invocie where in Reverse charge mechanism(RCM) is applied in order to claim the extra tax paid by an organization along with…
Read MoreQuery retrieves data of those inventory items which are used for promotional purposes or given as a sample items for a sales executive in order to promote the products along…
Read MoreHCM Data Loader (HDL) Keys Supported Key Types: HCM Data Loader (HDL) supports 4 different types of keys as listed below GUID – Oracle Fusion Global Unique ID Oracle Fusion…
Read MoreBelow query is useful when you required Non Misc Receipts Along with Bank Statement Header , Line Details and Activity name ( like Receipt Write off) SELECT ACRA.RECEIPT_DATE ,( select…
Read MoreSELECT EXPT.EXPENDITURE_TYPE , EXPI.Quantity , CASE WHEN (EXPT.unit_of_measure=’HOURS’) THEN NVL(CDL.PROJECT_BURDENED_COST,cdl.project_raw_cost) END Raw_cost , –EXPI.DENOM_RAW_COST EXPI.ACCRUED_REVENUE , EXPI.expenditure_item_id , …
Read More