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.

APPS.FII_GL_SRC_INV_PKG dependencies on FII_FIN_CAT_TYPE_ASSGNS

Line 449: where cat.parent_fin_cat_id in (select fin_category_id from fii_fin_cat_type_assgns where FIN_CAT_TYPE_CODE = 'OE' and TOP_NODE_FLAG = 'Y')

445:
446: select FunctionName into l_FunctionName from
447: (select 'FII_GL_INV_EXP_DET_R' FunctionName
448: from fii_fin_item_hierarchies cat
449: where cat.parent_fin_cat_id in (select fin_category_id from fii_fin_cat_type_assgns where FIN_CAT_TYPE_CODE = 'OE' and TOP_NODE_FLAG = 'Y')
450: and cat.child_fin_cat_id=pCategory
451: union all
452: select 'FII_GL_INV_COR_DET_R' FunctionName
453: from fii_fin_item_hierarchies cat

Line 454: where cat.parent_fin_cat_id in (select fin_category_id from fii_fin_cat_type_assgns where FIN_CAT_TYPE_CODE = 'CGS' and TOP_NODE_FLAG = 'Y')

450: and cat.child_fin_cat_id=pCategory
451: union all
452: select 'FII_GL_INV_COR_DET_R' FunctionName
453: from fii_fin_item_hierarchies cat
454: where cat.parent_fin_cat_id in (select fin_category_id from fii_fin_cat_type_assgns where FIN_CAT_TYPE_CODE = 'CGS' and TOP_NODE_FLAG = 'Y')
455: and cat.child_fin_cat_id=pCategory);
456:
457: bisviewer_pub.showreport(pURLString => 'pFunctionName='||l_FunctionName||'&FII_DIM2='||pCategory||'&FII_DIM7='||
458: pCostCenter||'&FII_DIM9='||pMonth||'&FII_MEASURE9='||pLOB||'&FII_DIM8='||pCurrency||'&FII_DIM1='||pManager||'&pParamIds=Y',

Line 484: where cat.parent_fin_cat_id in (select fin_category_id from fii_fin_cat_type_assgns where FIN_CAT_TYPE_CODE = 'OE' and TOP_NODE_FLAG = 'Y')

480: IF l_fin_leaf_node = 'Y' THEN
481: select FunctionName into l_FunctionName from
482: (select 'FII_GL_INV_EXP_R' FunctionName
483: from fii_fin_item_hierarchies cat
484: where cat.parent_fin_cat_id in (select fin_category_id from fii_fin_cat_type_assgns where FIN_CAT_TYPE_CODE = 'OE' and TOP_NODE_FLAG = 'Y')
485: and cat.child_fin_cat_id=pCategory
486: union all
487: select 'FII_GL_INV_REV_R' FunctionName
488: from fii_fin_item_hierarchies cat

Line 489: where cat.parent_fin_cat_id in (select fin_category_id from fii_fin_cat_type_assgns where FIN_CAT_TYPE_CODE = 'R' and TOP_NODE_FLAG = 'Y')

485: and cat.child_fin_cat_id=pCategory
486: union all
487: select 'FII_GL_INV_REV_R' FunctionName
488: from fii_fin_item_hierarchies cat
489: where cat.parent_fin_cat_id in (select fin_category_id from fii_fin_cat_type_assgns where FIN_CAT_TYPE_CODE = 'R' and TOP_NODE_FLAG = 'Y')
490: and cat.child_fin_cat_id=pCategory
491: union all
492: select 'FII_GL_INV_COR_R' FunctionName
493: from fii_fin_item_hierarchies cat

Line 494: where cat.parent_fin_cat_id in (select fin_category_id from fii_fin_cat_type_assgns where FIN_CAT_TYPE_CODE = 'CGS' and TOP_NODE_FLAG = 'Y')

490: and cat.child_fin_cat_id=pCategory
491: union all
492: select 'FII_GL_INV_COR_R' FunctionName
493: from fii_fin_item_hierarchies cat
494: where cat.parent_fin_cat_id in (select fin_category_id from fii_fin_cat_type_assgns where FIN_CAT_TYPE_CODE = 'CGS' and TOP_NODE_FLAG = 'Y')
495: and cat.child_fin_cat_id=pCategory);
496:
497: bisviewer_pub.showreport(pURLString => 'pFunctionName='||l_FunctionName||'&FII_DIM2='||pCategory||'&FII_DIM8='||
498: pCostCenter||'&FII_DIM9='||pMonth||'&FII_DIM7='||pCurrency||'&FII_DIM1='||pManager||'&FII_MEASURE9='||pLOB||'&AS_OF_DATE='||pAsOfDateValue||

Line 519: where cat.parent_fin_cat_id in (select fin_category_id from fii_fin_cat_type_assgns where FIN_CAT_TYPE_CODE = 'OE' and TOP_NODE_FLAG = 'Y')

515:
516: select FunctionName into l_FunctionName from
517: (select 'FII_GL_INV_EXP_R' FunctionName
518: from fii_fin_item_hierarchies cat
519: where cat.parent_fin_cat_id in (select fin_category_id from fii_fin_cat_type_assgns where FIN_CAT_TYPE_CODE = 'OE' and TOP_NODE_FLAG = 'Y')
520: and cat.child_fin_cat_id=pCategory
521: union all
522: select 'FII_GL_INV_REV_R' FunctionName
523: from fii_fin_item_hierarchies cat

Line 524: where cat.parent_fin_cat_id in (select fin_category_id from fii_fin_cat_type_assgns where FIN_CAT_TYPE_CODE = 'R' and TOP_NODE_FLAG = 'Y')

520: and cat.child_fin_cat_id=pCategory
521: union all
522: select 'FII_GL_INV_REV_R' FunctionName
523: from fii_fin_item_hierarchies cat
524: where cat.parent_fin_cat_id in (select fin_category_id from fii_fin_cat_type_assgns where FIN_CAT_TYPE_CODE = 'R' and TOP_NODE_FLAG = 'Y')
525: and cat.child_fin_cat_id=pCategory
526: union all
527: select 'FII_GL_INV_COR_R' FunctionName
528: from fii_fin_item_hierarchies cat

Line 529: where cat.parent_fin_cat_id in (select fin_category_id from fii_fin_cat_type_assgns where FIN_CAT_TYPE_CODE = 'CGS' and TOP_NODE_FLAG = 'Y')

525: and cat.child_fin_cat_id=pCategory
526: union all
527: select 'FII_GL_INV_COR_R' FunctionName
528: from fii_fin_item_hierarchies cat
529: where cat.parent_fin_cat_id in (select fin_category_id from fii_fin_cat_type_assgns where FIN_CAT_TYPE_CODE = 'CGS' and TOP_NODE_FLAG = 'Y')
530: and cat.child_fin_cat_id=pCategory);
531:
532: bisviewer_pub.showreport(pURLString => 'pFunctionName='||l_FunctionName||'&FII_DIM2='||pCategory||'&FII_DIM8='||
533: pCostCenter||'&FII_DIM9='||pMonth||'&FII_DIM7='||pCurrency||'&FII_DIM1='||pManager||'&FII_MEASURE9='||pLOB||'&AS_OF_DATE='||pAsOfDateValue||