[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT DECODE(pfolderName,
'Account:Account FK' , 'Accounting Flexfield Dimension:Account' ,
'Company: Company FK' , 'Accounting Flexfield Dimension:Company' ,
'Consolidated Revenue' , 'Consolidated Revenue Fact' ,
'Cost Center:Cost Center FK' , 'Accounting Flexfield Dimension:Cost Center' ,
'External Reporting:External Reporting FK' , 'Accounting Flexfield Dimension:External Reporting' ,
'Line of Business:Line of Business FK' , 'Accounting Flexfield Dimension:Line of Business' ,
'Sub-Account:Sub-Account FK' , 'Accounting Flexfield Dimension:Sub-Account' ,
'Trading Partner Dimension:Bill To Customer' , 'Bill To Customer' ,
'Trading Partner Dimension:Ship To Customer' , 'Ship To Customer' ,
'Trading Partner Dimension:Sold To Customer' , 'Sold To Customer' ,
'Trading Partner Dimension:End User Address' , 'End User Address' ,
'Trading Partner Dimension:Reseller Customer' , 'Reseller Customer' ,
'Trading Partner Dimension:End User Customer' , 'End User Customer' ,
'Vertical:Vertical FK' , 'Accounting Flexfield Dimension:Vertical' ,
pFolderName)
INTO RETURN_VALUE
FROM DUAL;
pColumnNameIn IN ('HHLD_POSTABLE_FLAG','HHLD_USER_RELEASEABLE_FLAG','HHLD_USER_UPDATEABLE_FLAG'))
OR
(pTableNameIn = 'EDW_INV_TYPE_M' AND
pColumnNameIn IN ('IVTY_DESCRIPTION'))
OR
(pTableNameIn = 'EDW_AP_PAYMENT_M' AND
pColumnNameIn IN ('PCHK_STATUS_LOOKUP_CODE'))
OR
(pTableNameIn = 'EDW_RELEASE_M' AND
pColumnNameIn IN ('RLSE_USER_RELEASEABLE_FLAG','RLSE_POSTABLE_FLAG'))
/*
OR
(pTableNameIn = 'EDW_INSTANCE_M' AND
pColumnNameIn IN ('INST_DESCRIPTION','INST_NAME'))
*/
OR
(pTableNameIn = 'EDW_TRD_PARTNER_M' AND
SUBSTRB(pColumnNameIn,1,4) IN ('PTP1','PTP2','PTP3') AND
pColumnNameIn NOT LIKE 'PTP__NAME')
THEN RETURN_VALUE := 1;
'DNMR_DOMESTIC_ULT_STATE_PROV','LAST_UPDATE_DATE','GLBL_INSTANCE','GLBL_TELEPHONE','GLBL_COUNTRY','GLBL_POSTAL_CODE',
'DNMR_EXPORT_FLAG','DNMR_CEO_TITLE','DNMR_CEO_NAME','DNMR_BUSINESS_MOVED_IND','DNMR_WOMAN_OWNED_FLAG','DNMR_SDB_ENTRANCE_DATE',
'DNMR_SDB_EXIT_DATE','DNMR_SMALL_BUSINESS_FLAG','DNMR_MINORITY_OWNED_TYPE','DNMR_MINORITY_OWNED_FLAG','DNMR_DISADVANTAGED_FLAG',
'DNMR_CONG_DIST_CODE3','DNMR_CONG_DIST_CODE2','DNMR_CONG_DIST_CODE1','DNMR_TELEPHONE','DNMR_COUNTRY','DNMR_STATE_PROV',
'DNMR_ADDRESS','DNMR_COMPANY_NAME','HQTR_TELEPHONE','HQTR_POSTAL_CODE','HQTR_DUNS_NUMBER','HQTR_ADDRESS'))
OR
*/
(pTableNameIn = 'EDW_GEOGRAPHY_M' AND
pColumnNameIn IN ('ARE2_NAME','REGN_NAME','SREG_NAME'))
OR
(pTableNameIn = 'EDW_ITEMS_M' AND
pColumnNameIn IN ('CCIT_CATEGORY_NAME','CCIT_DESCRIPTION',
'CCAT_CATEGORY_NAME','CCAT_DESCRIPTION',
'ECIT_CATEGORY_NAME','ECIT_DESCRIPTION',
'ECAT_CATEGORY_NAME','ECAT_DESCRIPTION',
'PLIN_NAME','PLIN_DESCRIPTION','PLIN_ENABLE_FLAG',
'ICIT_CATEGORY_NAME','ICIT_DESCRIPTION',
'ICAT_CATEGORY_NAME','ICAT_DESCRIPTION',
'IREV_LEVEL_NAME',
'ITEM_ONE_TIME_FLAG',
'MCIT_CATEGORY_NAME','MCIT_DESCRIPTION',
'MCAT_CATEGORY_NAME','MCAT_DESCRIPTION',
'OCIT_CATEGORY_NAME','OCIT_DESCRIPTION',
'OCAT_CATEGORY_NAME','OCAT_DESCRIPTION',
'LCIT_CATEGORY_NAME','LCIT_DESCRIPTION',
'LCAT_CATEGORY_NAME','LCAT_DESCRIPTION',
'PCIT_CATEGORY_NAME','PCIT_DESCRIPTION',
'PCAT_CATEGORY_NAME','PCAT_DESCRIPTION',
'IORG_EFFECTIVITY_CONTROL','IORG_EXPRS_DELIVERY',
'IORG_HAZARD_CLASS_ID','IORG_INSP_REQUIRED',
'IORG_LOCATOR_CONTROL','IORG_LOT_CONTROL',
'IORG_MRP_PLN_METHOD','IORG_MAKE_OR_BUY_FLAG',
'IORG_PRC_TOLERANCE_PCT','IORG_SERIAL_CONTROL',
'IORG_SHELF_LIFE_CODE','IORG_SHELF_LIFE_DAYS',
'IORG_SUBSTITUTE_RCPT','IORG_UN_NUMBER_ID',
'IORG_UNORDERED_RCPT',
'PCTG_DESCRIPTION','PCTG_ENABLED_FLAG','PCTG_NAME',
'PRDF_DESCRIPTION','PRDF_NAME','PRDF_PRODUCT_FAMILY',
'PGRP_DESCRIPTION','PGRP_ENABLED_FLAG','PGRP_NAME',
'SCIT_CATEGORY_NAME','SCIT_DESCRIPTION',
'SCAT_CATEGORY_NAME','SCAT_DESCRIPTION',
'CI11_DESCRIPTION','CI11_CATEGORY_NAME',
'CI12_DESCRIPTION','CI12_CATEGORY_NAME',
'CI13_DESCRIPTION','CI13_CATEGORY_NAME',
'CI14_DESCRIPTION','CI14_CATEGORY_NAME',
'CI15_DESCRIPTION','CI15_CATEGORY_NAME',
'CI16_DESCRIPTION','CI16_CATEGORY_NAME',
'CI21_DESCRIPTION','CI21_CATEGORY_NAME',
'CI22_DESCRIPTION','CI22_CATEGORY_NAME',
'CI23_DESCRIPTION','CI23_CATEGORY_NAME',
'CI24_DESCRIPTION','CI24_CATEGORY_NAME',
'CI25_DESCRIPTION','CI25_CATEGORY_NAME',
'CI26_DESCRIPTION','CI26_CATEGORY_NAME',
'CI31_DESCRIPTION','CI31_CATEGORY_NAME',
'CI310_DESCRIPTION','CI310_CATEGORY_NAME',
'CI32_DESCRIPTION','CI32_CATEGORY_NAME',
'CI33_DESCRIPTION','CI33_CATEGORY_NAME',
'CI34_DESCRIPTION','CI34_CATEGORY_NAME',
'CI35_DESCRIPTION','CI35_CATEGORY_NAME',
'CI36_DESCRIPTION','CI36_CATEGORY_NAME',
'CI37_DESCRIPTION','CI37_CATEGORY_NAME',
'CI38_DESCRIPTION','CI38_CATEGORY_NAME',
'CI39_DESCRIPTION','CI39_CATEGORY_NAME',
'CO11_DESCRIPTION','CO11_CATEGORY_NAME',
'CO12_DESCRIPTION','CO12_CATEGORY_NAME',
'CO13_DESCRIPTION','CO13_CATEGORY_NAME',
'CO14_DESCRIPTION','CO14_CATEGORY_NAME',
'CO15_DESCRIPTION','CO15_CATEGORY_NAME',
'CO16_DESCRIPTION','CO16_CATEGORY_NAME'))
OR
(pTableNameIn = 'EDW_ORGANIZATION_M' AND
pColumnNameIn IN (
'BGRP_DATE_TO', 'BGRP_INT_EXT_FLAG','BGRP_ORG_TYPE', 'BGRP_PRIMARY_CST_MTHD' ,'BGRP_DATE_FROM',
'ORGA_DATE_TO','ORGA_ORG_INT_EXT_FLAG', 'ORGA_ORG_PRIM_CST_MTHD' ,'ORGA_DATE_FROM',
'LGET_DATE_TO', 'LGET_INT_EXT_FLAG','LGET_ORG_TYPE', 'LGET_PRIMARY_CST_MTHD' ,'LGET_DATE_FROM','LGET_SET_OF_BOOKS',
'OPER_DATE_TO', 'OPER_INT_EXT_FLAG','OPER_ORG_TYPE', 'OPER_PRIMARY_CST_MTHD' ,'OPER_DATE_FROM'))
/* In OWB
OR
(pTableNameIn = 'EDW_GL_BOOK_M' AND
pColumnNameIn IN ('FABK_BOOK_TYPE_NAME','FABK_CURRENCY_CODE',
'FABK_DEPRE_CALANDAR','FABK_FA_BOOK','FABK_INSTANCE',
'FABK_NAME','FABK_PRORATE_CALENDAR'))
*/
OR
(pTableNameIn = 'EDW_MTL_UOM_M' AND
pColumnNameIn IN ('CREATION_DATE','LAST_UPDATE_DATE'))
THEN RETURN_VALUE := 1;