DBA Data[Home] [Help]

APPS.OZF_SD_UTIL_PVT dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 261: mtl_system_items_b_kfv PROD

257: NVL(PRODINTF.APPROVED_DISCOUNT_VALUE,PRODLINES.REQUESTED_DISCOUNT_VALUE) INTF_APPROVED_DISCOUNT_VALUE,
258: NVL(PRODINTF.PROD_AUTHORIZED_QUANTITY,PRODLINES.MAX_QTY) INTF_APPROVED_QUANTITY
259: FROM OZF_SD_RES_PROD_INTF PRODINTF,
260: OZF_SD_REQUEST_LINES_ALL PRODLINES,
261: mtl_system_items_b_kfv PROD
262: where NVL(PRODINTF.PROCESSED_FLAG,'N') <>'Y' and
263: PRODINTF.REQUEST_NUMBER=p_request_number
264: AND PRODLINES.REQUEST_HEADER_ID=request_header_id
265: AND PRODINTF.REQUEST_LINE_ID = PRODLINES.REQUEST_LINE_ID