DBA Data[Home] [Help]

APPS.OZF_SD_UTIL_PVT dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 356: mtl_system_items_b_kfv PROD

352: NVL(PRODINTF.APPROVED_DISCOUNT_VALUE,PRODLINES.REQUESTED_DISCOUNT_VALUE) INTF_APPROVED_DISCOUNT_VALUE,
353: NVL(PRODINTF.PROD_AUTHORIZED_QUANTITY,PRODLINES.MAX_QTY) INTF_APPROVED_QUANTITY
354: FROM OZF_SD_RES_PROD_INTF PRODINTF,
355: OZF_SD_REQUEST_LINES_ALL PRODLINES,
356: mtl_system_items_b_kfv PROD
357: where NVL(PRODINTF.PROCESSED_FLAG,'N') <>'Y' and
358: PRODINTF.REQUEST_NUMBER=p_request_number
359: AND PRODLINES.REQUEST_HEADER_ID=request_header_id
360: AND PRODINTF.REQUEST_LINE_ID = PRODLINES.REQUEST_LINE_ID