SELECT SUM(peevf.screen_entry_value) FROM pay_element_types_f petf ,pay_element_entry_values_f peevf ,pay_element_entries_f peef ,per_all_assignments_f paaf ,pay_input_values_f pivf WHERE paaf.assignment_id = p_assignment_id AND p_effective_date between paaf.effective_start_date and paaf.effective_end_date AND peef.assignment_id = paaf.assignment_id AND peef.effective_start_date between…
Read MoreSELECT DISTINCT STORE.NAME store_name, smartforms.template_name request_name, pas.commodity_id, pas.vendor_name supplier, (SELECT NAME FROM apps.hr_operating_units WHERE organization_id = smartforms.org_id) operating_unit, (SELECT segment1 || ‘.’ || segment2 FROM apps.mtl_categories_b WHERE category_id = smartforms.category_id)…
Read MoreSELECT pvs.org_id org_id, iep.default_payment_method_code, alc.lookup_code, hou.NAME org_name, pv.vendor_id supplier_id, pv.segment1 supplier_number, plc.description supplier_type, pv.vendor_name supplier_name, …
Read MoreYou have lot of tables ending with different suffixes in Oracle Apps database. Did you ever wonder what these denote? Listed below are the different table suffixes and what they…
Read MoreHow to programmatically close PO using PO_ACTIONS API PO_ACTIONS.CLOSE_PO is the API used to programmatically close/final close Purchase Order. We have to pass P_ACTION parameter value as ‘CLOSE’/’FINALLY CLOSE’ depending…
Read MoreDECLARE CURSOR c1 IS SELECT a.rowid row_id,a.* FROM temp_gl_code a WHERE process_flag= ‘N’; l_segment1 …
Read MoreSELECT h.header_id header_id, party.party_name sold_to, h.order_number order_number, NVL (TO_CHAR (h.ordered_date, ‘DD-MON-YYYY’), TO_CHAR (h.request_date, ‘DD-MON-YYYY’) …
Read MoreSELECT * FROM (SELECT b.item_code, b.item_description item_description, b.primary_uom, b.sub_inventory, b.LOCATOR, b.opening_qty opening_qty,…
Read MoreOverview: 1. Purpose. 2. Benefits. 3. Steps. 4. Screen shots. 5. Conclusion. 1. Purpose: This document describes how to Use an Favicons in Apex 5 Top Navigation Menu. In Apex 5, Navigation Menu Position is…
Read MoreOverview: 1. Purpose. 2. Benefits. 3. Steps. 4. Screenshots. 5. Conclusion. 1. Purpose: This document describes how to show a Apex Reports with Row Details In Apex, Report is an important tool which is in classical,…
Read More