VIEW: APPS.AP_PO_DISTRIBUTIONS_AP2_V

Source

View Text - Preformatted

SELECT PD.ROWID ROW_ID , PD.ACCRUAL_ACCOUNT_ID ACCRUAL_ACCOUNT_ID , PD.ACCRUED_FLAG ACCRUED_FLAG , PD.ACCRUE_ON_RECEIPT_FLAG ACCRUE_ON_RECEIPT_FLAG , PD.AMOUNT_BILLED AMOUNT_BILLED , PD.ATTRIBUTE1 ATTRIBUTE1 , PD.ATTRIBUTE10 ATTRIBUTE10 , PD.ATTRIBUTE11 ATTRIBUTE11 , PD.ATTRIBUTE12 ATTRIBUTE12 , PD.ATTRIBUTE13 ATTRIBUTE13 , PD.ATTRIBUTE14 ATTRIBUTE14 , PD.ATTRIBUTE15 ATTRIBUTE15 , PD.ATTRIBUTE2 ATTRIBUTE2 , PD.ATTRIBUTE3 ATTRIBUTE3 , PD.ATTRIBUTE4 ATTRIBUTE4 , PD.ATTRIBUTE5 ATTRIBUTE5 , PD.ATTRIBUTE6 ATTRIBUTE6 , PD.ATTRIBUTE7 ATTRIBUTE7 , PD.ATTRIBUTE8 ATTRIBUTE8 , PD.ATTRIBUTE9 ATTRIBUTE9 , PD.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY , PD.BOM_RESOURCE_ID BOM_RESOURCE_ID , PD.BUDGET_ACCOUNT_ID BUDGET_ACCOUNT_ID , decode (PD.DESTINATION_TYPE_CODE, 'EXPENSE', decode (PD.ACCRUE_ON_RECEIPT_FLAG, 'Y', PD.ACCRUAL_ACCOUNT_ID, PD.CODE_COMBINATION_ID), PD.ACCRUAL_ACCOUNT_ID) CODE_COMBINATION_ID , PD.CREATED_BY CREATED_BY , PD.CREATION_DATE CREATION_DATE , PD.DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID , PD.DELIVER_TO_PERSON_ID DELIVER_TO_PERSON_ID , PD.DESTINATION_CONTEXT DESTINATION_CONTEXT , PD.DESTINATION_ORGANIZATION_ID DESTINATION_ORGANIZATION_ID , PD.DESTINATION_SUBINVENTORY DESTINATION_SUBINVENTORY , PD.DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE , PD.DISTRIBUTION_NUM DISTRIBUTION_NUM , PD.ENCUMBERED_AMOUNT ENCUMBERED_AMOUNT , PD.ENCUMBERED_FLAG ENCUMBERED_FLAG , PD.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE , PD.EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID , HOUT.NAME EXPENDITURE_ORGANIZATION , PD.EXPENDITURE_TYPE EXPENDITURE_TYPE , PD.FAILED_FUNDS_LOOKUP_CODE FAILED_FUNDS_LOOKUP_CODE , PD.GL_CANCELLED_DATE GL_CANCELLED_DATE , PD.GL_CLOSED_DATE GL_CLOSED_DATE , PD.GL_ENCUMBERED_DATE GL_ENCUMBERED_DATE , PD.GL_ENCUMBERED_PERIOD_NAME GL_ENCUMBERED_PERIOD_NAME , PD.GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT , PD.LAST_UPDATED_BY LAST_UPDATED_BY , PD.LAST_UPDATE_DATE LAST_UPDATE_DATE , PD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN , PD.LINE_LOCATION_ID LINE_LOCATION_ID , PD.ORG_ID ORG_ID , PD.PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID , PD.PO_HEADER_ID PO_HEADER_ID , PD.PO_LINE_ID PO_LINE_ID , PD.PO_RELEASE_ID PO_RELEASE_ID , PD.PREVENT_ENCUMBRANCE_FLAG PREVENT_ENCUMBRANCE_FLAG , PD.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID , PD.PROGRAM_ID PROGRAM_ID , PD.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE , PD.PROJECT_ACCOUNTING_CONTEXT PROJECT_ACCOUNTING_CONTEXT , PD.PROJECT_ID PROJECT_ID , PAP.SEGMENT1 PROJECT_NAME , PD.QUANTITY_BILLED QUANTITY_BILLED , PD.QUANTITY_CANCELLED QUANTITY_CANCELLED , PD.QUANTITY_DELIVERED QUANTITY_DELIVERED , PD.QUANTITY_ORDERED QUANTITY_ORDERED , PD.RATE RATE , PD.RATE_DATE RATE_DATE , PD.REQUEST_ID REQUEST_ID , PD.REQ_DISTRIBUTION_ID REQ_DISTRIBUTION_ID , PD.REQ_HEADER_REFERENCE_NUM REQ_HEADER_REFERENCE_NUM , PD.REQ_LINE_REFERENCE_NUM REQ_LINE_REFERENCE_NUM , PD.SET_OF_BOOKS_ID SET_OF_BOOKS_ID , PD.SOURCE_DISTRIBUTION_ID SOURCE_DISTRIBUTION_ID , PD.TASK_ID TASK_ID , PAT.TASK_NUMBER TASK_NUMBER , PAT.TASK_NAME TASK_NAME , PD.UNENCUMBERED_AMOUNT UNENCUMBERED_AMOUNT , PD.UNENCUMBERED_QUANTITY UNENCUMBERED_QUANTITY , PD.VARIANCE_ACCOUNT_ID VARIANCE_ACCOUNT_ID , PD.WIP_ENTITY_ID WIP_ENTITY_ID , PD.WIP_LINE_ID WIP_LINE_ID , PD.WIP_OPERATION_SEQ_NUM WIP_OPERATION_SEQ_NUM , PD.WIP_REPETITIVE_SCHEDULE_ID WIP_REPETITIVE_SCHEDULE_ID , PD.WIP_RESOURCE_SEQ_NUM WIP_RESOURCE_SEQ_NUM , HE.FULL_NAME REQUESTOR , PD.AMOUNT_ORDERED AMOUNT_ORDERED , PD.AMOUNT_DELIVERED AMOUNT_DELIVERED , PD.AMOUNT_CANCELLED AMOUNT_CANCELLED , PD.AMOUNT_FINANCED AMOUNT_FINANCED , PD.AMOUNT_RECOUPED AMOUNT_RECOUPED , PD.QUANTITY_FINANCED QUANTITY_FINANCED , PD.QUANTITY_RECOUPED QUANTITY_RECOUPED , PD.RETAINAGE_WITHHELD_AMOUNT RETAINAGE_WITHHELD_AMOUNT , PD.RETAINAGE_RELEASED_AMOUNT RETAINAGE_RELEASED_AMOUNT , PD.DISTRIBUTION_TYPE DISTRIBUTION_TYPE FROM PO_DISTRIBUTIONS PD, PER_PEOPLE_F HE, PA_TASKS_EXPEND_V PAT, PA_PROJECTS_ALL PAP, HR_ORG_UNITS_NO_JOIN HROU, HR_ALL_ORGANIZATION_UNITS_TL HOUT WHERE PD.DELIVER_TO_PERSON_ID = HE.PERSON_ID (+) AND TRUNC(SYSDATE) > HE.EFFECTIVE_START_DATE (+) AND TRUNC(SYSDATE) < HE.EFFECTIVE_END_DATE (+) AND PD.PROJECT_ID = PAP.PROJECT_ID (+) AND PD.TASK_ID = PAT.TASK_ID (+) AND PD.EXPENDITURE_ORGANIZATION_ID = HROU.ORGANIZATION_ID(+) AND hrou.organization_id = hout.organization_id (+) AND DECODE(hout.organization_id, null, '1', hout.language) = DECODE(hout.organization_id, null, '1', USERENV('LANG'))

View Text - HTML Formatted

SELECT PD.ROWID ROW_ID
, PD.ACCRUAL_ACCOUNT_ID ACCRUAL_ACCOUNT_ID
, PD.ACCRUED_FLAG ACCRUED_FLAG
, PD.ACCRUE_ON_RECEIPT_FLAG ACCRUE_ON_RECEIPT_FLAG
, PD.AMOUNT_BILLED AMOUNT_BILLED
, PD.ATTRIBUTE1 ATTRIBUTE1
, PD.ATTRIBUTE10 ATTRIBUTE10
, PD.ATTRIBUTE11 ATTRIBUTE11
, PD.ATTRIBUTE12 ATTRIBUTE12
, PD.ATTRIBUTE13 ATTRIBUTE13
, PD.ATTRIBUTE14 ATTRIBUTE14
, PD.ATTRIBUTE15 ATTRIBUTE15
, PD.ATTRIBUTE2 ATTRIBUTE2
, PD.ATTRIBUTE3 ATTRIBUTE3
, PD.ATTRIBUTE4 ATTRIBUTE4
, PD.ATTRIBUTE5 ATTRIBUTE5
, PD.ATTRIBUTE6 ATTRIBUTE6
, PD.ATTRIBUTE7 ATTRIBUTE7
, PD.ATTRIBUTE8 ATTRIBUTE8
, PD.ATTRIBUTE9 ATTRIBUTE9
, PD.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, PD.BOM_RESOURCE_ID BOM_RESOURCE_ID
, PD.BUDGET_ACCOUNT_ID BUDGET_ACCOUNT_ID
, DECODE (PD.DESTINATION_TYPE_CODE
, 'EXPENSE'
, DECODE (PD.ACCRUE_ON_RECEIPT_FLAG
, 'Y'
, PD.ACCRUAL_ACCOUNT_ID
, PD.CODE_COMBINATION_ID)
, PD.ACCRUAL_ACCOUNT_ID) CODE_COMBINATION_ID
, PD.CREATED_BY CREATED_BY
, PD.CREATION_DATE CREATION_DATE
, PD.DELIVER_TO_LOCATION_ID DELIVER_TO_LOCATION_ID
, PD.DELIVER_TO_PERSON_ID DELIVER_TO_PERSON_ID
, PD.DESTINATION_CONTEXT DESTINATION_CONTEXT
, PD.DESTINATION_ORGANIZATION_ID DESTINATION_ORGANIZATION_ID
, PD.DESTINATION_SUBINVENTORY DESTINATION_SUBINVENTORY
, PD.DESTINATION_TYPE_CODE DESTINATION_TYPE_CODE
, PD.DISTRIBUTION_NUM DISTRIBUTION_NUM
, PD.ENCUMBERED_AMOUNT ENCUMBERED_AMOUNT
, PD.ENCUMBERED_FLAG ENCUMBERED_FLAG
, PD.EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, PD.EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, HOUT.NAME EXPENDITURE_ORGANIZATION
, PD.EXPENDITURE_TYPE EXPENDITURE_TYPE
, PD.FAILED_FUNDS_LOOKUP_CODE FAILED_FUNDS_LOOKUP_CODE
, PD.GL_CANCELLED_DATE GL_CANCELLED_DATE
, PD.GL_CLOSED_DATE GL_CLOSED_DATE
, PD.GL_ENCUMBERED_DATE GL_ENCUMBERED_DATE
, PD.GL_ENCUMBERED_PERIOD_NAME GL_ENCUMBERED_PERIOD_NAME
, PD.GOVERNMENT_CONTEXT GOVERNMENT_CONTEXT
, PD.LAST_UPDATED_BY LAST_UPDATED_BY
, PD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PD.LINE_LOCATION_ID LINE_LOCATION_ID
, PD.ORG_ID ORG_ID
, PD.PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
, PD.PO_HEADER_ID PO_HEADER_ID
, PD.PO_LINE_ID PO_LINE_ID
, PD.PO_RELEASE_ID PO_RELEASE_ID
, PD.PREVENT_ENCUMBRANCE_FLAG PREVENT_ENCUMBRANCE_FLAG
, PD.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PD.PROGRAM_ID PROGRAM_ID
, PD.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PD.PROJECT_ACCOUNTING_CONTEXT PROJECT_ACCOUNTING_CONTEXT
, PD.PROJECT_ID PROJECT_ID
, PAP.SEGMENT1 PROJECT_NAME
, PD.QUANTITY_BILLED QUANTITY_BILLED
, PD.QUANTITY_CANCELLED QUANTITY_CANCELLED
, PD.QUANTITY_DELIVERED QUANTITY_DELIVERED
, PD.QUANTITY_ORDERED QUANTITY_ORDERED
, PD.RATE RATE
, PD.RATE_DATE RATE_DATE
, PD.REQUEST_ID REQUEST_ID
, PD.REQ_DISTRIBUTION_ID REQ_DISTRIBUTION_ID
, PD.REQ_HEADER_REFERENCE_NUM REQ_HEADER_REFERENCE_NUM
, PD.REQ_LINE_REFERENCE_NUM REQ_LINE_REFERENCE_NUM
, PD.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, PD.SOURCE_DISTRIBUTION_ID SOURCE_DISTRIBUTION_ID
, PD.TASK_ID TASK_ID
, PAT.TASK_NUMBER TASK_NUMBER
, PAT.TASK_NAME TASK_NAME
, PD.UNENCUMBERED_AMOUNT UNENCUMBERED_AMOUNT
, PD.UNENCUMBERED_QUANTITY UNENCUMBERED_QUANTITY
, PD.VARIANCE_ACCOUNT_ID VARIANCE_ACCOUNT_ID
, PD.WIP_ENTITY_ID WIP_ENTITY_ID
, PD.WIP_LINE_ID WIP_LINE_ID
, PD.WIP_OPERATION_SEQ_NUM WIP_OPERATION_SEQ_NUM
, PD.WIP_REPETITIVE_SCHEDULE_ID WIP_REPETITIVE_SCHEDULE_ID
, PD.WIP_RESOURCE_SEQ_NUM WIP_RESOURCE_SEQ_NUM
, HE.FULL_NAME REQUESTOR
, PD.AMOUNT_ORDERED AMOUNT_ORDERED
, PD.AMOUNT_DELIVERED AMOUNT_DELIVERED
, PD.AMOUNT_CANCELLED AMOUNT_CANCELLED
, PD.AMOUNT_FINANCED AMOUNT_FINANCED
, PD.AMOUNT_RECOUPED AMOUNT_RECOUPED
, PD.QUANTITY_FINANCED QUANTITY_FINANCED
, PD.QUANTITY_RECOUPED QUANTITY_RECOUPED
, PD.RETAINAGE_WITHHELD_AMOUNT RETAINAGE_WITHHELD_AMOUNT
, PD.RETAINAGE_RELEASED_AMOUNT RETAINAGE_RELEASED_AMOUNT
, PD.DISTRIBUTION_TYPE DISTRIBUTION_TYPE
FROM PO_DISTRIBUTIONS PD
, PER_PEOPLE_F HE
, PA_TASKS_EXPEND_V PAT
, PA_PROJECTS_ALL PAP
, HR_ORG_UNITS_NO_JOIN HROU
, HR_ALL_ORGANIZATION_UNITS_TL HOUT
WHERE PD.DELIVER_TO_PERSON_ID = HE.PERSON_ID (+)
AND TRUNC(SYSDATE) > HE.EFFECTIVE_START_DATE (+)
AND TRUNC(SYSDATE) < HE.EFFECTIVE_END_DATE (+)
AND PD.PROJECT_ID = PAP.PROJECT_ID (+)
AND PD.TASK_ID = PAT.TASK_ID (+)
AND PD.EXPENDITURE_ORGANIZATION_ID = HROU.ORGANIZATION_ID(+)
AND HROU.ORGANIZATION_ID = HOUT.ORGANIZATION_ID (+)
AND DECODE(HOUT.ORGANIZATION_ID
, NULL
, '1'
, HOUT.LANGUAGE) = DECODE(HOUT.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))