Introduction: Using the below SQL script we can get the Catalog and Non Catalog Po’s details from country wise. Script: SELECT TO_CHAR(TO_DATE(p.creation_date,’DD-MON-RRRR’), ‘Q’)AS MY_QTR ,TO_CHAR(P.CREATION_DATE,’RRRR’) POYear ,P.SEGMENT1 “PO Number” ,PL.LINE_NUM…
Read MoreIntroduction:-This query will provide complete Bill Code and GL String details from Back end Code:- SELECT MSIB.SEGMENT1 Catalog_Item, MSIB.INVENTORY_ITEM_STATUS_CODE STATUS, MSIB.DESCRIPTION item_description,msib.PRIMARY_UNIT_OF_MEASURE UOM,IGC.SEGMENT5 “Account Segment”, (IGC.SEGMENT1||’.’||IGC.SEGMENT2||’.’||IGC.SEGMENT3||’.’||IGC.SEGMENT4||’.’||IGC.SEGMENT5||’.’||IGC.SEGMENT6||’.’||IGC.SEGMENT7||’.’||IGC.SEGMENT8||’.’||IGC.SEGMENT9)”GLC”, gl_flexfields_pkg.get_concat_description (igc.chart_of_accounts_id, igc.code_combination_id )”Code…
Read MoreIntroduction: This query will provide the complete asset details in oracle apps. We can use this query to develop the custom fixed assets reports in oracle apps and can extract…
Read MoreIntroduction: A cross-validation rule defines whether a value of a particular segment can be combined with specific values of other segments.The same details we can fetch using the below code.…
Read MoreIntroduction: This script will provide all Requisitions Details from backend for without Po’s. Script: SELECT (SELECT NVL (short_code, NAME) FROM apps.hr_operating_units WHERE organization_id = r.org_id) org_code, r.segment1 “Req number”, r.authorization_status…
Read MoreIntroduction: Through the below script, we can create a new Request Group from back end. Script: BEGIN FND_PROGRAM.REQUEST_GROUP (REQUEST_GROUP => ‘System Administrator Reports’, APPLICATION => ‘CUSTOM’, CODE => ‘Run Collection…
Read MoreIntroduction: This Post illustrates the steps required to fetch the Inventory Cycle Count Report. Script to fetch the Inventory Cycle Count Details SELECT TO_CHAR (cce.creation_date, ‘DD-MON-YYYY’) creation_date, mp.organization_code org, cch.cycle_count_header_name…
Read MoreIntroduction: This Post illustrates the steps required to Process the Account alias issue Using API. Script DECLARE l_transaction_interface_id NUMBER; l_trx_type_id NUMBER; l_lot_control_code VARCHAR2 (500); l_serial_number_control_code VARCHAR2 (500); l_return_status VARCHAR2 (10);…
Read MoreIntroduction: This Post illustrates the steps required to get the Item Available to Transact Quantity in Inventory using API. Script FUNCTION xx_item_availble_to_transact ( p_inventory_item_id NUMBER, p_organization_id NUMBER, p_subinventory_code VARCHAR2, p_locater…
Read MoreIntroduction: This Post illustrates the steps required to update the Item Status using API. Script to Update the Item Status DECLARE p_item_number VARCHAR2 (300); p_organization_id NUMBER; p_inventory_item_id NUMBER; p_org_id NUMBER;…
Read More