View: ASO_APPROVAL_RULES_ALL_V

Product:	ASO - Order Capture
Description:
Implementation/DBA Data:	APPS.ASO_APPROVAL_RULES_ALL_V

View Text

SELECT AAR.CREATION_DATE
, AAR.CREATED_BY
, AAR.LAST_UPDATE_DATE
, AAR.LAST_UPDATED_BY
, AAR.LAST_UPDATE_LOGIN
, AAR.OBJECT_APPROVAL_ID
, AAR.OAM_RULE_ID
, AMR.DESCRIPTION
, AMA.DESCRIPTION
FROM ASO_APR_RULES AAR
, AME_RULES AMR
, AME_ACTIONS AMA
WHERE AAR.OAM_RULE_ID = AMR.RULE_ID
AND AMR.ACTION_ID = AMA.ACTION_ID
AND (AMR.END_DATE IS NULL OR SYSDATE < AMR.END_DATE)
AND (AMA.END_DATE IS NULL OR SYSDATE < AMA.END_DATE)

Columns