[Home] [Help]
View: APBV_POL_VIOLATIONS
Product: | AP - Payables |
Description: | Based on AP_POL_VIOLATIONS_ALL, this business view contains expense policy violation data. |
Implementation/DBA Data: |
APPS.APBV_POL_VIOLATIONS
|
View Text
SELECT APVA.REPORT_HEADER_ID
, APVA.DISTRIBUTION_LINE_NUMBER
, APVA.VIOLATION_NUMBER
, APVA.VIOLATION_TYPE
, APVA.ALLOWABLE_AMOUNT
, APVA.FUNC_CURRENCY_ALLOWABLE_AMT
, APVA.ORG_ID
, APVA.CREATED_BY
, APVA.CREATION_DATE
, APVA.LAST_UPDATED_BY
, APVA.LAST_UPDATE_DATE
, APVA.EXCEEDED_AMOUNT
, APVA.VIOLATION_DATE
FROM AP_POL_VIOLATIONS_ALL APVA
WHERE '_SEC:APVA.ORG_ID' IS NOT NULL WITH READ ONLY
Columns
Name |
REPORT_HEADER_ID |
DISTRIBUTION_LINE_NUMBER |
VIOLATION_NUMBER |
VIOLATION_TYPE |
ALLOWABLE_AMOUNT |
FUNC_CURRENCY_ALLOWABLE_AMT |
ORG_ID |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
EXCEEDED_AMOUNT |
VIOLATION_DATE |