VIEW: APPS.PA_PM_PRODUCT_CONTROL_RULES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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