VIEW: APPS.PO_DISTS_REF_V

Source

View Text - Preformatted

SELECT PD.PO_DISTRIBUTION_ID, PD.DISTRIBUTION_NUM, PD.DISTRIBUTION_TYPE, PD.LINE_LOCATION_ID, PLL.SHIPMENT_NUM, PD.PO_LINE_ID, PD.PO_HEADER_ID, PD.GL_ENCUMBERED_DATE, PLL.TRANSACTION_FLOW_HEADER_ID, PD.DESTINATION_TYPE_CODE, MTLSECINV.ENCUMBRANCE_ACCOUNT, PD.CODE_COMBINATION_ID, PD.BUDGET_ACCOUNT_ID, PD.BUDGET_ACCOUNT_ID, MP.ENCUMBRANCE_ACCOUNT, PSP.ACCRUED_CODE_COMBINATION_ID, MP.AP_ACCRUAL_ACCOUNT, MP.INVOICE_PRICE_VAR_ACCOUNT, MP.EXPENSE_ACCOUNT, MP.MATERIAL_ACCOUNT, NVL(PLL.DROP_SHIP_FLAG,'N'), PD.SOURCE_DISTRIBUTION_ID, PD.PROJECT_ID, PP.NAME, PD.TASK_ID, PT.TASK_NAME, PD.EXPENDITURE_ORGANIZATION_ID, HOU.NAME, PD.EXPENDITURE_TYPE, PD.EXPENDITURE_ITEM_DATE, PD.AWARD_ID, GA.AWARD_NUMBER, PD.DESTINATION_SUBINVENTORY, PD.DELIVER_TO_LOCATION_ID, PO_LOCATIONS_S.get_location_code(pd.deliver_to_location_id) LOCATION_CODE, PD.DELIVER_TO_PERSON_ID, (SELECT HE.FULL_NAME FROM HR_EMPLOYEES HE WHERE PD.DELIVER_TO_PERSON_ID = HE.EMPLOYEE_ID) FULL_NAME, NVL(PD.ACCRUE_ON_RECEIPT_FLAG,'N'), NVL(PD.PREVENT_ENCUMBRANCE_FLAG,'N'), NVL(PD.ENCUMBERED_FLAG,'N'), PD.ATTRIBUTE_CATEGORY, PD.ATTRIBUTE1, PD.ATTRIBUTE2, PD.ATTRIBUTE3, PD.ATTRIBUTE4, PD.ATTRIBUTE5, PD.ATTRIBUTE6, PD.ATTRIBUTE7, PD.ATTRIBUTE8, PD.ATTRIBUTE9, PD.ATTRIBUTE10, PD.ATTRIBUTE11, PD.ATTRIBUTE12, PD.ATTRIBUTE13, PD.ATTRIBUTE14, PD.ATTRIBUTE15, PD.ORG_ID, HOU.NAME, PLL.SHIP_TO_ORGANIZATION_ID, MP.ORGANIZATION_CODE, PD.DESTINATION_ORGANIZATION_ID, MP.ORGANIZATION_CODE, PD.WIP_ENTITY_ID, WE.WIP_ENTITY_NAME, PD.WIP_LINE_ID, PD.WIP_OPERATION_SEQ_NUM, PD.WIP_REPETITIVE_SCHEDULE_ID, PD.BOM_RESOURCE_ID, BR.RESOURCE_CODE, PD.SET_OF_BOOKS_ID, GLSOB.CURRENCY_CODE, PH.CURRENCY_CODE, PD.RATE_DATE, decode(PH.CURRENCY_CODE,GLSOB.CURRENCY_CODE, to_number(NULL),NVL(PD.RATE,1.0)), decode(PH.CURRENCY_CODE,GLSOB.CURRENCY_CODE, NULL,NVL(PH.RATE_TYPE,'User')), PD.RATE_DATE, decode(PH.CURRENCY_CODE,GLSOB.CURRENCY_CODE, to_number(NULL),NVL(PD.RATE,1.0)), decode(PH.CURRENCY_CODE,GLSOB.CURRENCY_CODE, NULL,NVL(PH.RATE_TYPE,'User')), PD.QUANTITY_ORDERED, PD.QUANTITY_DELIVERED, PD.QUANTITY_ORDERED * PLL.QUANTITY_RECEIVED/PLL.QUANTITY, PD.QUANTITY_ORDERED * PLL.QUANTITY_ACCEPTED/PLL.QUANTITY, PD.QUANTITY_ORDERED * PLL.QUANTITY_REJECTED/PLL.QUANTITY, PD.QUANTITY_BILLED, PD.QUANTITY_CANCELLED, PD.QUANTITY_FINANCED, PL.UNIT_PRICE, DECODE(PD.AMOUNT_DELIVERED, 0, PD.QUANTITY_DELIVERED * PLL.PRICE_OVERRIDE, NULL, PD.QUANTITY_DELIVERED * PLL.PRICE_OVERRIDE, PD.AMOUNT_DELIVERED), DECODE(PD.AMOUNT_DELIVERED, 0, PD.QUANTITY_DELIVERED * PLL.PRICE_OVERRIDE* NVL(PD.RATE,1), NULL, PD.QUANTITY_DELIVERED * PLL.PRICE_OVERRIDE* NVL(PD.RATE,1), PD.AMOUNT_DELIVERED*NVL(PD.RATE,1)) , DECODE(PD.AMOUNT_ORDERED, 0, PD.QUANTITY_ORDERED * PLL.PRICE_OVERRIDE,NULL, PD.QUANTITY_ORDERED * PLL.PRICE_OVERRIDE, PD.AMOUNT_ORDERED), DECODE(PD.AMOUNT_ORDERED, 0, PD.QUANTITY_ORDERED * PLL.PRICE_OVERRIDE* NVL(PD.RATE,1), NULL, PD.QUANTITY_ORDERED * PLL.PRICE_OVERRIDE* NVL(PD.RATE,1), PD.AMOUNT_ORDERED*NVL(PD.RATE,1)), PD.QUANTITY_ORDERED * PLL.AMOUNT_RECEIVED/PLL.QUANTITY, PD.QUANTITY_ORDERED * PLL.AMOUNT_ACCEPTED/PLL.QUANTITY, PD.QUANTITY_ORDERED * PLL.AMOUNT_REJECTED/PLL.QUANTITY, DECODE(PD.AMOUNT_BILLED, 0, PD.QUANTITY_BILLED * PLL.PRICE_OVERRIDE,NULL, PD.QUANTITY_BILLED * PLL.PRICE_OVERRIDE, PD.AMOUNT_BILLED) , DECODE(PD.AMOUNT_BILLED, 0, PD.QUANTITY_BILLED * PLL.PRICE_OVERRIDE* NVL(PD.RATE,1), NULL, PD.QUANTITY_BILLED * PLL.PRICE_OVERRIDE* NVL(PD.RATE,1), PD.AMOUNT_BILLED*NVL(PD.RATE,1)), PD.AMOUNT_CANCELLED, PD.AMOUNT_FINANCED, PD.AMOUNT_TO_ENCUMBER FROM PO_DISTRIBUTIONS_ALL PD, PO_LINES_ALL PL, PO_HEADERS_ALL PH, PO_LINE_LOCATIONS_ALL PLL, MTL_SECONDARY_INVENTORIES MTLSECINV, MTL_PARAMETERS MP, PO_SYSTEM_PARAMETERS_ALL PSP, PA_PROJECTS_ALL PP, PA_TASKS PT, GMS_AWARDS_ALL GA, HR_ALL_ORGANIZATION_UNITS_TL HOU, WIP_ENTITIES WE, BOM_RESOURCES BR, GL_SETS_OF_BOOKS GLSOB WHERE PD.PO_LINE_ID= PL.PO_LINE_ID (+) AND PD.PO_HEADER_ID = PH.PO_HEADER_ID AND PD.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID(+) AND PD.DESTINATION_ORGANIZATION_ID = MTLSECINV.ORGANIZATION_ID(+) AND PD.DESTINATION_SUBINVENTORY = MTLSECINV.SECONDARY_INVENTORY_NAME(+) AND PD.DESTINATION_ORGANIZATION_ID = MP.ORGANIZATION_ID(+) AND PD.ORG_ID = PSP.ORG_ID AND PD.PROJECT_ID = PP.PROJECT_ID(+) AND PD.TASK_ID = PT.TASK_ID(+) AND PD.AWARD_ID = GA.AWARD_ID(+) AND PD.ORG_ID = HOU.ORGANIZATION_ID AND HOU.LANGUAGE = USERENV('LANG') AND PD.WIP_ENTITY_ID = WE.WIP_ENTITY_ID(+) AND PD.BOM_RESOURCE_ID = BR.RESOURCE_ID(+) AND PD.SET_OF_BOOKS_ID = GLSOB.SET_OF_BOOKS_ID

View Text - HTML Formatted

SELECT PD.PO_DISTRIBUTION_ID
, PD.DISTRIBUTION_NUM
, PD.DISTRIBUTION_TYPE
, PD.LINE_LOCATION_ID
, PLL.SHIPMENT_NUM
, PD.PO_LINE_ID
, PD.PO_HEADER_ID
, PD.GL_ENCUMBERED_DATE
, PLL.TRANSACTION_FLOW_HEADER_ID
, PD.DESTINATION_TYPE_CODE
, MTLSECINV.ENCUMBRANCE_ACCOUNT
, PD.CODE_COMBINATION_ID
, PD.BUDGET_ACCOUNT_ID
, PD.BUDGET_ACCOUNT_ID
, MP.ENCUMBRANCE_ACCOUNT
, PSP.ACCRUED_CODE_COMBINATION_ID
, MP.AP_ACCRUAL_ACCOUNT
, MP.INVOICE_PRICE_VAR_ACCOUNT
, MP.EXPENSE_ACCOUNT
, MP.MATERIAL_ACCOUNT
, NVL(PLL.DROP_SHIP_FLAG
, 'N')
, PD.SOURCE_DISTRIBUTION_ID
, PD.PROJECT_ID
, PP.NAME
, PD.TASK_ID
, PT.TASK_NAME
, PD.EXPENDITURE_ORGANIZATION_ID
, HOU.NAME
, PD.EXPENDITURE_TYPE
, PD.EXPENDITURE_ITEM_DATE
, PD.AWARD_ID
, GA.AWARD_NUMBER
, PD.DESTINATION_SUBINVENTORY
, PD.DELIVER_TO_LOCATION_ID
, PO_LOCATIONS_S.GET_LOCATION_CODE(PD.DELIVER_TO_LOCATION_ID) LOCATION_CODE
, PD.DELIVER_TO_PERSON_ID
, (SELECT HE.FULL_NAME
FROM HR_EMPLOYEES HE
WHERE PD.DELIVER_TO_PERSON_ID = HE.EMPLOYEE_ID) FULL_NAME
, NVL(PD.ACCRUE_ON_RECEIPT_FLAG
, 'N')
, NVL(PD.PREVENT_ENCUMBRANCE_FLAG
, 'N')
, NVL(PD.ENCUMBERED_FLAG
, 'N')
, PD.ATTRIBUTE_CATEGORY
, PD.ATTRIBUTE1
, PD.ATTRIBUTE2
, PD.ATTRIBUTE3
, PD.ATTRIBUTE4
, PD.ATTRIBUTE5
, PD.ATTRIBUTE6
, PD.ATTRIBUTE7
, PD.ATTRIBUTE8
, PD.ATTRIBUTE9
, PD.ATTRIBUTE10
, PD.ATTRIBUTE11
, PD.ATTRIBUTE12
, PD.ATTRIBUTE13
, PD.ATTRIBUTE14
, PD.ATTRIBUTE15
, PD.ORG_ID
, HOU.NAME
, PLL.SHIP_TO_ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, PD.DESTINATION_ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, PD.WIP_ENTITY_ID
, WE.WIP_ENTITY_NAME
, PD.WIP_LINE_ID
, PD.WIP_OPERATION_SEQ_NUM
, PD.WIP_REPETITIVE_SCHEDULE_ID
, PD.BOM_RESOURCE_ID
, BR.RESOURCE_CODE
, PD.SET_OF_BOOKS_ID
, GLSOB.CURRENCY_CODE
, PH.CURRENCY_CODE
, PD.RATE_DATE
, DECODE(PH.CURRENCY_CODE
, GLSOB.CURRENCY_CODE
, TO_NUMBER(NULL)
, NVL(PD.RATE
, 1.0))
, DECODE(PH.CURRENCY_CODE
, GLSOB.CURRENCY_CODE
, NULL
, NVL(PH.RATE_TYPE
, 'USER'))
, PD.RATE_DATE
, DECODE(PH.CURRENCY_CODE
, GLSOB.CURRENCY_CODE
, TO_NUMBER(NULL)
, NVL(PD.RATE
, 1.0))
, DECODE(PH.CURRENCY_CODE
, GLSOB.CURRENCY_CODE
, NULL
, NVL(PH.RATE_TYPE
, 'USER'))
, PD.QUANTITY_ORDERED
, PD.QUANTITY_DELIVERED
, PD.QUANTITY_ORDERED * PLL.QUANTITY_RECEIVED/PLL.QUANTITY
, PD.QUANTITY_ORDERED * PLL.QUANTITY_ACCEPTED/PLL.QUANTITY
, PD.QUANTITY_ORDERED * PLL.QUANTITY_REJECTED/PLL.QUANTITY
, PD.QUANTITY_BILLED
, PD.QUANTITY_CANCELLED
, PD.QUANTITY_FINANCED
, PL.UNIT_PRICE
, DECODE(PD.AMOUNT_DELIVERED
, 0
, PD.QUANTITY_DELIVERED * PLL.PRICE_OVERRIDE
, NULL
, PD.QUANTITY_DELIVERED * PLL.PRICE_OVERRIDE
, PD.AMOUNT_DELIVERED)
, DECODE(PD.AMOUNT_DELIVERED
, 0
, PD.QUANTITY_DELIVERED * PLL.PRICE_OVERRIDE* NVL(PD.RATE
, 1)
, NULL
, PD.QUANTITY_DELIVERED * PLL.PRICE_OVERRIDE* NVL(PD.RATE
, 1)
, PD.AMOUNT_DELIVERED*NVL(PD.RATE
, 1))
, DECODE(PD.AMOUNT_ORDERED
, 0
, PD.QUANTITY_ORDERED * PLL.PRICE_OVERRIDE
, NULL
, PD.QUANTITY_ORDERED * PLL.PRICE_OVERRIDE
, PD.AMOUNT_ORDERED)
, DECODE(PD.AMOUNT_ORDERED
, 0
, PD.QUANTITY_ORDERED * PLL.PRICE_OVERRIDE* NVL(PD.RATE
, 1)
, NULL
, PD.QUANTITY_ORDERED * PLL.PRICE_OVERRIDE* NVL(PD.RATE
, 1)
, PD.AMOUNT_ORDERED*NVL(PD.RATE
, 1))
, PD.QUANTITY_ORDERED * PLL.AMOUNT_RECEIVED/PLL.QUANTITY
, PD.QUANTITY_ORDERED * PLL.AMOUNT_ACCEPTED/PLL.QUANTITY
, PD.QUANTITY_ORDERED * PLL.AMOUNT_REJECTED/PLL.QUANTITY
, DECODE(PD.AMOUNT_BILLED
, 0
, PD.QUANTITY_BILLED * PLL.PRICE_OVERRIDE
, NULL
, PD.QUANTITY_BILLED * PLL.PRICE_OVERRIDE
, PD.AMOUNT_BILLED)
, DECODE(PD.AMOUNT_BILLED
, 0
, PD.QUANTITY_BILLED * PLL.PRICE_OVERRIDE* NVL(PD.RATE
, 1)
, NULL
, PD.QUANTITY_BILLED * PLL.PRICE_OVERRIDE* NVL(PD.RATE
, 1)
, PD.AMOUNT_BILLED*NVL(PD.RATE
, 1))
, PD.AMOUNT_CANCELLED
, PD.AMOUNT_FINANCED
, PD.AMOUNT_TO_ENCUMBER
FROM PO_DISTRIBUTIONS_ALL PD
, PO_LINES_ALL PL
, PO_HEADERS_ALL PH
, PO_LINE_LOCATIONS_ALL PLL
, MTL_SECONDARY_INVENTORIES MTLSECINV
, MTL_PARAMETERS MP
, PO_SYSTEM_PARAMETERS_ALL PSP
, PA_PROJECTS_ALL PP
, PA_TASKS PT
, GMS_AWARDS_ALL GA
, HR_ALL_ORGANIZATION_UNITS_TL HOU
, WIP_ENTITIES WE
, BOM_RESOURCES BR
, GL_SETS_OF_BOOKS GLSOB
WHERE PD.PO_LINE_ID= PL.PO_LINE_ID (+)
AND PD.PO_HEADER_ID = PH.PO_HEADER_ID
AND PD.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID(+)
AND PD.DESTINATION_ORGANIZATION_ID = MTLSECINV.ORGANIZATION_ID(+)
AND PD.DESTINATION_SUBINVENTORY = MTLSECINV.SECONDARY_INVENTORY_NAME(+)
AND PD.DESTINATION_ORGANIZATION_ID = MP.ORGANIZATION_ID(+)
AND PD.ORG_ID = PSP.ORG_ID
AND PD.PROJECT_ID = PP.PROJECT_ID(+)
AND PD.TASK_ID = PT.TASK_ID(+)
AND PD.AWARD_ID = GA.AWARD_ID(+)
AND PD.ORG_ID = HOU.ORGANIZATION_ID
AND HOU.LANGUAGE = USERENV('LANG')
AND PD.WIP_ENTITY_ID = WE.WIP_ENTITY_ID(+)
AND PD.BOM_RESOURCE_ID = BR.RESOURCE_ID(+)
AND PD.SET_OF_BOOKS_ID = GLSOB.SET_OF_BOOKS_ID