VIEW: APPS.ECE_PO_PROJECT_INFO_V

Source

View Text - Preformatted

SELECT pod.po_header_id po_header_id, NVL(pod.po_release_id,0) po_release_id, pod.po_line_id po_line_id, pod.line_location_id line_location_id, pod.po_distribution_id po_distribution_id, pod.project_id project_id, pod.task_id task_id, pod.distribution_num distribution_num, ppe.project_number project_number, ppe.project_type project_type, pat.task_number task_number, pod.quantity_ordered quantity_ordered, pod.quantity_delivered quantity_delivered, pod.quantity_billed quantity_billed, pod.quantity_cancelled quantity_cancelled, pod.amount_billed amount_billed, pod.rate conversion_rate, pod.rate_date conversion_date, pod.destination_type_code destination_type_code_int, pod.attribute_category distribution_attrib_category, pod.attribute1 distribution_attribute1, pod.attribute2 distribution_attribute2, pod.attribute3 distribution_attribute3, pod.attribute4 distribution_attribute4, pod.attribute5 distribution_attribute5, pod.attribute6 distribution_attribute6, pod.attribute7 distribution_attribute7, pod.attribute8 distribution_attribute8, pod.attribute9 distribution_attribute9, pod.attribute10 distribution_attribute10, pod.attribute11 distribution_attribute11, pod.attribute12 distribution_attribute12, pod.attribute13 distribution_attribute13, pod.attribute14 distribution_attribute14, pod.attribute15 distribution_attribute15 FROM pa_projects_expend_v ppe, pa_tasks pat, po_distributions pod WHERE pod.task_id = pat.task_id (+) AND pod.project_id = pat.project_id (+) AND pod.project_id = ppe.project_id (+)

View Text - HTML Formatted

SELECT POD.PO_HEADER_ID PO_HEADER_ID
, NVL(POD.PO_RELEASE_ID
, 0) PO_RELEASE_ID
, POD.PO_LINE_ID PO_LINE_ID
, POD.LINE_LOCATION_ID LINE_LOCATION_ID
, POD.PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
, POD.PROJECT_ID PROJECT_ID
, POD.TASK_ID TASK_ID
, POD.DISTRIBUTION_NUM DISTRIBUTION_NUM
, PPE.PROJECT_NUMBER PROJECT_NUMBER
, PPE.PROJECT_TYPE PROJECT_TYPE
, PAT.TASK_NUMBER TASK_NUMBER
, POD.QUANTITY_ORDERED QUANTITY_ORDERED
, POD.QUANTITY_DELIVERED QUANTITY_DELIVERED
, POD.QUANTITY_BILLED QUANTITY_BILLED
, POD.QUANTITY_CANCELLED QUANTITY_CANCELLED
, POD.AMOUNT_BILLED AMOUNT_BILLED
, POD.RATE CONVERSION_RATE
, POD.RATE_DATE CONVERSION_DATE
, POD.DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE_INT
, POD.ATTRIBUTE_CATEGORY DISTRIBUTION_ATTRIB_CATEGORY
, POD.ATTRIBUTE1 DISTRIBUTION_ATTRIBUTE1
, POD.ATTRIBUTE2 DISTRIBUTION_ATTRIBUTE2
, POD.ATTRIBUTE3 DISTRIBUTION_ATTRIBUTE3
, POD.ATTRIBUTE4 DISTRIBUTION_ATTRIBUTE4
, POD.ATTRIBUTE5 DISTRIBUTION_ATTRIBUTE5
, POD.ATTRIBUTE6 DISTRIBUTION_ATTRIBUTE6
, POD.ATTRIBUTE7 DISTRIBUTION_ATTRIBUTE7
, POD.ATTRIBUTE8 DISTRIBUTION_ATTRIBUTE8
, POD.ATTRIBUTE9 DISTRIBUTION_ATTRIBUTE9
, POD.ATTRIBUTE10 DISTRIBUTION_ATTRIBUTE10
, POD.ATTRIBUTE11 DISTRIBUTION_ATTRIBUTE11
, POD.ATTRIBUTE12 DISTRIBUTION_ATTRIBUTE12
, POD.ATTRIBUTE13 DISTRIBUTION_ATTRIBUTE13
, POD.ATTRIBUTE14 DISTRIBUTION_ATTRIBUTE14
, POD.ATTRIBUTE15 DISTRIBUTION_ATTRIBUTE15
FROM PA_PROJECTS_EXPEND_V PPE
, PA_TASKS PAT
, PO_DISTRIBUTIONS POD
WHERE POD.TASK_ID = PAT.TASK_ID (+)
AND POD.PROJECT_ID = PAT.PROJECT_ID (+)
AND POD.PROJECT_ID = PPE.PROJECT_ID (+)