SELECT "HM_BACKLOG_DETAILS"."ENTITY",
"HM_BACKLOG_DETAILS"."SUB_ENTITY",
"HM_BACKLOG_DETAILS"."CUSTOMER_NO",
"HM_BACKLOG_DETAILS"."CUSTOMER_LOC",
"HM_BACKLOG_DETAILS"."CUSTOMER_NAME",
"HM_BACKLOG_DETAILS"."SALESPERSON_NO",
"HM_BACKLOG_DETAILS"."SALESPERSON_NO_1",
"HM_BACKLOG_DETAILS"."SALESPERSON_NO_2",
"HM_BACKLOG_DETAILS"."SALESPERSON_NO_3",
"HM_BACKLOG_DETAILS"."PROJECT_NO",
"HM_BACKLOG_DETAILS"."ORDER_NO",
"HM_BACKLOG_DETAILS"."CUST_PO_NO",
"HM_BACKLOG_DETAILS"."LINE_NO",
"HM_BACKLOG_DETAILS"."ITEM_NO",
"HM_BACKLOG_DETAILS"."ITEM_DESCRIPTION",
"HM_OE_LINE_RECEIVING"."VENDOR_NO",
"AP_VENDOR_MASTER"."DES1",
"HM_OE_LINE_RECEIVING"."PO_NO",
"HM_OE_LINE_RECEIVING"."PO_LINE_NO",
"PR_EMP_MASTER"."DES1",
"OE_HDR"."LEAD_SOURCE_CODE",
"OE_LINE"."QTY_ORD",
"OE_LINE"."MOD_UNIT_PRICE",
"OE_LINE"."UNIT_COST",
"HM_OE_LINE_INVOICE"."QTY_INVOICED",
"HM_BACKLOG_DETAILS"."UNIT_COST",
"HM_OE_LINE_RECEIVING"."QTY_REC",
"HM_OE_LINE_SHIPPING"."QTY_SHIP",
"OE_HDR"."PROJECT_MANAGER",
"OE_HDR"."UD_FIELD_1",
"OE_HDR"."ORD_DATE",
"OE_LINE"."DATE_CREATED",
ABS(HM_BACKLOG_DETAILS.QTY_ORDERED),
NVL(ABS(HM_OE_LINE_INVOICE.QTY_INVOICED),0),
"NOTES"."NOTE_CODE",
"NOTES"."SUBJECT_DES1",
"NOTES"."NOTE"

FROM
((((((("KHAMELEON"."HM_BACKLOG_DETAILS" "HM_BACKLOG_DETAILS"
LEFT OUTER JOIN CT_NOTES "NOTES" ON "NOTES".CT_NOTES.ORD_NO = HM_BACKLOG_DETAILS.ORDER_NO AND "NOTES".NOTE_CODE = "OENOTE")
LEFT OUTER JOIN "KHAMELEON"."HM_OE_LINE_RECEIVING" "HM_OE_LINE_RECEIVING" ON "HM_BACKLOG_DETAILS"."ORDER_NO"="HM_OE_LINE_RECEIVING"."ORD_NO" AND "HM_BACKLOG_DETAILS"."LINE_NO"="HM_OE_LINE_RECEIVING"."LINE_NO")
LEFT OUTER JOIN "KHAMELEON"."HM_OE_LINE_SHIPPING" "HM_OE_LINE_SHIPPING" ON "HM_BACKLOG_DETAILS"."ORDER_NO"="HM_OE_LINE_SHIPPING"."ORD_NO" AND "HM_BACKLOG_DETAILS"."LINE_NO"="HM_OE_LINE_SHIPPING"."LINE_NO")
LEFT OUTER JOIN "KHAMELEON"."HM_OE_LINE_INVOICE" "HM_OE_LINE_INVOICE" ON "HM_BACKLOG_DETAILS"."ORDER_NO"="HM_OE_LINE_INVOICE"."ORD_NO" AND "HM_BACKLOG_DETAILS"."LINE_NO"="HM_OE_LINE_INVOICE"."LINE_NO")
     INNER JOIN "KHAMELEON"."OE_LINE" "OE_LINE" ON "HM_BACKLOG_DETAILS"."ORDER_NO"="OE_LINE"."ORD_NO" AND "HM_BACKLOG_DETAILS"."LINE_NO"="OE_LINE"."LINE_NO")
LEFT OUTER JOIN "KHAMELEON"."AP_VENDOR_MASTER" "AP_VENDOR_MASTER" ON "HM_OE_LINE_RECEIVING"."VENDOR_NO"="AP_VENDOR_MASTER"."VENDOR_NO")
     INNER JOIN "KHAMELEON"."OE_HDR" "OE_HDR" ON "OE_LINE"."ORD_NO"="OE_HDR"."ORD_NO")
LEFT OUTER JOIN "KHAMELEON"."PR_EMP_MASTER" "PR_EMP_MASTER" ON "OE_HDR"."PROJECT_MANAGER"="PR_EMP_MASTER"."EMP_NO"                     

WHERE ABS(HM_BACKLOG_DETAILS.QTY_ORDERED)>NVL(ABS(HM_OE_LINE_INVOICE.QTY_INVOICED),0)
     AND ABS (HM_BACKLOG_DETAILS.QTY_ORDERED) > NVL(ABS(HM_OE_LINE_INVOICE.QTY_INVOICED),0)                    
ORDER BY HM_BACKLOG_DETAILS."ORDER_DATE" ASC,      
           HM_BACKLOG_DETAILS."ORDER_NO" ASC,      
           HM_BACKLOG_DETAILS."LINE_NO" ASC    


HTH,
Jyothi