DBA Data[Home] [Help]

APPS.OZF_SD_UTIL_PVT dependencies on ENI_PROD_DEN_HRCHY_PARENTS_V

Line 285: ENI_PROD_DEN_HRCHY_PARENTS_V D

281: NVL(PRODINTF.APPROVED_DISCOUNT_VALUE,PRODLINES.REQUESTED_DISCOUNT_VALUE) INTF_APPROVED_DISCOUNT_VALUE,
282: NVL(PRODINTF.PROD_AUTHORIZED_QUANTITY,PRODLINES.MAX_QTY) INTF_APPROVED_QUANTITY
283: FROM OZF_SD_RES_PROD_INTF PRODINTF,
284: OZF_SD_REQUEST_LINES_ALL PRODLINES,
285: ENI_PROD_DEN_HRCHY_PARENTS_V D
286: WHERE NVL(PRODINTF.PROCESSED_FLAG,'N') <>'Y' and
287: PRODINTF.REQUEST_NUMBER=p_request_number
288: AND PRODLINES.REQUEST_HEADER_ID=request_header_id
289: AND PRODINTF.REQUEST_LINE_ID = PRODLINES.REQUEST_LINE_ID