SELECT oola.line_number, oola.line_id, ooha.orig_sys_document_ref , ooha.order_source_id, ooha.order_number sale_order_no, trunc(ooha.ordered_date) sale_order_date, hp_ship.party_name customer_name, –hl_ship.address1, …
Read Moreselect ohd.item, ohd.item_desc, ohd.org_code, ohd.org_name, ohd.sub_inventory, ohd.locator, msn.serial_number, ohd.item_status, ohd.uom, NVL2(msn.serial_number,1,ohd.total_onhand_qty) onhand_qty, ohd.total_onhand_qty, ohd.total_reserve_qty, ohd.total_transact_qty, mmt.transaction_date stock_in_date, mst.transaction_source_type_name stock_in_type from (SELECT msi.inventory_item_id , (select max(mq.create_transaction_id) from mtl_onhand_quantities mq…
Read MoreThis article describes Report Manager functionality in Oracle R12 which allows users to primarily publish and store Financial Statements/reports that are written using Financial Statement Generator (FSGs). Note that Report…
Read MoreWhat are Cross Validation Rules Cross Validation Rules are used to restrict the combination between the segments of a particular Chart of Accounts. As per our Example, we have the…
Read MoreHow to Update the Web Adi Template: This document target is ADI template update required Purpose As per the business requirement user had requested to add the some fields to…
Read More1 Define a Chart of Accounts Instance Please find the below steps to define a Chart of Accounts Step1: Login as Application User Step2: you will be in home page as below…
Read MorePlease find the below steps to define a Chart of Accounts Step1: Login as Application User Step2: you will be in home page as below Step3: we need to navigate…
Read MorePlease find the below steps for creating the Legal Entity Step1: Login as Application User Step2: you will be in home page as below Step3: we need to navigate to…
Read MorePlease find the below steps to define a Bank,Bank Branch and Bank Account Step1: Login as Application User Step2: you will be in home page as below Step3: we need…
Read MorePlease find the below setups to setup the default JE Category Step1: Login as Application User Step2: you will be in home page as below Step3: we need to navigate…
Read More