VIEW: APPS.OKE_DELIVERABLE_ACTIONS_V

Source

View Text - Preformatted

SELECT B.ROWID , B.ACTION_ID , B.ACTION_TYPE , B.ACTION_NAME , B.DELIVERABLE_ID , B.PA_ACTION_ID , B.TASK_ID , TSK.TASK_NAME , TSK.TASK_NUMBER , TSK.DESCRIPTION , B.SHIP_TO_ORG_ID , B.SHIP_TO_LOCATION_ID , B.SHIP_FROM_ORG_ID , B.SHIP_FROM_LOCATION_ID , B.IN_PROCESS_FLAG , B.READY_FLAG , B.REFERENCE1 , B.REFERENCE2 , B.REFERENCE3 , B.SCHEDULE_DESIGNATOR , B.INSPECTION_REQ_FLAG , B.EXPECTED_DATE , B.INITIATE_DATE , B.PROMISED_DATE , B.CREATED_BY , B.CREATION_DATE , B.LAST_UPDATED_BY , B.LAST_UPDATE_LOGIN , B.LAST_UPDATE_DATE , B.ATTRIBUTE_CATEGORY , B.ATTRIBUTE1 , B.ATTRIBUTE2 , B.ATTRIBUTE3 , B.ATTRIBUTE4 , B.ATTRIBUTE5 , B.ATTRIBUTE6 , B.ATTRIBUTE7 , B.ATTRIBUTE8 , B.ATTRIBUTE9 , B.ATTRIBUTE10 , B.ATTRIBUTE11 , B.ATTRIBUTE12 , B.ATTRIBUTE13 , B.ATTRIBUTE14 , B.ATTRIBUTE15 , B.VOLUME , B.VOLUME_UOM_CODE , B.WEIGHT , B.WEIGHT_UOM_CODE , B.EXPENDITURE_ORGANIZATION_ID , B.EXPENDITURE_TYPE , B.EXPENDITURE_ITEM_DATE , B.DESTINATION_TYPE_CODE , B.RATE_TYPE , B.RATE_DATE , B.EXCHANGE_RATE , B.REQUISITION_LINE_TYPE_ID , B.PO_CATEGORY_ID , B.UNIT_PRICE , B.CURRENCY_CODE , B.QUANTITY , B.UOM_CODE FROM OKE_DELIVERABLE_ACTIONS B , PA_TASKS TSK WHERE TSK.TASK_ID (+) = B.TASK_ID

View Text - HTML Formatted

SELECT B.ROWID
, B.ACTION_ID
, B.ACTION_TYPE
, B.ACTION_NAME
, B.DELIVERABLE_ID
, B.PA_ACTION_ID
, B.TASK_ID
, TSK.TASK_NAME
, TSK.TASK_NUMBER
, TSK.DESCRIPTION
, B.SHIP_TO_ORG_ID
, B.SHIP_TO_LOCATION_ID
, B.SHIP_FROM_ORG_ID
, B.SHIP_FROM_LOCATION_ID
, B.IN_PROCESS_FLAG
, B.READY_FLAG
, B.REFERENCE1
, B.REFERENCE2
, B.REFERENCE3
, B.SCHEDULE_DESIGNATOR
, B.INSPECTION_REQ_FLAG
, B.EXPECTED_DATE
, B.INITIATE_DATE
, B.PROMISED_DATE
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.LAST_UPDATE_DATE
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.VOLUME
, B.VOLUME_UOM_CODE
, B.WEIGHT
, B.WEIGHT_UOM_CODE
, B.EXPENDITURE_ORGANIZATION_ID
, B.EXPENDITURE_TYPE
, B.EXPENDITURE_ITEM_DATE
, B.DESTINATION_TYPE_CODE
, B.RATE_TYPE
, B.RATE_DATE
, B.EXCHANGE_RATE
, B.REQUISITION_LINE_TYPE_ID
, B.PO_CATEGORY_ID
, B.UNIT_PRICE
, B.CURRENCY_CODE
, B.QUANTITY
, B.UOM_CODE
FROM OKE_DELIVERABLE_ACTIONS B
, PA_TASKS TSK
WHERE TSK.TASK_ID (+) = B.TASK_ID