FND Design Data [Home] [Help]

View: POFV_PLAN_PO_DISTRIBUTIONS

Product: PO - Purchasing
Description: - Retrofitted
Implementation/DBA Data: ViewAPPS.POFV_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
, '_DF:PO:PO_DISTRIBUTIONS:PD'
, PD.SET_OF_BOOKS_ID
, SB.NAME
, PD.CODE_COMBINATION_ID
, '_KF:SQLGL:GL#:CC'
, PD.BUDGET_ACCOUNT_ID
, '_KF:SQLGL:GL#:BC'
, PD.ACCRUAL_ACCOUNT_ID
, '_KF:SQLGL:GL#:AC'
, PD.VARIANCE_ACCOUNT_ID
, '_KF:SQLGL:GL#:VC'
, PD.DEST_CHARGE_ACCOUNT_ID
, '_KF:SQLGL:GL#:DC'
, PD.DEST_VARIANCE_ACCOUNT_ID
, '_KF:SQLGL:GL#:DV'
, PD.DELIVER_TO_PERSON_ID
, DP.FULL_NAME
, PD.DELIVER_TO_LOCATION_ID
, LO.LOCATION_CODE
, PD.DESTINATION_ORGANIZATION_ID
, DC.ORGANIZATION_CODE
, DO.NAME
, PD.DESTINATION_SUBINVENTORY
, PD.REQ_DISTRIBUTION_ID
, RH.SEGMENT1
, RL.LINE_NUM
, RD.DISTRIBUTION_NUM
, PD.PROJECT_ID
, PJ.NAME
, PD.TASK_ID
, TK.TASK_NUMBER
, PD.EXPENDITURE_ORGANIZATION_ID
, EC.ORGANIZATION_CODE
, EO.NAME
, PD.BOM_RESOURCE_ID
, BR.RESOURCE_CODE
, PD.WIP_ENTITY_ID
, WE.WIP_ENTITY_NAME
, PD.WIP_LINE_ID
, WL.LINE_CODE
, 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
, OKL.LINE_NUMBER
, OKD.DELIVERABLE_NUM
FROM PO_DISTRIBUTIONS_ALL PD
, PO_LINE_LOCATIONS_ALL PS
, PO_LINES_ALL PL
, PO_HEADERS_ALL PH
, HR_ALL_ORGANIZATION_UNITS OP
, BOM_RESOURCES BR
, GL_SETS_OF_BOOKS SB
, GL_CODE_COMBINATIONS CC
, GL_CODE_COMBINATIONS BC
, GL_CODE_COMBINATIONS AC
, GL_CODE_COMBINATIONS VC
, GL_CODE_COMBINATIONS DC
, GL_CODE_COMBINATIONS DV
, PER_PEOPLE_F DP
, HR_LOCATIONS LO
, MTL_SECONDARY_INVENTORIES SI
, HR_ALL_ORGANIZATION_UNITS DO
, MTL_PARAMETERS DC
, HR_ALL_ORGANIZATION_UNITS EO
, MTL_PARAMETERS EC
, PA_PROJECTS_ALL PJ
, PA_TASKS TK
, PO_REQ_DISTRIBUTIONS_ALL RD
, PO_REQUISITION_HEADERS_ALL RH
, PO_REQUISITION_LINES_ALL RL
, WIP_ENTITIES WE
, WIP_LINES WL
, WIP_OPERATIONS WO
, WIP_OPERATION_RESOURCES WR
, OKC_K_LINES_B OKL
, OKE_K_DELIVERABLES_B OKD
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 PD.SET_OF_BOOKS_ID = SB.SET_OF_BOOKS_ID
AND PD.CODE_COMBINATION_ID = CC.CODE_COMBINATION_ID
AND PD.BUDGET_ACCOUNT_ID = BC.CODE_COMBINATION_ID(+)
AND PD.ACCRUAL_ACCOUNT_ID = AC.CODE_COMBINATION_ID(+)
AND PD.VARIANCE_ACCOUNT_ID = VC.CODE_COMBINATION_ID(+)
AND PD.DEST_CHARGE_ACCOUNT_ID = DC.CODE_COMBINATION_ID(+)
AND PD.DEST_VARIANCE_ACCOUNT_ID = DV.CODE_COMBINATION_ID(+)
AND PD.DELIVER_TO_PERSON_ID = DP.PERSON_ID(+)
AND DP.EFFECTIVE_START_DATE(+) <= TRUNC(SYSDATE)
AND DP.EFFECTIVE_END_DATE(+) >= TRUNC(SYSDATE)
AND PD.DELIVER_TO_LOCATION_ID = LO.LOCATION_ID(+)
AND PD.DESTINATION_SUBINVENTORY = SI.SECONDARY_INVENTORY_NAME(+)
AND PD.DESTINATION_ORGANIZATION_ID = SI.ORGANIZATION_ID(+)
AND PD.DESTINATION_ORGANIZATION_ID = DO.ORGANIZATION_ID(+)
AND PD.DESTINATION_ORGANIZATION_ID = DC.ORGANIZATION_ID(+)
AND PD.EXPENDITURE_ORGANIZATION_ID = EO.ORGANIZATION_ID(+)
AND PD.EXPENDITURE_ORGANIZATION_ID = EC.ORGANIZATION_ID(+)
AND PD.PROJECT_ID = PJ.PROJECT_ID(+)
AND PD.TASK_ID = TK.TASK_ID(+)
AND PD.REQ_DISTRIBUTION_ID = RD.DISTRIBUTION_ID(+)
AND RD.REQUISITION_LINE_ID = RL.REQUISITION_LINE_ID(+)
AND RL.REQUISITION_HEADER_ID = RH.REQUISITION_HEADER_ID(+)
AND PD.BOM_RESOURCE_ID = BR.RESOURCE_ID(+)
AND PD.WIP_ENTITY_ID = WE.WIP_ENTITY_ID(+)
AND PD.DESTINATION_ORGANIZATION_ID = WE.ORGANIZATION_ID(+)
AND PD.WIP_LINE_ID = WL.LINE_ID(+)
AND PD.DESTINATION_ORGANIZATION_ID = WL.ORGANIZATION_ID(+)
AND PD.WIP_ENTITY_ID = WO.WIP_ENTITY_ID(+)
AND PD.DESTINATION_ORGANIZATION_ID = WO.ORGANIZATION_ID(+)
AND PD.WIP_OPERATION_SEQ_NUM = WO.OPERATION_SEQ_NUM(+)
AND PD.WIP_REPETITIVE_SCHEDULE_ID = WO.REPETITIVE_SCHEDULE_ID(+)
AND PD.WIP_ENTITY_ID = WR.WIP_ENTITY_ID(+)
AND PD.DESTINATION_ORGANIZATION_ID = WR.ORGANIZATION_ID(+)
AND PD.WIP_OPERATION_SEQ_NUM = WR.OPERATION_SEQ_NUM(+)
AND PD.WIP_RESOURCE_SEQ_NUM = WR.RESOURCE_SEQ_NUM(+)
AND PD.WIP_REPETITIVE_SCHEDULE_ID = WR.REPETITIVE_SCHEDULE_ID(+)
AND PD.OKE_CONTRACT_LINE_ID= OKL.ID(+)
AND PD.OKE_CONTRACT_DELIVERABLE_ID= OKD.DELIVERABLE_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
"_DF"
SET_OF_BOOKS_ID
SET_OF_BOOKS_NAME
CHARGE_ACCOUNT_ID
"_KF:ACCOUNT_NUM:CHARGE:_CO"
BUDGET_ACCOUNT_ID
"_KF:ACCOUNT_NUM:BUDGET:_CO"
ACCRUAL_ACCOUNT_ID
"_KF:ACCOUNT_NUM:ACCRUAL:_CO"
VARIANCE_ACCOUNT_ID
"_KF:ACCOUNT_NUM:VARIANCE:_CO"
DEST_CHARGE_ACCOUNT_ID
"_KF:ACCOUNT_NUM:DST_CHRG:_CO"
DEST_VARIANCE_ACCOUNT_ID
"_KF:ACCOUNT_NUM:DST_VAR:_CO"
DELIVER_TO_PERSON_ID
DELIVER_TO_PERSON
DELIVER_TO_LOCATION_ID
DELIVER_TO_LOCATION
DESTINATION_ORGANIZATION_ID
DESTINATION_ORGANIZATION_CODE
DESTINATION_ORGANIZATION_NAME
DESTINATION_SUBINVENTORY
REQUISITION_DISTRIBUTION_ID
REQ_DOCUMENT_NUMBER
REQ_LINE_NUMBER
REQ_DISTRIBUTION_NUMBER
PROJECT_ID
PROJECT_NAME
TASK_ID
TASK_NUMBER
EXPENDITURE_ORGANIZATION_ID
EXPENDITURE_ORGANIZATION_CODE
EXPENDITURE_ORGANIZATION_NAME
BILL_OF_MATERIAL_RESOURCE_ID
BILL_OF_MATERIAL_RESOURCE
WIP_ENTITY_ID
WIP_JOB_NAME
WIP_LINE_ID
WIP_LINE_CODE
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
OKE_CONTRACT_LINE_NUM
OKE_CONTRACT_DELIVERABLE_NUM