error ROW_NUMBER() in form [message #622313] |
Mon, 25 August 2014 02:13 |
|
hahaie
Messages: 194 Registered: May 2014
|
Senior Member |
|
|
my form have this code
FOR I IN (
SELECT ROW_NUMBER() OVER (ORDER BY IDE_AREA) R_NUM,
IDE_AREA
FROM PMS_AREAS
WHERE PMS_AREAS.ARSTU_IDE_PK_ARSTU LIKE
(APP_HSM_HFL_PKG.GET_ARSTU_HOT_FINISH_LINE_FUN
(APP_HSM_HFL_PKG.GET_COMPANY_FROM_AREA_FUN(:CONTROL_SEARCH.ITEM_AREA_ID))||'%COIL-STK%'
)
AND PMS_AREAS.FLG_PROD_MAIN_PARK_AREA = 1
AND NVL(PMS_AREAS.FLG_PROD_PARK_POS_AREA,0)=0
ORDER BY 2)
LOOP
but this have error?
(More codes not listed)
|
|
|
|
|
|
|
|
|
|
|
|
|