eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.QABV_COLLECTION_PLANS

Source

View Text - Preformatted


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 , 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, 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 with read only

View Text - HTML Formatted

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
, 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
, 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 WITH READ ONLY