Can anyone help me tune the query which i have wriiten to fetch the goods received not invoiced
Summary:
Can anyone help me tune the query which i have wriiten to fetch the goods received not invoiced since its having performance issue.
Content (required):
select
pha.segment1,
PLA.LINE_NUM po_line,
RCV.RECEIPT_NUM,
RCVL.LINE_NUM receipt_line,
AIA.INVOICE_NUM,
esi.item_number,
nvl(pla.quantity,0) order_quantity,
pla.uom_code,
pla.item_description,
pha.currency_code,
nvl(pla.unit_price,0) po_unit_price,
nvl(pll.QUANTITY_RECEIVED,0) QUANTITY_RECEIVED,
nvl(ail.QUANTITY_INVOICED,0) QUANTITY_INVOICED,
nvl(nvl(pla.quantity,0) - nvl(ail.QUANTITY_INVOICED,0),0) total_uninvoiced_quantity,
nvl(((nvl(nvl(pla.quantity,0) - nvl(ail.QUANTITY_INVOICED,0),0)) * nvl(pla.unit_price,0)),0) total_uninvoiced_value,
Tagged:
0