VIEW: APPS.MRPFV_PLAN_MFG_LINES

Source

View Text - Preformatted

SELECT PA.ORGANIZATION_CODE , AL.NAME , PL.COMPILE_DESIGNATOR , LI.LINE_CODE , '_DF:CRP:CRP_PLANNED_RESOURCES:pl' , PL.ORGANIZATION_ID , PL.LINE_ID , PL.LAST_UPDATE_DATE , PL.LAST_UPDATED_BY , PL.CREATION_DATE , PL.CREATED_BY FROM MTL_PARAMETERS PA ,HR_ALL_ORGANIZATION_UNITS AL ,WIP_LINES LI ,CRP_PLANNED_RESOURCES PL WHERE PL.LINE_ID IS NOT NULL AND PL.LINE_ID = LI.LINE_ID AND PL.ORGANIZATION_ID = LI.ORGANIZATION_ID AND PL.ORGANIZATION_ID = PA.ORGANIZATION_ID AND PL.ORGANIZATION_ID = AL.ORGANIZATION_ID AND '_SEC:PL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT PA.ORGANIZATION_CODE
, AL.NAME
, PL.COMPILE_DESIGNATOR
, LI.LINE_CODE
, '_DF:CRP:CRP_PLANNED_RESOURCES:PL'
, PL.ORGANIZATION_ID
, PL.LINE_ID
, PL.LAST_UPDATE_DATE
, PL.LAST_UPDATED_BY
, PL.CREATION_DATE
, PL.CREATED_BY
FROM MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, WIP_LINES LI
, CRP_PLANNED_RESOURCES PL
WHERE PL.LINE_ID IS NOT NULL
AND PL.LINE_ID = LI.LINE_ID
AND PL.ORGANIZATION_ID = LI.ORGANIZATION_ID
AND PL.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND PL.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND '_SEC:PL.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY