Product: | PO - Purchasing |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.POBV_STD_PO_DISTRIBUTIONS |
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:DESTINATIONTYPE: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
, PS.DROP_SHIP_FLAG
, PS.SALES_ORDER_UPDATE_DATE
, PD.AMOUNT_ORDERED
, PD.AMOUNT_DELIVERED
, PD.AMOUNT_CANCELLED
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 = 'STANDARD'
AND PS.SHIPMENT_TYPE= 'STANDARD'
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