Field Service - EBS (MOSC)

MOSC Banner

charges based on debrief lines

edited Nov 15, 2013 1:50AM in Field Service - EBS (MOSC) 9 commentsAnswered ✓
Hi,
i want the charges to be displayed based on the debrief_line_id for each task. i am using the below query which returns duplicate data because some join is missing. So is there any way to make the below query work
as required? Thanks in advance..

SELECT DISTINCT dl.DEBRIEF_HEADER_ID,
                dl.DEBRIEF_LINE_ID,
                dh.debrief_number,
                TXN_TYPE AS Service_Code,
                (select distinct mb.segment1
                   from MTL_SYSTEM_ITEMS_B mb
                  where mb.inventory_item_id = DL.INVENTORY_ITEM_ID) item,
                LABOR_START_DATE,
                LABOR_END_DATE,
                SERVICE_DATE,
                ctv.resource_name,
                dl.QUANTITY,
                UOM_CODE,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center