Hi Everyone. i am gettin the above error when running the query only in Oracle 8.1 but in Oracle 9 its working fine. can any one help me out..
SELECT
TRUNC(ACD.CONVERSION_END_TIME) AS "Date",
ACB.PART_NBR AS "Part#",
ACB.PART_DESCRIPTION AS "Description",
(SELECT
COUNT(1)
FROM
ABANDON_CONVERSION_BOM ACB1
WHERE
TRIM(ACB1.PART_STATUS) = L_PARTS_ADDED_TO_INV AND TRIM(ACB.PART_NBR) = TRIM(ACB1.PART_NBR)
group by
TRIM(ACB1.PART_STATUS) AS "Added_to_Inventory",
(SELECT
COUNT(1)
FROM
ABANDON_CONVERSION_BOM ACB1
WHERE TRIM(ACB1.PART_STATUS) = L_PARTS_ADDED_TO_UNIT AND TRIM(ACB.PART_NBR) = TRIM(ACB1.PART_NBR)
group by TRIM(ACB1.PART_STATUS)) AS "Added_to_Abandon",
(SELECT COUNT(1) FROM ABANDON_CONVERSION_BOM ACB1 WHERE TRIM(ACB1.PART_STATUS) = L_PARTS_SCRAPPED AND TRIM(ACB.PART_NBR) = TRIM(ACB1.PART_NBR) group by TRIM(ACB1.PART_STATUS)) AS "Parts_Scrapped"
FROM
IIBKQ.ABANDON_CONVERSION_DETAIL ACD,
IIBKQ.ABANDON_CONVERSION_BOM ACB
WHERE
TRUNC(ACD.CONVERSION_END_TIME) BETWEEN L_START_DATE AND L_END_DATE
AND
TRIM(ACD.LAYIN_SERIAL_NO) = TRIM(ACB.LAYIN_SERIAL_NO)
ORDER BY
ACD.CONVERSION_END_TIME;