FND Design Data [Home] [Help]

View: POBV_PLAN_PO_DISTRIBUTIONS

Product: PO - Purchasing
Description: - Retrofitted
Implementation/DBA Data: ViewAPPS.POBV_PLAN_PO_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.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
, HR_ALL_ORGANIZATION_UNITS OP
WHERE PH.TYPE_LOOKUP_CODE = 'PLANNED'
AND PS.SHIPMENT_TYPE = 'PLANNED'
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.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
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