Sql Query To Extract The Move Order Issue ... - Oracle Application's Blog

skip to main | skip to sidebar Oracle Application's Blog

The purpose of this blog , is to do Knowledge sharing with my Followers through my own Experiences. Contact us for Oracle Applications Job Support , Project Support and any other freelancing work.

• About us
• Fusion E-Books
• Workflows
• OAF
• Interfaces
• Scripts
• XML
• Fusion Technical
• Fusion Financial
• EBS

Thursday, 24 March 2022

Sql Query to Extract the Move Order Issue/Move Order data in Oracle Fusion

Sql Query to Extract the Move Order Issue/Move Order data in Oracle Fusion

Hi Friends , we are going to discuss about the sql query which helps to extract the move order/move order issue in sql query. This sql query which helps you to extract the complete move order details in oracle fusion. Using this query , we can develop the Oracle Fusion BIP report for move order report. Move order reports belongs to Inventory module. This is one of the most important report in oracle fusion to extract the complete details about the move order created in oracle fusion system. The good part is , using this query we can find the source and destination sub inventory. Please find below the complete details about Sql Query to Extract the Move Order Issue/Move Order data in Oracle Fusion.

Important Tables to develop the Sql Query to Extract the Move Order Issue/Move Order data in Oracle Fusion

1.egp_system_items_vl2.inv_units_of_measure_vl3.INV_TRANSFER_ORDER_LINES4.INV_TRANSFER_ORDER_DISTRIBS5.INV_TRANSFER_ORDER_HEADERS

Detail SQL to Extract the Move Order Issue/Move Order data in Oracle Fusion

Here below is the sql query to extract the develop the move order issue/transfer report in oracle fusion.SELECT ITH.HEADER_NUMBER,ITL.SUPPLY_ORDER_REFERENCE_NUMBER,ITL.LINE_NUMBER,ESI.ITEM_NUMBER,ESI.DESCRIPTION,UOM.UNIT_OF_MEASURE,PRH.CREATED_BY,hauft.NAME,hauft12.NAME source_name,hauft22.NAME dest_name,ITL.SHIPPED_QTY,ITL.UNIT_PRICE,ITL.SHIPPED_QTY * ITL.UNIT_PRICE AS Amount,ITL.STATUS_LOOKUP,ITL.LAST_UPDATE_DATEfromINV_TRANSFER_ORDER_HEADERS ITH ,INV_TRANSFER_ORDER_LINES ITL ,INV_TRANSFER_ORDER_DISTRIBS ITD,egp_system_items_vl ESI,inv_units_of_measure_vl UOM,POR_REQUISITION_HEADERS_ALL PRH,per_users PU,per_all_assignments_m PASM,HR_ORG_UNIT_CLASSIFICATIONS_F houcf, HR_ALL_ORGANIZATION_UNITS_F haouf, HR_ORGANIZATION_UNITS_F_TL hauft,HR_ORGANIZATION_UNITS_F_TL hauft12,HR_ORGANIZATION_UNITS_F_TL hauft22whereITH.HEADER_ID = ITL.HEADER_IDAND ITL.INVENTORY_ITEM_ID = ESI.INVENTORY_ITEM_IDAND QTY_UOM_CODE=UOM.UOM_CODEAND PRH.REQUISITION_NUMBER = ITL.SUPPLY_ORDER_REFERENCE_NUMBERAND PU.USERNAME = PRH.CREATED_BYAND PASM.PERSON_ID = PU.PERSON_IDAND haouf.ORGANIZATION_ID = houcf.ORGANIZATION_ID AND haouf.ORGANIZATION_ID = hauft.ORGANIZATION_ID and hauft.organization_id = PASM.ORGANIZATION_ID AND hauft.LANGUAGE= 'US'and sysdate between PASM.effective_start_date and PASM.effective_end_dateand ITL.STATUS_LOOKUP = 'CLOSED'and itl.SOURCE_ORGANIZATION_ID=hauft12.organization_idand itl.destination_ORGANIZATION_ID=hauft22.organization_idorder by ITH.HEADER_NUMBER,ITL.LINE_NUMBER at 23:15 Labels: Sql Query to Extract the Move Order Issue/Move Order data in Oracle Fusion

0 comments:

Post a Comment

Newer Post Older Post Home

Contact us for any Collaboration, Project Support & On Job Support Work

Name Email * Message *

Know More About Us

• Products & Offerings

Learn Fusion Financials' (Online Book)

Click To Download

Oracle Fusion Self Paced Trainings in Discounted Prices

Click to know more

Buy Oracle Cloud Instance Access (Click to Know More)

Oracle Fusion/EBS Interview's Question Answer Series

• Top 33 Oracle Fusion Order Management Interview Questions
• TOP 31 Oracle Fusion SCM Cloud Interview Questions
• TOP 21 Oracle Fusion HCM Interview Questions
• Complete Tax Setups in Oracle Fusion
• Top 50 oracle reports interview questions
• 33 Most Important Oracle Fusion fixed assets interview questions
• TOP 33 Most Important Oracle Apps Technical Interview Questions
• 25 Most Important Oracle receivable interview questions
• 21 Most Important Oracle r12 Payables Interview Questions
• TOP 20 general ledger interview questions in oracle apps r12
• TOP 23 Most Important Oracle Fusion Interview Questions
• TOP 23 Most Important oaf interview questions

Online Oracle Courses (Free of Cost)

• Complete Tax Setups in Oracle Fusion
• Learn Tax Implementation in Oracle Fusion
• Learn P2P Cycle in Oracle Fusion
• Learn Oracle Reports XML Tutorial
• Learn Oracle Fusion Custom Roles Tutorial
• Learn Oracle Fusion Technical Online
• Learn Oracle Fusion/cloud Financials Online
• Learn Oracle Cloud BPM Online
• Learn Complete OAF Step by Step Online
• Learn Oracle Workflow Builder Online

Online Fusion Application Composer/Customization Book

Online Fusion Application Composer/Customization Book Click To Know More

Oracle Fusion Technical Book

Oracle Fusion Technical Book

Oracle Fusion Web Services(REST& SOAP API's) / Integration Book

Contact Me

[email protected]

Most Viewed Posts

Report Bursting in oracle fusion AR to GL reconciliation in oracle apps r12 Set the override email address in Oracle Fusion How to Create PO and Receiving Inquiry(View Only) Role in Oracle Fusion How to create a new Oracle apps Data base source to Design the BIP reports How to add hyperlink in the email body using Bursting in Oracle Cloud BIP reports What is Rapid Implementation in Oracle Cloud : Rapid Implementation Data Upload Process in Oracle Fusion Drill Down OTBI reports to Navigate Directly in to Oracle Cloud Payment Page How to create vacation rules in Oracle cloud TOP 30 Most Important OAF Interview Questions