HXT Shift Diff. Pol. Table Listing

Description
Categories: BI Publisher
Application: Time and Labor
Source: Shift Diff. Pol. Table Listing (XML)
Short Name: HXT956C_XML
DB package: HXT_HXT956C_XMLP_PKG
Run HXT Shift Diff. Pol. Table Listing and other Oracle EBS reports with Blitz Report™ on our demo environment
select R.CARRYOVER_TIME, R.EFFECTIVE_END_DATE, R.EFFECTIVE_START_DATE, R.ELEMENT_TYPE_ID, ID ID1, R.NAME, R.SDP_ID,R.START_TIME, R.STOP_TIME, 
	HXT_HXT956C_XMLP_PKG.earn_typeformula(R.ELEMENT_TYPE_ID, R.EFFECTIVE_START_DATE, R.EFFECTIVE_END_DATE) EARN_TYPE
from HXT_SHIFT_DIFF_RULES R 
where R.SDP_ID=:ID
ORDER BY R.NAME
Blitz Report™