SELECT PASD.PROJ_ASSET_LINE_DTL_UNIQ_ID , PASD.CIP_COST , '_LA:PASD.REVERSED_FLAG:FND_LOOKUPS:YES_NO:MEANING' , PASD.PROJECT_ASSET_LINE_DETAIL_ID , PAS.DESCRIPTION , PASD.EXPENDITURE_ITEM_ID , PASD.LINE_NUM , PASD.LAST_UPDATE_DATE , PASD.LAST_UPDATED_BY , PASD.CREATION_DATE , PASD.CREATED_BY FROM PA_PROJECT_ASSET_LINE_DETAILS PASD , PA_PROJECT_ASSET_LINES_ALL PAS WHERE PASD.PROJECT_ASSET_LINE_DETAIL_ID = PAS.PROJECT_ASSET_LINE_DETAIL_ID AND '_SEC:PAS.ORG_ID' IS NOT NULL WITH READ ONLY