DBA Data[Home] [Help]

APPS.EAM_WORKORDERREP_PVT dependencies on EAM_DIRECT_ITEM_RECS_V

Line 231: FROM EAM_DIRECT_ITEM_RECS_V edrv

227: DECODE(edrv.order_type_lookup_code,'FIXED PRICE',NVL(edrv.po_amount_ordered,0),NVL(edrv.po_quantity_ordered,0)) as "POQUANTITYORDERED",
228: DECODE(edrv.order_type_lookup_code,'FIXED PRICE',NVL(edrv.amount_delivered,0),NVL(edrv.quantity_received, 0)) as "QUANTITYRECEIVED",
229: edrv.uom_code as "UOM",
230: fnd_date.date_to_displayDT(Convert_to_client_time(edrv.date_required)) as "DATEREQUIRED")) DirectMaterial
231: FROM EAM_DIRECT_ITEM_RECS_V edrv
232: WHERE edrv.wip_entity_id = p_wip_id;
233:
234:
235: -- Cursor for Work Order Short Attachments