[Home] [Help]
View: AP_WFAPPROVAL_HISTORY_V
View Text
(
SELECT DISTINCT HIS.INVOICE_ID
,
HIS.LINE_NUMBER
,
HIS.RESPONSE
,
HIS.APPROVER_ID
,
HIS.APPROVER_NAME
,
HIS.AMOUNT_APPROVED
,
HIS.APPROVER_COMMENTS
,
HIS.LAST_UPDATE_DATE
,
ALC1.DISPLAYED_FIELD
,
HIS.ITERATION
,
HIS.HISTORY_TYPE
,
ALC2.DISPLAYED_FIELD
,
-1
FROM AP_INV_APRVL_HIST_ALL HIS
,
AP_LOOKUP_CODES ALC1
,
AP_LOOKUP_CODES ALC2
WHERE ALC1.LOOKUP_CODE(+) = HIS.RESPONSE
AND ALC1.LOOKUP_TYPE (+) = 'AP_WFAPPROVAL_STATUS'
AND ALC2.LOOKUP_TYPE (+) ='AP_WFAPPROVAL_CONTEXT'
AND ALC2.LOOKUP_CODE (+) = HIS.HISTORY_TYPE
UNION ALL
SELECT AGT.TRANSACTION_ID
,
AGT.LINE_NUMBER
,
ALC1.LOOKUP_CODE
,
AGT.PERSON_ID
,
AGT.DISPLAY_NAME
,
0
,
NULL
,
SYSDATE
,
ALC1.DISPLAYED_FIELD
,
0
,
ALC2.LOOKUP_CODE
,
ALC2.DISPLAYED_FIELD
,
AGT.APPROVER_ORDER_NUMBER
FROM AP_APPROVERS_LIST_GT AGT
,
AP_LOOKUP_CODES ALC1
, /* BUG 5624200 */
AP_LOOKUP_CODES ALC2
WHERE AGT.APPROVAL_STATUS IS NULL
AND ALC1.LOOKUP_TYPE = 'NLS TRANSLATION' /* BUG 5624200 */
AND ALC1.LOOKUP_CODE = 'FUTURE'
AND ALC2.LOOKUP_TYPE (+) ='AP_WFAPPROVAL_CONTEXT'
AND ALC2.LOOKUP_CODE (+) =
DECODE(AGT.ITEM_CLASS
, 'HEADER'
, 'DOCUMENTAPPROVAL'
, 'LINESAPPROVAL')
/* BUG 8546490*/
AND AGT.ORIG_SYSTEM_ID NOT IN (SELECT HIS.APPROVER_ID
FROM AP_INV_APRVL_HIST_ALL HIS
, AP_INVOICES_ALL AI
WHERE AI.INVOICE_ID = HIS.INVOICE_ID
AND AI.APPROVAL_ITERATION = HIS.ITERATION
AND HIS.RESPONSE = 'SENT'
AND HIS.INVOICE_ID = TRANSACTION_ID
AND HIS.HISTORY_TYPE =
DECODE(AGT.ITEM_CLASS
, 'HEADER'
, 'DOCUMENTAPPROVAL'
, 'LINESAPPROVAL'))
AND EXISTS (SELECT 'INITIATED INVOICE'
FROM AP_INVOICES_ALL AI
WHERE AI.INVOICE_ID = TRANSACTION_ID
AND AI.WFAPPROVAL_STATUS = 'INITIATED')
)
Columns
Name |
INVOICE_ID |
RESPONSE |
PERSON_ID |
APPROVER_NAME |
AMOUNT_APPROVED |
APPROVER_COMMENTS |
LAST_UPDATE_DATE |
RESPONSE_DSP |
ITERATION |