VIEW: APPS.CSP_REQUIREMENT_HEADERS_V

Source

View Text - Preformatted

SELECT crh.requirement_header_id, crh.created_by, crh.creation_date, crh.last_updated_by, crh.last_update_date, crh.last_update_login, crh.open_requirement, crh.address_type, crh.ship_to_location_id, jtv.source_object_name service_Request, jtv.source_object_id, crh.task_id, jtv.task_number, crh.task_assignment_id, decode(crh.task_assignment_id,null,crh.resource_type,jta.resource_type_code), decode(crh.task_assignment_id,null,crh.resource_id,jta.resource_id), crh.need_by_date, crh.destination_organization_id, ood.organization_code , crh.destination_subinventory, crh.parts_defined, crh.order_type_id, ott.name order_type_name, crh.attribute_category, crh.attribute1, crh.attribute2, crh.attribute3, crh.attribute4, crh.attribute5, crh.attribute6, crh.attribute7, crh.attribute8, crh.attribute9, crh.attribute10, crh.attribute11, crh.attribute12, crh.attribute13, crh.attribute14, crh.attribute15 from oe_transaction_types ott, jtf_task_assignments jta, jtf_Tasks_b jtv, org_organization_definitions ood, csp_requirement_headers crh where ott.transaction_type_id(+) = crh.order_type_id and nvl(ott.transaction_type_code, 'ORDER') = 'ORDER' and jta.task_assignment_id(+) = crh.task_assignment_id and (nvl(jtv.source_object_type_code, 'SR') = 'SR' OR jtv.source_object_type_code = 'DR') and jtv.task_id(+) = crh.task_id and ood.organization_id(+) = crh.destination_organization_id

View Text - HTML Formatted

SELECT CRH.REQUIREMENT_HEADER_ID
, CRH.CREATED_BY
, CRH.CREATION_DATE
, CRH.LAST_UPDATED_BY
, CRH.LAST_UPDATE_DATE
, CRH.LAST_UPDATE_LOGIN
, CRH.OPEN_REQUIREMENT
, CRH.ADDRESS_TYPE
, CRH.SHIP_TO_LOCATION_ID
, JTV.SOURCE_OBJECT_NAME SERVICE_REQUEST
, JTV.SOURCE_OBJECT_ID
, CRH.TASK_ID
, JTV.TASK_NUMBER
, CRH.TASK_ASSIGNMENT_ID
, DECODE(CRH.TASK_ASSIGNMENT_ID
, NULL
, CRH.RESOURCE_TYPE
, JTA.RESOURCE_TYPE_CODE)
, DECODE(CRH.TASK_ASSIGNMENT_ID
, NULL
, CRH.RESOURCE_ID
, JTA.RESOURCE_ID)
, CRH.NEED_BY_DATE
, CRH.DESTINATION_ORGANIZATION_ID
, OOD.ORGANIZATION_CODE
, CRH.DESTINATION_SUBINVENTORY
, CRH.PARTS_DEFINED
, CRH.ORDER_TYPE_ID
, OTT.NAME ORDER_TYPE_NAME
, CRH.ATTRIBUTE_CATEGORY
, CRH.ATTRIBUTE1
, CRH.ATTRIBUTE2
, CRH.ATTRIBUTE3
, CRH.ATTRIBUTE4
, CRH.ATTRIBUTE5
, CRH.ATTRIBUTE6
, CRH.ATTRIBUTE7
, CRH.ATTRIBUTE8
, CRH.ATTRIBUTE9
, CRH.ATTRIBUTE10
, CRH.ATTRIBUTE11
, CRH.ATTRIBUTE12
, CRH.ATTRIBUTE13
, CRH.ATTRIBUTE14
, CRH.ATTRIBUTE15
FROM OE_TRANSACTION_TYPES OTT
, JTF_TASK_ASSIGNMENTS JTA
, JTF_TASKS_B JTV
, ORG_ORGANIZATION_DEFINITIONS OOD
, CSP_REQUIREMENT_HEADERS CRH
WHERE OTT.TRANSACTION_TYPE_ID(+) = CRH.ORDER_TYPE_ID
AND NVL(OTT.TRANSACTION_TYPE_CODE
, 'ORDER') = 'ORDER'
AND JTA.TASK_ASSIGNMENT_ID(+) = CRH.TASK_ASSIGNMENT_ID
AND (NVL(JTV.SOURCE_OBJECT_TYPE_CODE
, 'SR') = 'SR' OR JTV.SOURCE_OBJECT_TYPE_CODE = 'DR')
AND JTV.TASK_ID(+) = CRH.TASK_ID
AND OOD.ORGANIZATION_ID(+) = CRH.DESTINATION_ORGANIZATION_ID