View: CSF_DEBRIEF_HEADERS_V

Product:	CSF - Field Service
Description:	Field Service Report Headers summary information
Implementation/DBA Data:	APPS.CSF_DEBRIEF_HEADERS_V

View Text

SELECT CDH.ROWID
, CDH.DEBRIEF_HEADER_ID
, CDH.DEBRIEF_NUMBER
, CDH.DEBRIEF_DATE
, CDH.DEBRIEF_STATUS_ID
, JTV.TASK_ID
, CDH.TASK_ASSIGNMENT_ID
, CDH.PROCESSED_FLAG
, JTV.SCHEDULED_START_DATE
, CDH.CREATION_DATE
, CDH.LAST_UPDATE_DATE
, CDH.CREATED_BY
, CDH.LAST_UPDATED_BY
, CDH.LAST_UPDATE_LOGIN
, CDH.ATTRIBUTE_CATEGORY
, CDH.ATTRIBUTE1
, CDH.ATTRIBUTE2
, CDH.ATTRIBUTE3
, CDH.ATTRIBUTE4
, CDH.ATTRIBUTE5
, CDH.ATTRIBUTE6
, CDH.ATTRIBUTE7
, CDH.ATTRIBUTE8
, CDH.ATTRIBUTE9
, CDH.ATTRIBUTE10
, CDH.ATTRIBUTE11
, CDH.ATTRIBUTE12
, CDH.ATTRIBUTE13
, CDH.ATTRIBUTE14
, CDH.ATTRIBUTE15
, JTV.TASK_NUMBER
, JTV.SOURCE_OBJECT_TYPE_CODE
, JTV.TASK_NAME
, JTV.DESCRIPTION
, JTS1.NAME
, JTS2.NAME
, JPA.PARTY_NAME
, JPA.PARTY_NUMBER
, JPA.ADDRESS1 || '
, ' || JPA.ADDRESS2 || '
, ' || JPA.ADDRESS3 || '
, ' || JPA.ADDRESS4
, JPA.CITY ||'
, ' || JPA.STATE ||' - '|| JPA.POSTAL_CODE
, JTA.RESOURCE_ID
, CSF_UTIL_PVT.GET_OBJECT_NAME(JTA.RESOURCE_TYPE_CODE
, JTA.RESOURCE_ID)
, JTA.RESOURCE_TYPE_CODE
, CIA.INCIDENT_NUMBER
, CIA.INCIDENT_ID
, CIA.INCIDENT_DATE
, CIA.CUSTOMER_PO_NUMBER
, MSIBK.CONCATENATED_SEGMENTS
, MSIBK.INVENTORY_ITEM_ID
, MSIBK.DESCRIPTION
, JTV.SOURCE_OBJECT_ID
, CIA.CUSTOMER_ID
, JTV.CUST_ACCOUNT_ID
, MSIBK.ORGANIZATION_ID FROM JTF_TASK_STATUSES_VL JTS1
, JTF_TASK_STATUSES_VL JTS2
, MTL_SYSTEM_ITEMS_B_KFV MSIBK
, JTF_PARTIES_ALL_V JPA
, CS_INCIDENTS_ALL_B CIA
, CSF_DEBRIEF_HEADERS CDH
, JTF_TASKS_VL JTV
, JTF_TASK_ASSIGNMENTS JTA
WHERE JTV.SOURCE_OBJECT_ID = CIA.INCIDENT_ID (+)
AND CDH.TASK_ASSIGNMENT_ID = JTA.TASK_ASSIGNMENT_ID
AND JTA.TASK_ID = JTV.TASK_ID
AND JTA.ASSIGNEE_ROLE = 'ASSIGNEE'
AND NVL (JTV.DELETED_FLAG
, 'N') != 'Y'
AND JTV.CUSTOMER_ID = JPA.PARTY_ID (+)
AND JTV.TASK_STATUS_ID = JTS1.TASK_STATUS_ID
AND JTA.ASSIGNMENT_STATUS_ID = JTS2.TASK_STATUS_ID
AND CIA.INVENTORY_ITEM_ID = MSIBK.INVENTORY_ITEM_ID (+)

Columns