VIEW: APPS.POBV_SCHEDULED_DISTRIBUTIONS

Source

View Text - Preformatted

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, PD.QUANTITY_FINANCED, PD.AMOUNT_FINANCED, PD.QUANTITY_RECOUPED, PD.AMOUNT_RECOUPED, PD.RETAINAGE_WITHHELD_AMOUNT, PD.RETAINAGE_RELEASED_AMOUNT, PD.TAX_ATTRIBUTE_UPDATE_CODE 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 WITH READ ONLY

View Text - HTML Formatted

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
, PD.QUANTITY_FINANCED
, PD.AMOUNT_FINANCED
, PD.QUANTITY_RECOUPED
, PD.AMOUNT_RECOUPED
, PD.RETAINAGE_WITHHELD_AMOUNT
, PD.RETAINAGE_RELEASED_AMOUNT
, PD.TAX_ATTRIBUTE_UPDATE_CODE
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 WITH READ ONLY