VIEW: APPS.CSF_DEBRIEF_HEADERS_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)