VIEW: APPS.PO_LINES_REF_V

Source

View Text - Preformatted

SELECT PL.PO_LINE_ID, PL.LINE_NUM, PLT.LINE_TYPE, PL.ITEM_DESCRIPTION, PL.PO_HEADER_ID, MSI.COST_OF_SALES_ACCOUNT, MSI.EXPENSE_ACCOUNT, PEC.DEFAULT_CODE_COMBINATION_ID, MSI.ENCUMBRANCE_ACCOUNT, MSI.INVENTORY_ASSET_FLAG, PL.FROM_HEADER_ID, PL.FROM_LINE_ID, PL.ATTRIBUTE_CATEGORY, PL.ATTRIBUTE1, PL.ATTRIBUTE2, PL.ATTRIBUTE3, PL.ATTRIBUTE4, PL.ATTRIBUTE5, PL.ATTRIBUTE6, PL.ATTRIBUTE7, PL.ATTRIBUTE8, PL.ATTRIBUTE9, PL.ATTRIBUTE10, PL.ATTRIBUTE11, PL.ATTRIBUTE12, PL.ATTRIBUTE13, PL.ATTRIBUTE14, PL.ATTRIBUTE15, PL.GLOBAL_ATTRIBUTE_CATEGORY, PL.GLOBAL_ATTRIBUTE1 , PL.GLOBAL_ATTRIBUTE2 , PL.GLOBAL_ATTRIBUTE3 , PL.GLOBAL_ATTRIBUTE4 , PL.GLOBAL_ATTRIBUTE5 , PL.GLOBAL_ATTRIBUTE6 , PL.GLOBAL_ATTRIBUTE7 , PL.GLOBAL_ATTRIBUTE8 , PL.GLOBAL_ATTRIBUTE9 , PL.GLOBAL_ATTRIBUTE10 , PL.GLOBAL_ATTRIBUTE11 , PL.GLOBAL_ATTRIBUTE12 , PL.GLOBAL_ATTRIBUTE13 , PL.GLOBAL_ATTRIBUTE14 , PL.GLOBAL_ATTRIBUTE15 , PL.GLOBAL_ATTRIBUTE16 , PL.GLOBAL_ATTRIBUTE17 , PL.GLOBAL_ATTRIBUTE18 , PL.GLOBAL_ATTRIBUTE19 , PL.GLOBAL_ATTRIBUTE20 , MSI.INVENTORY_ITEM_ID , PL.ITEM_REVISION , PL.CATEGORY_ID , PL.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, PL.UNIT_PRICE, PSP.EXPENSE_ACCRUAL_CODE FROM PO_HEADERS_ALL PH, PO_LINES_ALL PL, PO_LINE_TYPES PLT, MTL_SYSTEM_ITEMS MSI, PO_SYSTEM_PARAMETERS_ALL PSP, PER_EMPLOYEES_CURRENT_X PEC, MTL_CATEGORIES MC, MTL_DEFAULT_CATEGORY_SETS MDCS, MTL_ITEM_CATEGORIES MIC WHERE PL.PO_HEADER_ID = PH.PO_HEADER_ID AND PL.LINE_TYPE_ID = PLT.LINE_TYPE_ID AND PL.ITEM_ID = MSI.INVENTORY_ITEM_ID(+) AND PL.ORG_ID = MSI.ORGANIZATION_ID(+) AND PL.ORG_ID = PSP.ORG_ID AND PH.AGENT_ID = PEC.EMPLOYEE_ID AND PL.CATEGORY_ID = MC.CATEGORY_ID(+) AND PL.CATEGORY_ID = MIC.CATEGORY_ID(+) AND PL.ITEM_ID = MIC.INVENTORY_ITEM_ID(+) AND PL.ORG_ID = MIC.ORGANIZATION_ID(+) AND MDCS.FUNCTIONAL_AREA_ID(+) = 2 AND MIC.CATEGORY_SET_ID = MDCS.CATEGORY_SET_ID(+)

View Text - HTML Formatted

SELECT PL.PO_LINE_ID
, PL.LINE_NUM
, PLT.LINE_TYPE
, PL.ITEM_DESCRIPTION
, PL.PO_HEADER_ID
, MSI.COST_OF_SALES_ACCOUNT
, MSI.EXPENSE_ACCOUNT
, PEC.DEFAULT_CODE_COMBINATION_ID
, MSI.ENCUMBRANCE_ACCOUNT
, MSI.INVENTORY_ASSET_FLAG
, PL.FROM_HEADER_ID
, PL.FROM_LINE_ID
, PL.ATTRIBUTE_CATEGORY
, PL.ATTRIBUTE1
, PL.ATTRIBUTE2
, PL.ATTRIBUTE3
, PL.ATTRIBUTE4
, PL.ATTRIBUTE5
, PL.ATTRIBUTE6
, PL.ATTRIBUTE7
, PL.ATTRIBUTE8
, PL.ATTRIBUTE9
, PL.ATTRIBUTE10
, PL.ATTRIBUTE11
, PL.ATTRIBUTE12
, PL.ATTRIBUTE13
, PL.ATTRIBUTE14
, PL.ATTRIBUTE15
, PL.GLOBAL_ATTRIBUTE_CATEGORY
, PL.GLOBAL_ATTRIBUTE1
, PL.GLOBAL_ATTRIBUTE2
, PL.GLOBAL_ATTRIBUTE3
, PL.GLOBAL_ATTRIBUTE4
, PL.GLOBAL_ATTRIBUTE5
, PL.GLOBAL_ATTRIBUTE6
, PL.GLOBAL_ATTRIBUTE7
, PL.GLOBAL_ATTRIBUTE8
, PL.GLOBAL_ATTRIBUTE9
, PL.GLOBAL_ATTRIBUTE10
, PL.GLOBAL_ATTRIBUTE11
, PL.GLOBAL_ATTRIBUTE12
, PL.GLOBAL_ATTRIBUTE13
, PL.GLOBAL_ATTRIBUTE14
, PL.GLOBAL_ATTRIBUTE15
, PL.GLOBAL_ATTRIBUTE16
, PL.GLOBAL_ATTRIBUTE17
, PL.GLOBAL_ATTRIBUTE18
, PL.GLOBAL_ATTRIBUTE19
, PL.GLOBAL_ATTRIBUTE20
, MSI.INVENTORY_ITEM_ID
, PL.ITEM_REVISION
, PL.CATEGORY_ID
, PL.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
, PL.UNIT_PRICE
, PSP.EXPENSE_ACCRUAL_CODE
FROM PO_HEADERS_ALL PH
, PO_LINES_ALL PL
, PO_LINE_TYPES PLT
, MTL_SYSTEM_ITEMS MSI
, PO_SYSTEM_PARAMETERS_ALL PSP
, PER_EMPLOYEES_CURRENT_X PEC
, MTL_CATEGORIES MC
, MTL_DEFAULT_CATEGORY_SETS MDCS
, MTL_ITEM_CATEGORIES MIC
WHERE PL.PO_HEADER_ID = PH.PO_HEADER_ID
AND PL.LINE_TYPE_ID = PLT.LINE_TYPE_ID
AND PL.ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND PL.ORG_ID = MSI.ORGANIZATION_ID(+)
AND PL.ORG_ID = PSP.ORG_ID
AND PH.AGENT_ID = PEC.EMPLOYEE_ID
AND PL.CATEGORY_ID = MC.CATEGORY_ID(+)
AND PL.CATEGORY_ID = MIC.CATEGORY_ID(+)
AND PL.ITEM_ID = MIC.INVENTORY_ITEM_ID(+)
AND PL.ORG_ID = MIC.ORGANIZATION_ID(+)
AND MDCS.FUNCTIONAL_AREA_ID(+) = 2
AND MIC.CATEGORY_SET_ID = MDCS.CATEGORY_SET_ID(+)