View: PQH_TRANSACTIONS_V

Product:	PQH - Public Sector HR
Description:
Implementation/DBA Data:	APPS.PQH_TRANSACTIONS_V

View Text

SELECT TCT.TRANSACTION_CATEGORY_ID
, PTX.POSITION_TRANSACTION_ID PARENT_TRANSACTION_ID
, PTX.POSITION_TRANSACTION_ID TRANSACTION_ID
, PTX.NAME TRANSACTION_NAME
, PTX.TRANSACTION_STATUS
, HR_GENERAL.DECODE_LOOKUP('PQH_TRANSACTION_STATUS'
, PTX.TRANSACTION_STATUS) TRANSACTION_STATUS_MEANING
, PQH_WF.GET_CURRENT_OWNER(PTX.POSITION_TRANSACTION_ID
, TCT.TRANSACTION_CATEGORY_ID
, PTX.TRANSACTION_STATUS) CURRENT_OWNER
FROM PQH_POSITION_TRANSACTIONS PTX
, PQH_TRANSACTION_CATEGORIES TCT
WHERE PTX.WF_TRANSACTION_CATEGORY_ID= TCT.TRANSACTION_CATEGORY_ID UNION SELECT TCT.TRANSACTION_CATEGORY_ID
, NVL(WKD.PARENT_WORKSHEET_DETAIL_ID
, WKD.WORKSHEET_DETAIL_ID)
, WKD.WORKSHEET_DETAIL_ID
, PQH_WKS_BUDGET.GET_TRANSACTION_NAME(WKD.WORKSHEET_DETAIL_ID)
, NVL(WKD.STATUS
, 'PENDING')
, HR_GENERAL.DECODE_LOOKUP('PQH_TRANSACTION_STATUS'
, NVL(WKD.STATUS
, 'PENDING'))
, PQH_WF.GET_CURRENT_OWNER(WKD.WORKSHEET_DETAIL_ID
, TCT.TRANSACTION_CATEGORY_ID
, WKD.STATUS) CURRENT_OWNER
FROM PQH_WORKSHEETS WKS
, PQH_WORKSHEET_DETAILS WKD
, PQH_TRANSACTION_CATEGORIES TCT
WHERE WKS.WF_TRANSACTION_CATEGORY_ID= TCT.TRANSACTION_CATEGORY_ID
AND WKS.WORKSHEET_ID = WKD.WORKSHEET_ID
AND WKD.STATUS IN ('APPROVED'
, 'DELEGATED'
, 'TERMINATE'
, 'SUBMITTED'
, 'REJECT'
, 'APPLIED'
, 'PENDING')
AND NVL(ACTION_CD
, 'D') ='D' UNION SELECT CET.TRANSACTION_CATEGORY_ID
, CET.COPY_ENTITY_TXN_ID
, CET.COPY_ENTITY_TXN_ID
, CET.DISPLAY_NAME
, CET.STATUS
, HR_GENERAL.DECODE_LOOKUP('PQH_GEN_STATUS'
, CET.STATUS)
, PQH_WF.GET_CURRENT_OWNER(CET.COPY_ENTITY_TXN_ID
, CET.TRANSACTION_CATEGORY_ID
, CET.STATUS) CURRENT_OWNER
FROM PQH_COPY_ENTITY_TXNS CET
, PQH_TRANSACTION_CATEGORIES TCT
WHERE TCT.TRANSACTION_CATEGORY_ID = CET.WF_TRANSACTION_CATEGORY_ID

Columns