View: IGCFV_CC_ROUTING_CONTROLS

Product:	IGC - Contract Commitment
Description:
Implementation/DBA Data:	APPS.IGCFV_CC_ROUTING_CONTROLS

View Text

SELECT '_LA:CC_CAN_PRPR_APPRV_FLAG:FND_LOOKUPS:YES_NO:MEANING' "_LA:APPROVAL_ALLOWED_FLAG"
, '_LA:CC_CAN_PRPR_ENCMBR_FLAG:FND_LOOKUPS:YES_NO:MEANING' "_LA:PREPARER_ENCM_ALLOW_FLAG"
, ORU.NAME ORGANIZATION_NAME
, IGC_CCRC.ORG_ID ORGANIZATION_ID
, IGC_CCRC.CC_TYPE TYPE
, IGC_CCRC.CC_STATE STATE
, IGC_CCRC.LAST_UPDATED_BY LAST_UPDATED_BY
, IGC_CCRC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IGC_CCRC.CREATION_DATE CREATION_DATE
, IGC_CCRC.CREATED_BY CREATED_BY
FROM IGC_CC_ROUTING_CTRLS IGC_CCRC
, HR_ALL_ORGANIZATION_UNITS ORU
WHERE IGC_CCRC.ORG_ID=ORU.ORGANIZATION_ID
AND '_SEC:IGC_CCRC.ORG_ID' IS NOT NULL WITH READ ONLY

Columns