eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PO_DISTRIBUTIONS_TRX_V

Source

View Text - Preformatted


SELECT pod.PO_DISTRIBUTION_ID , pod.LAST_UPDATE_DATE , pod.LAST_UPDATED_BY , pod.PO_HEADER_ID , pod.PO_LINE_ID , pod.LINE_LOCATION_ID , pod.SET_OF_BOOKS_ID , pod.CODE_COMBINATION_ID , pod.QUANTITY_ORDERED , pod.LAST_UPDATE_LOGIN , pod.CREATION_DATE , pod.CREATED_BY , pod.PO_RELEASE_ID , pod.QUANTITY_DELIVERED , pod.QUANTITY_BILLED , pod.QUANTITY_CANCELLED , pod.REQ_HEADER_REFERENCE_NUM , pod.REQ_LINE_REFERENCE_NUM , pod.REQ_DISTRIBUTION_ID , pod.DELIVER_TO_LOCATION_ID , pod.DELIVER_TO_PERSON_ID , pod.RATE_DATE , pod.RATE , pod.AMOUNT_BILLED , pod.ACCRUED_FLAG , pod.ENCUMBERED_FLAG , pod.ENCUMBERED_AMOUNT , pod.UNENCUMBERED_QUANTITY , pod.UNENCUMBERED_AMOUNT , pod.FAILED_FUNDS_LOOKUP_CODE , pod.GL_ENCUMBERED_DATE , pod.GL_ENCUMBERED_PERIOD_NAME , pod.GL_CANCELLED_DATE , pod.DESTINATION_TYPE_CODE , pod.DESTINATION_ORGANIZATION_ID , pod.DESTINATION_SUBINVENTORY , pod.ATTRIBUTE_CATEGORY , pod.ATTRIBUTE1 , pod.ATTRIBUTE2 , pod.ATTRIBUTE3 , pod.ATTRIBUTE4 , pod.ATTRIBUTE5 , pod.ATTRIBUTE6 , pod.ATTRIBUTE7 , pod.ATTRIBUTE8 , pod.ATTRIBUTE9 , pod.ATTRIBUTE10 , pod.ATTRIBUTE11 , pod.ATTRIBUTE12 , pod.ATTRIBUTE13 , pod.ATTRIBUTE14 , pod.ATTRIBUTE15 , pod.WIP_ENTITY_ID , pod.WIP_OPERATION_SEQ_NUM , pod.WIP_RESOURCE_SEQ_NUM , pod.WIP_REPETITIVE_SCHEDULE_ID , pod.WIP_LINE_ID , pod.BOM_RESOURCE_ID , pod.BUDGET_ACCOUNT_ID , pod.ACCRUAL_ACCOUNT_ID , pod.VARIANCE_ACCOUNT_ID , pod.PREVENT_ENCUMBRANCE_FLAG , pod.USSGL_TRANSACTION_CODE , pod.GOVERNMENT_CONTEXT , pod.DESTINATION_CONTEXT , pod.DISTRIBUTION_NUM , pod.SOURCE_DISTRIBUTION_ID , pod.REQUEST_ID , pod.PROGRAM_APPLICATION_ID , pod.PROGRAM_ID , pod.PROGRAM_UPDATE_DATE , pod.PROJECT_ID , pod.TASK_ID , pod.EXPENDITURE_TYPE , pod.PROJECT_ACCOUNTING_CONTEXT , pod.EXPENDITURE_ORGANIZATION_ID , pod.GL_CLOSED_DATE , pod.ACCRUE_ON_RECEIPT_FLAG , pod.EXPENDITURE_ITEM_DATE , pod.ORG_ID , pod.KANBAN_CARD_ID , pod.AWARD_ID , pod.MRC_RATE_DATE , pod.MRC_RATE , pod.MRC_ENCUMBERED_AMOUNT , pod.MRC_UNENCUMBERED_AMOUNT , pod.END_ITEM_UNIT_NUMBER , pod.TAX_RECOVERY_OVERRIDE_FLAG , pod.RECOVERABLE_TAX , pod.NONRECOVERABLE_TAX , pod.RECOVERY_RATE , pod.OKE_CONTRACT_LINE_ID , pod.OKE_CONTRACT_DELIVERABLE_ID , pod.AMOUNT_ORDERED , pod.AMOUNT_DELIVERED , pod.AMOUNT_CANCELLED , pod.DISTRIBUTION_TYPE , pod.AMOUNT_TO_ENCUMBER , pod.INVOICE_ADJUSTMENT_FLAG , pod.DEST_CHARGE_ACCOUNT_ID , pod.DEST_VARIANCE_ACCOUNT_ID , pod.QUANTITY_FINANCED , pod.AMOUNT_FINANCED , pod.QUANTITY_RECOUPED , pod.AMOUNT_RECOUPED , pod.RETAINAGE_WITHHELD_AMOUNT , pod.RETAINAGE_RELEASED_AMOUNT , pod.WF_ITEM_KEY , pod.INVOICED_VAL_IN_NTFN , pod.TAX_ATTRIBUTE_UPDATE_CODE , pod.INTERFACE_DISTRIBUTION_REF , pod.LCM_FLAG , pod.GROUP_LINE_ID , pod.UDA_TEMPLATE_ID , pod.DRAFT_ID , pod.AMOUNT_FUNDED , pod.FUNDED_VALUE , pod.PARTIAL_FUNDED_FLAG , pod.QUANTITY_FUNDED , pod.CLM_MISC_LOA , pod.CLM_DEFENCE_FUNDING , pod.CLM_FMS_CASE_NUMBER , pod.CLM_AGENCY_ACCT_IDENTIFIER , pod.CHANGE_IN_FUNDED_VALUE FROM po_distributions pod, po_lines_trx_v pltv WHERE pod.po_line_id = pltv.po_line_id AND PO_CLM_INTG_GRP.Hide_Nonfunded ( 'PO' ,pod.PO_HEADER_ID ,pod.PO_LINE_ID ,pod.LINE_LOCATION_ID ,pod.PO_DISTRIBUTION_ID) <> 'Y'

View Text - HTML Formatted

SELECT POD.PO_DISTRIBUTION_ID
, POD.LAST_UPDATE_DATE
, POD.LAST_UPDATED_BY
, POD.PO_HEADER_ID
, POD.PO_LINE_ID
, POD.LINE_LOCATION_ID
, POD.SET_OF_BOOKS_ID
, POD.CODE_COMBINATION_ID
, POD.QUANTITY_ORDERED
, POD.LAST_UPDATE_LOGIN
, POD.CREATION_DATE
, POD.CREATED_BY
, POD.PO_RELEASE_ID
, POD.QUANTITY_DELIVERED
, POD.QUANTITY_BILLED
, POD.QUANTITY_CANCELLED
, POD.REQ_HEADER_REFERENCE_NUM
, POD.REQ_LINE_REFERENCE_NUM
, POD.REQ_DISTRIBUTION_ID
, POD.DELIVER_TO_LOCATION_ID
, POD.DELIVER_TO_PERSON_ID
, POD.RATE_DATE
, POD.RATE
, POD.AMOUNT_BILLED
, POD.ACCRUED_FLAG
, POD.ENCUMBERED_FLAG
, POD.ENCUMBERED_AMOUNT
, POD.UNENCUMBERED_QUANTITY
, POD.UNENCUMBERED_AMOUNT
, POD.FAILED_FUNDS_LOOKUP_CODE
, POD.GL_ENCUMBERED_DATE
, POD.GL_ENCUMBERED_PERIOD_NAME
, POD.GL_CANCELLED_DATE
, POD.DESTINATION_TYPE_CODE
, POD.DESTINATION_ORGANIZATION_ID
, POD.DESTINATION_SUBINVENTORY
, POD.ATTRIBUTE_CATEGORY
, POD.ATTRIBUTE1
, POD.ATTRIBUTE2
, POD.ATTRIBUTE3
, POD.ATTRIBUTE4
, POD.ATTRIBUTE5
, POD.ATTRIBUTE6
, POD.ATTRIBUTE7
, POD.ATTRIBUTE8
, POD.ATTRIBUTE9
, POD.ATTRIBUTE10
, POD.ATTRIBUTE11
, POD.ATTRIBUTE12
, POD.ATTRIBUTE13
, POD.ATTRIBUTE14
, POD.ATTRIBUTE15
, POD.WIP_ENTITY_ID
, POD.WIP_OPERATION_SEQ_NUM
, POD.WIP_RESOURCE_SEQ_NUM
, POD.WIP_REPETITIVE_SCHEDULE_ID
, POD.WIP_LINE_ID
, POD.BOM_RESOURCE_ID
, POD.BUDGET_ACCOUNT_ID
, POD.ACCRUAL_ACCOUNT_ID
, POD.VARIANCE_ACCOUNT_ID
, POD.PREVENT_ENCUMBRANCE_FLAG
, POD.USSGL_TRANSACTION_CODE
, POD.GOVERNMENT_CONTEXT
, POD.DESTINATION_CONTEXT
, POD.DISTRIBUTION_NUM
, POD.SOURCE_DISTRIBUTION_ID
, POD.REQUEST_ID
, POD.PROGRAM_APPLICATION_ID
, POD.PROGRAM_ID
, POD.PROGRAM_UPDATE_DATE
, POD.PROJECT_ID
, POD.TASK_ID
, POD.EXPENDITURE_TYPE
, POD.PROJECT_ACCOUNTING_CONTEXT
, POD.EXPENDITURE_ORGANIZATION_ID
, POD.GL_CLOSED_DATE
, POD.ACCRUE_ON_RECEIPT_FLAG
, POD.EXPENDITURE_ITEM_DATE
, POD.ORG_ID
, POD.KANBAN_CARD_ID
, POD.AWARD_ID
, POD.MRC_RATE_DATE
, POD.MRC_RATE
, POD.MRC_ENCUMBERED_AMOUNT
, POD.MRC_UNENCUMBERED_AMOUNT
, POD.END_ITEM_UNIT_NUMBER
, POD.TAX_RECOVERY_OVERRIDE_FLAG
, POD.RECOVERABLE_TAX
, POD.NONRECOVERABLE_TAX
, POD.RECOVERY_RATE
, POD.OKE_CONTRACT_LINE_ID
, POD.OKE_CONTRACT_DELIVERABLE_ID
, POD.AMOUNT_ORDERED
, POD.AMOUNT_DELIVERED
, POD.AMOUNT_CANCELLED
, POD.DISTRIBUTION_TYPE
, POD.AMOUNT_TO_ENCUMBER
, POD.INVOICE_ADJUSTMENT_FLAG
, POD.DEST_CHARGE_ACCOUNT_ID
, POD.DEST_VARIANCE_ACCOUNT_ID
, POD.QUANTITY_FINANCED
, POD.AMOUNT_FINANCED
, POD.QUANTITY_RECOUPED
, POD.AMOUNT_RECOUPED
, POD.RETAINAGE_WITHHELD_AMOUNT
, POD.RETAINAGE_RELEASED_AMOUNT
, POD.WF_ITEM_KEY
, POD.INVOICED_VAL_IN_NTFN
, POD.TAX_ATTRIBUTE_UPDATE_CODE
, POD.INTERFACE_DISTRIBUTION_REF
, POD.LCM_FLAG
, POD.GROUP_LINE_ID
, POD.UDA_TEMPLATE_ID
, POD.DRAFT_ID
, POD.AMOUNT_FUNDED
, POD.FUNDED_VALUE
, POD.PARTIAL_FUNDED_FLAG
, POD.QUANTITY_FUNDED
, POD.CLM_MISC_LOA
, POD.CLM_DEFENCE_FUNDING
, POD.CLM_FMS_CASE_NUMBER
, POD.CLM_AGENCY_ACCT_IDENTIFIER
, POD.CHANGE_IN_FUNDED_VALUE
FROM PO_DISTRIBUTIONS POD
, PO_LINES_TRX_V PLTV
WHERE POD.PO_LINE_ID = PLTV.PO_LINE_ID
AND PO_CLM_INTG_GRP.HIDE_NONFUNDED ( 'PO'
, POD.PO_HEADER_ID
, POD.PO_LINE_ID
, POD.LINE_LOCATION_ID
, POD.PO_DISTRIBUTION_ID) <> 'Y'