Create Customize POPUP LOV for APEX
Description: This section describes specific sections of the Edit Popup List of Values Template page. You can access the sections of the page either by scrolling down the page or…
Read MoreGST TAX Details For EBS R12
Introduction This post is about to GST TAX Details query in EBS R12 select decode(substr(h.tax_rate_code,1,4),’SGST’,nvl(h.unround_tax_amt_tax_curr,0)) SGST_AMT , decode(substr(h.tax_rate_code,1,4),’CGST’,nvl(h.unround_tax_amt_tax_curr,0)) CGST_AMT , decode(substr(h.tax_rate_code,1,4),’SGST’,nvl(h.tax_rate_percentage,0)) SGST_RATE, decode(substr(h.tax_rate_code,1,4),’CGST’,nvl(h.tax_rate_percentage,0)) CGST_RATE, h.first_party_primary_reg_num GST_NUM, h.third_party_primary_reg_num CUSOMER_GST_NUM, h.ledger_id LEDGER_ID , h.trx_number INVOICE_NUM,(SELECT jra.reporting_code FROM jai_reporting_associations jra,…
Read MoreQuery for AR Transactions Header with GST
Introduction This Post is about to AR Transactions Header with GST Query. SELECT DISTINCT rcta.trx_number, rcta.ct_reference, lep.legal_entity_id, lep.NAME legal_entity, rcta.trx_date invoice_date, –Bill to location details hp.party_name bill_cust_name, hcs1.LOCATION bill_to_loc, RTRIM (hrl.address_line_1, ‘,’) Billadd1, RTRIM (hrl.address_line_2, ‘,’) Billadd2, RTRIM (hrl.address_line_3, ‘,’) Billadd3, RTRIM (hrl.loc_information15, ‘,’) Billadd4,…
Read MoreCAPTURE LOG (LOGIN, LOGOUT, SESSION, SYSTEM) DETAILS IN ORACLE APEX 4.2
Description: User Log Reports provides detailed information about the users’ login details along with their history. These reports are more accurate and also provides the details of the user, their…
Read MoreHOW TO PLAY VIDEOS IN ORACLE APEX 4.2
Description: Viral advertising is a proven technique that will assist in enhancing your enterprise internet presence in a really Expense-powerful manner. It is a marketing activity in which information about a products spreads between people, especially on the internet. This technique allows you to play…
Read MoreDYNAMIC DATE RANGE IN APEX DATEPICKER
Description: Using this method, you can set the range of selectable dates by entering a Minimum and Maximum Date value dynamically “real-time.” Step 1: Create a Page Item (Example: “P101_DATE”). Step 2: Go to Settings -> Minimum Date In Minimum Date, valid condition has…
Read MoreCOORDINATE MAPPING IN ORACLE APEX
Description: Line coordinates are used to specify the position of a line just as point coordinates (or simply coordinates) are used to specify the position of a point. Users can draw multiple lines on an Apex Image Item, and the Coordinates of all the drawn lines can be obtained and stored in the Database Table. This…
Read MoreRUPEE SYMBOL IN REPORTS IN ORACLE APEX 4.2 USING HTML
Description: Most of the Applications includes Accounts Reports like Employee Payroll Reports, Company Purchase Reports, Invoice Reports, etc. Now using this method user can add RUPEE symbol in your reports.…
Read MoreDYNAMICALLY ADDING ROWS IN TABULAR FORM IN ORACLE APEX 4.2
Description: A good web design involves the better user interaction and the ability to fetch the data in a better way. In Tabular Form, the user can add rows only…
Read MoreADDING A FAVICON TO APEX
Description: A Favicon (Favorite Icon), also known as a Shortcut Icon, Web site Icon, Tab Icon, or Bookmark Icon, is a file containing one or more small icons, associated with…
Read More