VIEW: APPS.POFV_PLAN_PO_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.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, 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, 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(+) 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.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
, 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
, 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(+) WITH READ ONLY