VIEW: APPS.PQH_TRANSACTIONS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'