DBA Data[Home] [Help]

APPS.OZF_SD_UTIL_PVT dependencies on ENI_PROD_DEN_HRCHY_PARENTS_V

Line 380: ENI_PROD_DEN_HRCHY_PARENTS_V D

376: NVL(PRODINTF.APPROVED_DISCOUNT_VALUE,PRODLINES.REQUESTED_DISCOUNT_VALUE) INTF_APPROVED_DISCOUNT_VALUE,
377: NVL(PRODINTF.PROD_AUTHORIZED_QUANTITY,PRODLINES.MAX_QTY) INTF_APPROVED_QUANTITY
378: FROM OZF_SD_RES_PROD_INTF PRODINTF,
379: OZF_SD_REQUEST_LINES_ALL PRODLINES,
380: ENI_PROD_DEN_HRCHY_PARENTS_V D
381: WHERE NVL(PRODINTF.PROCESSED_FLAG,'N') <>'Y' and
382: PRODINTF.REQUEST_NUMBER=p_request_number
383: AND PRODLINES.REQUEST_HEADER_ID=request_header_id
384: AND PRODINTF.REQUEST_LINE_ID = PRODLINES.REQUEST_LINE_ID