charges based on debrief lines
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,
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,
0