VIEW: APPS.PO_REQ_LINES_REF_V

Source

View Text - Preformatted

SELECT PRL.REQUISITION_LINE_ID , PRL.LINE_NUM, PRL.LINE_TYPE_ID, PLT.LINE_TYPE , PRL.ITEM_DESCRIPTION , PRL.LINE_LOCATION_ID , PRL.BLANKET_PO_HEADER_ID , PRL.BLANKET_PO_LINE_NUM , PRL.DESTINATION_TYPE_CODE , MTLSECINV.ENCUMBRANCE_ACCOUNT, MP.ENCUMBRANCE_ACCOUNT , MSI.ENCUMBRANCE_ACCOUNT , PSP.ACCRUED_CODE_COMBINATION_ID, MP.AP_ACCRUAL_ACCOUNT , MP.INVOICE_PRICE_VAR_ACCOUNT, MSI.COST_OF_SALES_ACCOUNT , MP.EXPENSE_ACCOUNT , MP.MATERIAL_ACCOUNT , MSI.EXPENSE_ACCOUNT , PEC.DEFAULT_CODE_COMBINATION_ID, MSI.INVENTORY_ASSET_FLAG , PRL.DROP_SHIP_FLAG , PRL.DESTINATION_SUBINVENTORY, PRL.DELIVER_TO_LOCATION_ID , PO_LOCATIONS_S.get_location_code(prl.deliver_to_location_id) location_code, PRL.TO_PERSON_ID , HE.FULL_NAME , PRL.ATTRIBUTE_CATEGORY , PRL.ATTRIBUTE1 , PRL.ATTRIBUTE2 , PRL.ATTRIBUTE3 , PRL.ATTRIBUTE4 , PRL.ATTRIBUTE5 , PRL.ATTRIBUTE6 , PRL.ATTRIBUTE7 , PRL.ATTRIBUTE8 , PRL.ATTRIBUTE9 , PRL.ATTRIBUTE10 , PRL.ATTRIBUTE11 , PRL.ATTRIBUTE12 , PRL.ATTRIBUTE13 , PRL.ATTRIBUTE14 , PRL.ATTRIBUTE15 , PRL.GLOBAL_ATTRIBUTE_CATEGORY , PRL.GLOBAL_ATTRIBUTE1 , PRL.GLOBAL_ATTRIBUTE2 , PRL.GLOBAL_ATTRIBUTE3 , PRL.GLOBAL_ATTRIBUTE4 , PRL.GLOBAL_ATTRIBUTE5 , PRL.GLOBAL_ATTRIBUTE6 , PRL.GLOBAL_ATTRIBUTE7 , PRL.GLOBAL_ATTRIBUTE8 , PRL.GLOBAL_ATTRIBUTE9 , PRL.GLOBAL_ATTRIBUTE10 , PRL.GLOBAL_ATTRIBUTE11 , PRL.GLOBAL_ATTRIBUTE12 , PRL.GLOBAL_ATTRIBUTE13 , PRL.GLOBAL_ATTRIBUTE14 , PRL.GLOBAL_ATTRIBUTE15 , PRL.GLOBAL_ATTRIBUTE16 , PRL.GLOBAL_ATTRIBUTE17 , PRL.GLOBAL_ATTRIBUTE18 , PRL.GLOBAL_ATTRIBUTE19 , PRL.GLOBAL_ATTRIBUTE20 , MSI.INVENTORY_ITEM_ID , PRL.ITEM_REVISION , MC.CATEGORY_ID , PRL.ITEM_DESCRIPTION , MC.ATTRIBUTE_CATEGORY, MC.ATTRIBUTE1, MC.ATTRIBUTE2, MC.ATTRIBUTE3, MC.ATTRIBUTE4, MC.ATTRIBUTE5, MC.ATTRIBUTE6, MC.ATTRIBUTE7, MC.ATTRIBUTE8, MC.ATTRIBUTE9, MC.ATTRIBUTE10, MC.ATTRIBUTE11, MC.ATTRIBUTE12, MC.ATTRIBUTE13, MC.ATTRIBUTE14, MC.ATTRIBUTE15, MC.SEGMENT1, MC.SEGMENT2, MC.SEGMENT3, MC.SEGMENT4, MC.SEGMENT5, MC.SEGMENT6, MC.SEGMENT7, MC.SEGMENT8, MC.SEGMENT9, MC.SEGMENT10, MC.SEGMENT11, MC.SEGMENT12, MC.SEGMENT13, MC.SEGMENT14, MC.SEGMENT15, MC.SEGMENT16, MC.SEGMENT17, MC.SEGMENT18, MC.SEGMENT19, MC.SEGMENT20, PLL.SHIP_TO_ORGANIZATION_ID , MP.ORGANIZATION_CODE , PRL.DESTINATION_ORGANIZATION_ID , MP.ORGANIZATION_CODE , PRL.WIP_ENTITY_ID , WE.WIP_ENTITY_NAME , PRL.WIP_LINE_ID , PRL.WIP_OPERATION_SEQ_NUM , PRL.WIP_REPETITIVE_SCHEDULE_ID, PRL.WIP_RESOURCE_SEQ_NUM , PRL.BOM_RESOURCE_ID , BR.RESOURCE_CODE , NVL(PRL.CURRENCY_CODE, GLLED.CURRENCY_CODE), NVL2(PRL.CURRENCY_CODE,PRL.RATE_DATE,SYSDATE), decode(NVL(PRL.CURRENCY_CODE, GLLED.CURRENCY_CODE), GLLED.CURRENCY_CODE, to_number(NULL),NVL(PRL.RATE,1.0)), decode(NVL(PRL.CURRENCY_CODE, GLLED.CURRENCY_CODE), GLLED.CURRENCY_CODE, NULL, NVL( PRL.RATE_TYPE,'User')), PRL.UNIT_PRICE FROM PO_REQUISITION_HEADERS_ALL PRH, PO_REQUISITION_LINES_ALL PRL, PO_LINE_LOCATIONS_ALL PLL, PO_LINE_TYPES PLT, MTL_SYSTEM_ITEMS MSI, MTL_SECONDARY_INVENTORIES MTLSECINV, MTL_PARAMETERS MP, MTL_CATEGORIES MC, MTL_DEFAULT_CATEGORY_SETS MDCS, MTL_ITEM_CATEGORIES MIC, PO_SYSTEM_PARAMETERS_ALL PSP, FINANCIALS_SYSTEM_PARAMS_ALL FSP, GL_LEDGERS GLLED, PER_EMPLOYEES_CURRENT_X PEC, HR_EMPLOYEES HE, WIP_ENTITIES WE, BOM_RESOURCES BR WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID AND PRL.LINE_TYPE_ID = PLT.LINE_TYPE_ID AND PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID(+) AND PRL.ITEM_ID = MSI.INVENTORY_ITEM_ID(+) AND PRL.ORG_ID = MSI.ORGANIZATION_ID(+) AND PRL.CATEGORY_ID = MC.CATEGORY_ID AND PRL.CATEGORY_ID = MIC.CATEGORY_ID(+) AND PRL.ITEM_ID = MIC.INVENTORY_ITEM_ID(+) AND PRL.ORG_ID =MIC.ORGANIZATION_ID(+) AND MDCS.FUNCTIONAL_AREA_ID = 2 AND MIC.CATEGORY_SET_ID = MDCS.CATEGORY_SET_ID AND PRL.ORG_ID = PSP.ORG_ID AND PRL.ORG_ID = FSP.ORG_ID AND FSP.SET_OF_BOOKS_ID = GLLED.LEDGER_ID AND PRL.DESTINATION_ORGANIZATION_ID = MTLSECINV.ORGANIZATION_ID(+) AND PRL.DESTINATION_SUBINVENTORY = MTLSECINV.SECONDARY_INVENTORY_NAME (+) AND PRL.DESTINATION_ORGANIZATION_ID = MP.ORGANIZATION_ID(+) AND PRH.PREPARER_ID = PEC.EMPLOYEE_ID AND PRL.TO_PERSON_ID = HE.EMPLOYEE_ID AND PRL.WIP_ENTITY_ID = WE.WIP_ENTITY_ID(+) AND PRL.BOM_RESOURCE_ID = BR.RESOURCE_ID(+)

View Text - HTML Formatted

SELECT PRL.REQUISITION_LINE_ID
, PRL.LINE_NUM
, PRL.LINE_TYPE_ID
, PLT.LINE_TYPE
, PRL.ITEM_DESCRIPTION
, PRL.LINE_LOCATION_ID
, PRL.BLANKET_PO_HEADER_ID
, PRL.BLANKET_PO_LINE_NUM
, PRL.DESTINATION_TYPE_CODE
, MTLSECINV.ENCUMBRANCE_ACCOUNT
, MP.ENCUMBRANCE_ACCOUNT
, MSI.ENCUMBRANCE_ACCOUNT
, PSP.ACCRUED_CODE_COMBINATION_ID
, MP.AP_ACCRUAL_ACCOUNT
, MP.INVOICE_PRICE_VAR_ACCOUNT
, MSI.COST_OF_SALES_ACCOUNT
, MP.EXPENSE_ACCOUNT
, MP.MATERIAL_ACCOUNT
, MSI.EXPENSE_ACCOUNT
, PEC.DEFAULT_CODE_COMBINATION_ID
, MSI.INVENTORY_ASSET_FLAG
, PRL.DROP_SHIP_FLAG
, PRL.DESTINATION_SUBINVENTORY
, PRL.DELIVER_TO_LOCATION_ID
, PO_LOCATIONS_S.GET_LOCATION_CODE(PRL.DELIVER_TO_LOCATION_ID) LOCATION_CODE
, PRL.TO_PERSON_ID
, HE.FULL_NAME
, PRL.ATTRIBUTE_CATEGORY
, PRL.ATTRIBUTE1
, PRL.ATTRIBUTE2
, PRL.ATTRIBUTE3
, PRL.ATTRIBUTE4
, PRL.ATTRIBUTE5
, PRL.ATTRIBUTE6
, PRL.ATTRIBUTE7
, PRL.ATTRIBUTE8
, PRL.ATTRIBUTE9
, PRL.ATTRIBUTE10
, PRL.ATTRIBUTE11
, PRL.ATTRIBUTE12
, PRL.ATTRIBUTE13
, PRL.ATTRIBUTE14
, PRL.ATTRIBUTE15
, PRL.GLOBAL_ATTRIBUTE_CATEGORY
, PRL.GLOBAL_ATTRIBUTE1
, PRL.GLOBAL_ATTRIBUTE2
, PRL.GLOBAL_ATTRIBUTE3
, PRL.GLOBAL_ATTRIBUTE4
, PRL.GLOBAL_ATTRIBUTE5
, PRL.GLOBAL_ATTRIBUTE6
, PRL.GLOBAL_ATTRIBUTE7
, PRL.GLOBAL_ATTRIBUTE8
, PRL.GLOBAL_ATTRIBUTE9
, PRL.GLOBAL_ATTRIBUTE10
, PRL.GLOBAL_ATTRIBUTE11
, PRL.GLOBAL_ATTRIBUTE12
, PRL.GLOBAL_ATTRIBUTE13
, PRL.GLOBAL_ATTRIBUTE14
, PRL.GLOBAL_ATTRIBUTE15
, PRL.GLOBAL_ATTRIBUTE16
, PRL.GLOBAL_ATTRIBUTE17
, PRL.GLOBAL_ATTRIBUTE18
, PRL.GLOBAL_ATTRIBUTE19
, PRL.GLOBAL_ATTRIBUTE20
, MSI.INVENTORY_ITEM_ID
, PRL.ITEM_REVISION
, MC.CATEGORY_ID
, PRL.ITEM_DESCRIPTION
, MC.ATTRIBUTE_CATEGORY
, MC.ATTRIBUTE1
, MC.ATTRIBUTE2
, MC.ATTRIBUTE3
, MC.ATTRIBUTE4
, MC.ATTRIBUTE5
, MC.ATTRIBUTE6
, MC.ATTRIBUTE7
, MC.ATTRIBUTE8
, MC.ATTRIBUTE9
, MC.ATTRIBUTE10
, MC.ATTRIBUTE11
, MC.ATTRIBUTE12
, MC.ATTRIBUTE13
, MC.ATTRIBUTE14
, MC.ATTRIBUTE15
, MC.SEGMENT1
, MC.SEGMENT2
, MC.SEGMENT3
, MC.SEGMENT4
, MC.SEGMENT5
, MC.SEGMENT6
, MC.SEGMENT7
, MC.SEGMENT8
, MC.SEGMENT9
, MC.SEGMENT10
, MC.SEGMENT11
, MC.SEGMENT12
, MC.SEGMENT13
, MC.SEGMENT14
, MC.SEGMENT15
, MC.SEGMENT16
, MC.SEGMENT17
, MC.SEGMENT18
, MC.SEGMENT19
, MC.SEGMENT20
, PLL.SHIP_TO_ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, PRL.DESTINATION_ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, PRL.WIP_ENTITY_ID
, WE.WIP_ENTITY_NAME
, PRL.WIP_LINE_ID
, PRL.WIP_OPERATION_SEQ_NUM
, PRL.WIP_REPETITIVE_SCHEDULE_ID
, PRL.WIP_RESOURCE_SEQ_NUM
, PRL.BOM_RESOURCE_ID
, BR.RESOURCE_CODE
, NVL(PRL.CURRENCY_CODE
, GLLED.CURRENCY_CODE)
, NVL2(PRL.CURRENCY_CODE
, PRL.RATE_DATE
, SYSDATE)
, DECODE(NVL(PRL.CURRENCY_CODE
, GLLED.CURRENCY_CODE)
, GLLED.CURRENCY_CODE
, TO_NUMBER(NULL)
, NVL(PRL.RATE
, 1.0))
, DECODE(NVL(PRL.CURRENCY_CODE
, GLLED.CURRENCY_CODE)
, GLLED.CURRENCY_CODE
, NULL
, NVL( PRL.RATE_TYPE
, 'USER'))
, PRL.UNIT_PRICE
FROM PO_REQUISITION_HEADERS_ALL PRH
, PO_REQUISITION_LINES_ALL PRL
, PO_LINE_LOCATIONS_ALL PLL
, PO_LINE_TYPES PLT
, MTL_SYSTEM_ITEMS MSI
, MTL_SECONDARY_INVENTORIES MTLSECINV
, MTL_PARAMETERS MP
, MTL_CATEGORIES MC
, MTL_DEFAULT_CATEGORY_SETS MDCS
, MTL_ITEM_CATEGORIES MIC
, PO_SYSTEM_PARAMETERS_ALL PSP
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
, GL_LEDGERS GLLED
, PER_EMPLOYEES_CURRENT_X PEC
, HR_EMPLOYEES HE
, WIP_ENTITIES WE
, BOM_RESOURCES BR
WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
AND PRL.LINE_TYPE_ID = PLT.LINE_TYPE_ID
AND PRL.LINE_LOCATION_ID = PLL.LINE_LOCATION_ID(+)
AND PRL.ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND PRL.ORG_ID = MSI.ORGANIZATION_ID(+)
AND PRL.CATEGORY_ID = MC.CATEGORY_ID
AND PRL.CATEGORY_ID = MIC.CATEGORY_ID(+)
AND PRL.ITEM_ID = MIC.INVENTORY_ITEM_ID(+)
AND PRL.ORG_ID =MIC.ORGANIZATION_ID(+)
AND MDCS.FUNCTIONAL_AREA_ID = 2
AND MIC.CATEGORY_SET_ID = MDCS.CATEGORY_SET_ID
AND PRL.ORG_ID = PSP.ORG_ID
AND PRL.ORG_ID = FSP.ORG_ID
AND FSP.SET_OF_BOOKS_ID = GLLED.LEDGER_ID
AND PRL.DESTINATION_ORGANIZATION_ID = MTLSECINV.ORGANIZATION_ID(+)
AND PRL.DESTINATION_SUBINVENTORY = MTLSECINV.SECONDARY_INVENTORY_NAME (+)
AND PRL.DESTINATION_ORGANIZATION_ID = MP.ORGANIZATION_ID(+)
AND PRH.PREPARER_ID = PEC.EMPLOYEE_ID
AND PRL.TO_PERSON_ID = HE.EMPLOYEE_ID
AND PRL.WIP_ENTITY_ID = WE.WIP_ENTITY_ID(+)
AND PRL.BOM_RESOURCE_ID = BR.RESOURCE_ID(+)