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.

[Home] [Help]

View: POBV_SCHEDULED_DISTRIBUTIONS

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.POBV_SCHEDULED_DISTRIBUTIONS

View Text

SELECT PD.PO_DISTRIBUTION_ID
, PD.DISTRIBUTION_NUM
, PD.LINE_LOCATION_ID
, PS.SHIPMENT_NUM
, PD.PO_LINE_ID
, PL.LINE_NUM
, PD.PO_HEADER_ID
, PH.SEGMENT1
, PD.PO_RELEASE_ID
, PR.RELEASE_NUM
, PD.ORG_ID
, OP.NAME
, PD.QUANTITY_ORDERED
, PD.QUANTITY_DELIVERED
, PD.QUANTITY_CANCELLED
, PD.QUANTITY_BILLED
, PD.AMOUNT_BILLED
, PD.RATE
, PD.RATE_DATE
, PD.GL_CANCELLED_DATE
, PD.GL_CLOSED_DATE
, '_LA:PD.ACCRUE_ON_RECEIPT_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:PD.ACCRUED_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:PD.PREVENT_ENCUMBRANCE_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_LA:PD.ENCUMBERED_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, PD.ENCUMBERED_AMOUNT
, PD.GL_ENCUMBERED_DATE
, PD.GL_ENCUMBERED_PERIOD_NAME
, PD.UNENCUMBERED_AMOUNT
, PD.UNENCUMBERED_QUANTITY
, '_LA:PD.FAILED_FUNDS_LOOKUP_CODE:GL_LOOKUPS:FUNDS_CHECK_RETURN_CODE:MEANING'
, '_LA:PD.DESTINATION_TYPE_CODE:PO_LOOKUP_CODES:DESTINATION TYPE:DISPLAYED_FIELD'
, PD.EXPENDITURE_TYPE
, PD.EXPENDITURE_ITEM_DATE
, PD.USSGL_TRANSACTION_CODE
, PD.SET_OF_BOOKS_ID
, PD.CODE_COMBINATION_ID
, PD.BUDGET_ACCOUNT_ID
, PD.ACCRUAL_ACCOUNT_ID
, PD.VARIANCE_ACCOUNT_ID
, PD.DEST_CHARGE_ACCOUNT_ID
, PD.DEST_VARIANCE_ACCOUNT_ID
, PD.DELIVER_TO_PERSON_ID
, PD.DELIVER_TO_LOCATION_ID
, PD.DESTINATION_ORGANIZATION_ID
, PD.DESTINATION_SUBINVENTORY
, PD.REQ_DISTRIBUTION_ID
, PD.PROJECT_ID
, PD.TASK_ID
, PD.EXPENDITURE_ORGANIZATION_ID
, PD.BOM_RESOURCE_ID
, PD.WIP_ENTITY_ID
, PD.WIP_LINE_ID
, PD.WIP_REPETITIVE_SCHEDULE_ID
, PD.WIP_OPERATION_SEQ_NUM
, PD.WIP_RESOURCE_SEQ_NUM
, PD.CREATION_DATE
, PD.CREATED_BY
, PD.LAST_UPDATE_DATE
, PD.LAST_UPDATED_BY
, PD.OKE_CONTRACT_LINE_ID
, PD.OKE_CONTRACT_DELIVERABLE_ID
FROM PO_DISTRIBUTIONS_ALL PD
, PO_LINE_LOCATIONS_ALL PS
, PO_LINES_ALL PL
, PO_HEADERS_ALL PH
, PO_RELEASES_ALL PR
, HR_ALL_ORGANIZATION_UNITS OP
WHERE PH.TYPE_LOOKUP_CODE = 'PLANNED'
AND PS.SHIPMENT_TYPE = 'SCHEDULED'
AND PD.LINE_LOCATION_ID = PS.LINE_LOCATION_ID
AND PD.PO_LINE_ID = PL.PO_LINE_ID
AND PD.PO_HEADER_ID = PH.PO_HEADER_ID
AND PD.PO_RELEASE_ID = PR.PO_RELEASE_ID
AND PD.ORG_ID = OP.ORGANIZATION_ID
AND '_SEC:PD.ORG_ID' IS NOT NULL WITH READ ONLY

Columns

Name
PO_DISTRIBUTION_ID
DISTRIBUTION_NUMBER
PO_SHIPMENT_ID
SHIPMENT_NUMBER
PO_LINE_ID
LINE_NUMBER
PLANNED_PO_ID
PLANNED_PO_DOCUMENT_NUMBER
PLANNED_RELEASE_ID
RELEASE_NUMBER
OPERATING_UNIT_ID
OPERATING_UNIT_NAME
ORDERED_QUANTITY
DELIVERED_QUANTITY
CANCELLED_QUANTITY
BILLED_QUANTITY
BILLED_AMOUNT
CURRENCY_CONVERSION_RATE
CURRENCY_CONVERSION_RATE_DATE
GL_CANCEL_DATE
GL_CLOSED_DATE
"_LA:ACCRUE_ON_RECEIPT_FLAG"
"_LA:ACCRUED_FLAG"
"_LA:PREVENT_ENCUMBRANCE_FLAG"
"_LA:ENCUMBERED_FLAG"
ENCUMBERED_AMOUNT
GL_ENCUMBERED_DATE
GL_ENCUMBERED_PERIOD_NAME
UNENCUMBERED_AMOUNT
UNENCUMBERED_QUANTITY
"_LA:FUNDS_CHECK_FAILURE_TYPE"
"_LA:DESTINATION_TYPE"
PROJECT_EXPENDITURE_TYPE
EXPENDITURE_ITEM_DATE
USSGL_TRANSACTION_CODE
SET_OF_BOOKS_ID
CHARGE_ACCOUNT_ID
BUDGET_ACCOUNT_ID
ACCRUAL_ACCOUNT_ID
VARIANCE_ACCOUNT_ID
DEST_CHARGE_ACCOUNT_ID
DEST_VARIANCE_ACCOUNT_ID
DELIVER_TO_PERSON_ID
DELIVER_TO_LOCATION_ID
DESTINATION_ORGANIZATION_ID
DESTINATION_SUBINVENTORY
REQUISITION_DISTRIBUTION_ID
PROJECT_ID
TASK_ID
EXPENDITURE_ORGANIZATION_ID
BOM_RESOURCE_ID
WIP_ENTITY_ID
WIP_LINE_ID
WIP_REPETITIVE_SCHEDULE_ID
WIP_OPERATION_SEQUENCE_NUMBER
WIP_RESOURCE_SEQUENCE_NUMBER
CREATED_DATE
CREATED_BY
LAST_UPDATED_DATE
LAST_UPDATED_BY
OKE_CONTRACT_LINE_ID
OKE_CONTRACT_DELIVERABLE_ID