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.FV_CCR_DATA_LOAD_PKG dependencies on FV_CCR_VENDORS_S

Line 3397: SELECT FV_CCR_VENDORS_S.nextval ,'Y','R',l_status,

3393: ,GLOBAL_PARENT_STATE
3394: ,GLOBAL_PARENT_PHONE
3395:
3396: )
3397: SELECT FV_CCR_VENDORS_S.nextval ,'Y','R',l_status,
3398: DUNS ,
3399: PLUS_FOUR ,
3400: CAGE_CODE ,
3401: EXTRACT_CODE ,

Line 4209: SELECT FV_CCR_VENDORS_S.nextval ,'Y','R',l_status,

4205: ,GLOBAL_PARENT_COUNTRY
4206: ,GLOBAL_PARENT_STATE
4207: ,GLOBAL_PARENT_PHONE
4208: )
4209: SELECT FV_CCR_VENDORS_S.nextval ,'Y','R',l_status,
4210: DUNS ,
4211: PLUS_FOUR ,
4212: CAGE_CODE ,
4213: EXTRACT_CODE ,

Line 4584: update fv_ccr_vendors set extract_code=decode(l_file_type,'M','A','2')

4580: END IF;
4581: END IF;
4582:
4583: -- made this change a part of bug 3872249
4584: update fv_ccr_vendors set extract_code=decode(l_file_type,'M','A','2')
4585: where duns in ( select distinct duns from fv_ccr_process_gt)
4586: and extract_code ='N'
4587: and plus_four is null;
4588: