View: QAFV_COLLECTION_PLANS

Product:	QA - Quality
Description:	- Retrofitted
Implementation/DBA Data:	APPS.QAFV_COLLECTION_PLANS

View Text

SELECT COLLECTION_PLAN.PLAN_ID PLAN_ID
, COLLECTION_PLAN.NAME COLLECTION_PLAN_NAME
, COLLECTION_PLAN.DESCRIPTION DESCRIPTION
, COLLECTION_PLAN.EFFECTIVE_FROM START_EFFECTIVE_DATE
, COLLECTION_PLAN.EFFECTIVE_TO END_EFFECTIVE_DATE
, FN.MEANING PLAN_TYPE
, MF.MEANING SPECIFICATION_ASSIGNMENT_TYPE
, COLLECTION_PLAN.ORGANIZATION_ID ORGANIZATION_ID
, PA.ORGANIZATION_CODE ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, COLLECTION_PLAN.LAST_UPDATE_DATE
, COLLECTION_PLAN.LAST_UPDATED_BY
, COLLECTION_PLAN.CREATION_DATE
, COLLECTION_PLAN.CREATED_BY
FROM QA_PLANS COLLECTION_PLAN
, MFG_LOOKUPS MF
, MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, FND_COMMON_LOOKUPS FN
WHERE MF.LOOKUP_TYPE = 'QA_PLAN_SPEC_TYPE'
AND MF.LOOKUP_CODE = COLLECTION_PLAN.SPEC_ASSIGNMENT_TYPE
AND FN.LOOKUP_TYPE = 'COLLECTION_PLAN_TYPE'
AND FN.LOOKUP_CODE = COLLECTION_PLAN.PLAN_TYPE_CODE
AND FN.APPLICATION_ID = 250
AND AL.ORGANIZATION_ID (+) = COLLECTION_PLAN.ORGANIZATION_ID
AND PA.ORGANIZATION_ID (+) = COLLECTION_PLAN.ORGANIZATION_ID WITH READ ONLY

Columns