eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_SD_UTIL_PVT dependencies on OZF_SD_RES_PROD_INTF

Line 354: FROM OZF_SD_RES_PROD_INTF PRODINTF,

350: PRODLINES.REQUESTED_DISCOUNT_CURRENCY LINE_DISCOUNT_CUR,
351: PRODINTF.APPROVED_DISCOUNT_CURR INTF_CURR_CODE,
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

Line 378: FROM OZF_SD_RES_PROD_INTF PRODINTF,

374: PRODLINES.REQUESTED_DISCOUNT_CURRENCY LINE_DISCOUNT_CUR,
375: PRODINTF.APPROVED_DISCOUNT_CURR INTF_CURR_CODE,
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

Line 402: FROM OZF_SD_RES_PROD_INTF PRODINTF,

398: PRODLINES.REQUESTED_DISCOUNT_CURRENCY LINE_DISCOUNT_CUR,
399: PRODINTF.APPROVED_DISCOUNT_CURR INTF_CURR_CODE,
400: NVL(PRODINTF.APPROVED_DISCOUNT_VALUE,PRODLINES.REQUESTED_DISCOUNT_VALUE) INTF_APPROVED_DISCOUNT_VALUE,
401: NVL(PRODINTF.PROD_AUTHORIZED_QUANTITY,PRODLINES.MAX_QTY) INTF_APPROVED_QUANTITY
402: FROM OZF_SD_RES_PROD_INTF PRODINTF,
403: OZF_SD_REQUEST_LINES_ALL PRODLINES
404: WHERE NVL(PRODINTF.PROCESSED_FLAG,'N') <>'Y' and
405: PRODINTF.REQUEST_NUMBER=p_request_number
406: AND PRODLINES.REQUEST_HEADER_ID=request_header_id

Line 433: UPDATE OZF_SD_RES_PROD_INTF SET PROCESSED_FLAG='Y' WHERE REQUEST_NUMBER=p_request_number and PROCESSED_FLAG in('N',null) ;

429: UPDATE OZF_SD_RES_HEADER_INTF SET PROCESSED_FLAG='Y',ERROR_TXT=x_msg_data WHERE REQUEST_NUMBER=p_request_number and PROCESSED_FLAG in('N',null) ;
430:
431: UPDATE OZF_SD_RES_CUST_INTF SET PROCESSED_FLAG='Y' WHERE REQUEST_NUMBER=p_request_number and PROCESSED_FLAG in('N',null) ;
432:
433: UPDATE OZF_SD_RES_PROD_INTF SET PROCESSED_FLAG='Y' WHERE REQUEST_NUMBER=p_request_number and PROCESSED_FLAG in('N',null) ;
434:
435: UPDATE OZF_SD_RES_DIST_PRICES_INTF SET PROCESSED_FLAG='Y' WHERE REQUEST_NUMBER=p_request_number and PROCESSED_FLAG in('N',null) ;
436:
437: COMMIT ;

Line 458: SELECT REQUEST_LINE_ID FROM OZF_SD_RES_PROD_INTF

454: WHERE REQUEST_HEADER_ID=request_header_id
455: AND REQUEST_LINE_ID IN ( SELECT REQUEST_LINE_ID FROM OZF_SD_REQUEST_LINES_ALL
456: WHERE REQUEST_HEADER_ID=request_header_id
457: MINUS
458: SELECT REQUEST_LINE_ID FROM OZF_SD_RES_PROD_INTF
459: WHERE REQUEST_NUMBER=p_request_number
460: AND NVL(PROCESSED_FLAG,'N') <>'Y') ;
461:
462:

Line 476: UPDATE OZF_SD_RES_PROD_INTF SET ERROR_TXT = l_msg_data

472:
473:
474: l_msg_data := l_msg_data ||','|| 'Product context mismatch' ;
475:
476: UPDATE OZF_SD_RES_PROD_INTF SET ERROR_TXT = l_msg_data
477: WHERE REQUEST_LINE_ID=PROD_REC.INF_REQUEST_LINE_ID
478: AND NVL(PROCESSED_FLAG,'N') <>'Y';
479:
480: l_error_count := l_error_count +1 ;

Line 493: UPDATE OZF_SD_RES_PROD_INTF SET ERROR_TXT = l_msg_data

489:
490:
491: l_msg_data := l_msg_data ||','|| 'Product code mismatch' ;
492:
493: UPDATE OZF_SD_RES_PROD_INTF SET ERROR_TXT = l_msg_data
494: WHERE REQUEST_LINE_ID=PROD_REC.INF_REQUEST_LINE_ID
495: AND NVL(PROCESSED_FLAG,'N') <>'Y' ;
496:
497: l_error_count := l_error_count +1 ;

Line 510: UPDATE OZF_SD_RES_PROD_INTF SET ERROR_TXT = 'Discount type mismatch'

506:
507:
508: l_msg_data := l_msg_data ||','|| 'Discount type mismatch' ;
509:
510: UPDATE OZF_SD_RES_PROD_INTF SET ERROR_TXT = 'Discount type mismatch'
511: WHERE REQUEST_LINE_ID=PROD_REC.INF_REQUEST_LINE_ID
512: AND NVL(PROCESSED_FLAG,'N') <>'Y' ;
513:
514: l_error_count := l_error_count +1 ;

Line 539: UPDATE OZF_SD_RES_PROD_INTF SET ERROR_TXT = 'Currency code mismatch'

535:
536:
537: l_msg_data := l_msg_data ||','|| 'Currency code mismatch' ;
538:
539: UPDATE OZF_SD_RES_PROD_INTF SET ERROR_TXT = 'Currency code mismatch'
540: WHERE REQUEST_LINE_ID=PROD_REC.INF_REQUEST_LINE_ID
541: AND NVL(PROCESSED_FLAG,'N') <>'Y' ;
542:
543: l_error_count := l_error_count +1 ;

Line 613: UPDATE OZF_SD_RES_PROD_INTF SET PROCESSED_FLAG='Y' WHERE REQUEST_NUMBER=p_request_number and NVL(PROCESSED_FLAG,'N') <>'Y';

609: -- DO THE MASS UPDATE FOR THE INTERFACE TABLES
610:
611: UPDATE OZF_SD_RES_HEADER_INTF SET PROCESSED_FLAG='Y' WHERE REQUEST_NUMBER=p_request_number and NVL(PROCESSED_FLAG,'N') <>'Y';
612: UPDATE OZF_SD_RES_CUST_INTF SET PROCESSED_FLAG='Y' WHERE REQUEST_NUMBER=p_request_number and NVL(PROCESSED_FLAG,'N') <>'Y';
613: UPDATE OZF_SD_RES_PROD_INTF SET PROCESSED_FLAG='Y' WHERE REQUEST_NUMBER=p_request_number and NVL(PROCESSED_FLAG,'N') <>'Y';
614: UPDATE OZF_SD_RES_DIST_PRICES_INTF SET PROCESSED_FLAG='Y' WHERE REQUEST_NUMBER=p_request_number and NVL(PROCESSED_FLAG,'N') <>'Y';
615: COMMIT ;
616: EXCEPTION
617:

Line 623: UPDATE OZF_SD_RES_PROD_INTF SET PROCESSED_FLAG='Y',ERROR_TXT='Error' WHERE REQUEST_NUMBER=p_request_number and NVL(PROCESSED_FLAG,'N') <>'Y';

619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
620: -- DO THE MASS UPDATE FOR THE INTERFACE TABLES
621: UPDATE OZF_SD_RES_HEADER_INTF SET PROCESSED_FLAG='Y',ERROR_TXT='Error' WHERE REQUEST_NUMBER=p_request_number and NVL(PROCESSED_FLAG,'N') <>'Y';
622: UPDATE OZF_SD_RES_CUST_INTF SET PROCESSED_FLAG='Y',ERROR_TXT='Error' WHERE REQUEST_NUMBER=p_request_number and NVL(PROCESSED_FLAG,'N') <>'Y';
623: UPDATE OZF_SD_RES_PROD_INTF SET PROCESSED_FLAG='Y',ERROR_TXT='Error' WHERE REQUEST_NUMBER=p_request_number and NVL(PROCESSED_FLAG,'N') <>'Y';
624: UPDATE OZF_SD_RES_DIST_PRICES_INTF SET PROCESSED_FLAG='Y',ERROR_TXT='Error' WHERE REQUEST_NUMBER=p_request_number and NVL(PROCESSED_FLAG,'N') <>'Y';
625:
626: COMMIT ;
627: RETURN;

Line 720: UPDATE OZF_SD_RES_PROD_INTF SET PROCESSED_FLAG='S' WHERE REQUEST_NUMBER=p_request_number AND PROCESSED_FLAG='N' ;

716: BEGIN
717:
718: UPDATE OZF_SD_RES_HEADER_INTF SET PROCESSED_FLAG='S' WHERE REQUEST_NUMBER=p_request_number AND PROCESSED_FLAG='N' ;
719: UPDATE OZF_SD_RES_CUST_INTF SET PROCESSED_FLAG='S' WHERE REQUEST_NUMBER=p_request_number AND PROCESSED_FLAG='N' ;
720: UPDATE OZF_SD_RES_PROD_INTF SET PROCESSED_FLAG='S' WHERE REQUEST_NUMBER=p_request_number AND PROCESSED_FLAG='N' ;
721: UPDATE OZF_SD_RES_DIST_PRICES_INTF SET PROCESSED_FLAG='S' WHERE REQUEST_NUMBER=p_request_number AND PROCESSED_FLAG='N' ;
722: COMMIT ;
723:
724: END UPDATE_SD_REQ_STALE_DATA;