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
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 |