Product: | PA - Projects |
---|---|
Description: | 10Sc Only |
Implementation/DBA Data: | APPS.PA_PM_PRODUCT_CONTROL_RULES_V |
SELECT PR.ROWID
, PR.CONTROL_RULE_ID
, PCA.ACTION
, PCA.DESCRIPTION
, PCA.FIELD_VALUE_ALLOWED_FLAG
, PR.PM_PRODUCT_CODE
, PAL.MEANING
, PR.FIELD_VALUE_CODE
, PR.START_DATE_ACTIVE
, PR.END_DATE_ACTIVE
, PR.CREATION_DATE
, PR.LAST_UPDATED_BY
, PR.CREATED_BY
, PR.LAST_UPDATE_DATE
, PR.LAST_UPDATE_LOGIN
FROM PA_PM_CONTROL_ACTIONS PCA
, PA_PM_PRODUCT_CONTROL_RULES PR
, PA_LOOKUPS PAL
WHERE PCA.CONTROL_RULE_ID = PR.CONTROL_RULE_ID
AND PAL.LOOKUP_TYPE = 'PM_PRODUCT_CODE'
AND PR.PM_PRODUCT_CODE = PAL.LOOKUP_CODE