[Home] [Help]
View: ITG_TASKS
Product: | ITG - Internet Procurement Enterprise Connector |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT TASK_ID
, BSR_VERB
, BSR_NOUN
, BSR_REVISION
, REFERENCE_ID
, XML_DESTINATION
, PAYLOAD_ID
, USERNAME
, ACKNOWLEDGE_FLAG
, TRANSACTION_CREATION_DATE
, TRANSACTION_STATUS
, NO_RESEND
, STATUS_CHANGE_DATE
, REMARKS_TEXT
, RESEND_TASK_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, FND_IP_XML_MSG_INTERFACE_PKG.GET_DOC_NUMBER( BSR_VERB
, BSR_NOUN
, BSR_REVISION
, XML_DESTINATION
, REFERENCE_ID
, PAYLOAD_ID ) DOCUMENT_NUMBER
FROM FND_IP_XML_TASKS
Columns
Name |
TASK_ID |
BSR_VERB |
BSR_NOUN |
BSR_REVISION |
REFERENCE_ID |
XML_DESTINATION |
PAYLOAD_ID |
USERNAME |
ACKNOWLEDGE_FLAG |
TRANSACTION_CREATION_DATE |
TRANSACTION_STATUS |
NO_RESEND |
STATUS_CHANGE_DATE |
REMARKS_TEXT |
RESEND_TASK_ID |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
DOCUMENT_NUMBER |