PAY Database Triggers Status
Description
Categories: BI Publisher
Application: Payroll
Source: Database Triggers Status Report (XML)
Short Name: PAYRPHTS_XML
DB package: PAY_PAYRPHTS_XMLP_PKG
Source: Database Triggers Status Report (XML)
Short Name: PAYRPHTS_XML
DB package: PAY_PAYRPHTS_XMLP_PKG
Run
PAY Database Triggers Status and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT * FROM hr_trigger_status_v WHERE :P_Detail = 'N' AND status = :P_Status UNION ALL SELECT * FROM hr_trigger_status_v WHERE :P_Detail = 'Y' AND status = :P_Status order by 1,5,11,2,3,7,9,6,13,8,10,12 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Trigger Status |
|
LOV Oracle | |
Display Trigger Body |
|
LOV Oracle |