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.ISC_DEPOT_RPT_UTIL_PKG dependencies on FND_GLOBAL

Line 391: x_mv := 'CSD_REPAIR_TYPES_VL CRT ,' || fnd_global.newline;

387:
388: -- In case of Detail Report, CSD_REPAIR_TYPES_VL is always selected.
389: IF (p_rtype_flag = 'Y' or p_mv_set in('MRGN_DTL','MDTL','BKLDTL1','BKLDTL2',
390: 'CMPDTL1','CMPDTL2' )) THEN
391: x_mv := 'CSD_REPAIR_TYPES_VL CRT ,' || fnd_global.newline;
392: END IF;
393:
394: IF ( p_pcategory_flag = 'Y' ) THEN -- to check if product category is selected
395: x_mv_type := 'INLINE';

Line 396: x_mv := x_mv || 'ENI_DENORM_HIERARCHIES V, ' || fnd_global.newline ||

392: END IF;
393:
394: IF ( p_pcategory_flag = 'Y' ) THEN -- to check if product category is selected
395: x_mv_type := 'INLINE';
396: x_mv := x_mv || 'ENI_DENORM_HIERARCHIES V, ' || fnd_global.newline ||
397: 'MTL_DEFAULT_CATEGORY_SETS M , ' || fnd_global.newline;
398:
399: -- The following table and where condition would be for the Margin Detail report.
400: -- Since the Detail reports refer to the fact tables and product category is not available in the

Line 397: 'MTL_DEFAULT_CATEGORY_SETS M , ' || fnd_global.newline;

393:
394: IF ( p_pcategory_flag = 'Y' ) THEN -- to check if product category is selected
395: x_mv_type := 'INLINE';
396: x_mv := x_mv || 'ENI_DENORM_HIERARCHIES V, ' || fnd_global.newline ||
397: 'MTL_DEFAULT_CATEGORY_SETS M , ' || fnd_global.newline;
398:
399: -- The following table and where condition would be for the Margin Detail report.
400: -- Since the Detail reports refer to the fact tables and product category is not available in the
401: -- fact, we join with the ENI_OLTP_ITEM_STAR.

Line 535: x_where_clause := x_where_clause || ' and m.functional_area_id = 11 ' || fnd_global.newline

531:
532: IF p_pcategory_flag = 'Y' THEN
533: -- For Margin Detail Report eni_oltp_item_star.vbh_category_id is used.
534: IF (p_mv_set IN ('MRGN_DTL', 'MDTL', 'CMPDTL2', 'CMPDTL1')) THEN
535: x_where_clause := x_where_clause || ' and m.functional_area_id = 11 ' || fnd_global.newline
536: || ' and v.object_id = m.category_set_id ' || fnd_global.newline
537: || ' and v.dbi_flag = ''Y'' ' || fnd_global.newline
538: || ' and v.object_type = ''CATEGORY_SET'' ' || fnd_global.newline
539: || ' and items.vbh_category_id = v.child_id ' || fnd_global.newline

Line 536: || ' and v.object_id = m.category_set_id ' || fnd_global.newline

532: IF p_pcategory_flag = 'Y' THEN
533: -- For Margin Detail Report eni_oltp_item_star.vbh_category_id is used.
534: IF (p_mv_set IN ('MRGN_DTL', 'MDTL', 'CMPDTL2', 'CMPDTL1')) THEN
535: x_where_clause := x_where_clause || ' and m.functional_area_id = 11 ' || fnd_global.newline
536: || ' and v.object_id = m.category_set_id ' || fnd_global.newline
537: || ' and v.dbi_flag = ''Y'' ' || fnd_global.newline
538: || ' and v.object_type = ''CATEGORY_SET'' ' || fnd_global.newline
539: || ' and items.vbh_category_id = v.child_id ' || fnd_global.newline
540: || ' and v.parent_id = &ITEM+ENI_ITEM_VBH_CAT ' || fnd_global.newline

Line 537: || ' and v.dbi_flag = ''Y'' ' || fnd_global.newline

533: -- For Margin Detail Report eni_oltp_item_star.vbh_category_id is used.
534: IF (p_mv_set IN ('MRGN_DTL', 'MDTL', 'CMPDTL2', 'CMPDTL1')) THEN
535: x_where_clause := x_where_clause || ' and m.functional_area_id = 11 ' || fnd_global.newline
536: || ' and v.object_id = m.category_set_id ' || fnd_global.newline
537: || ' and v.dbi_flag = ''Y'' ' || fnd_global.newline
538: || ' and v.object_type = ''CATEGORY_SET'' ' || fnd_global.newline
539: || ' and items.vbh_category_id = v.child_id ' || fnd_global.newline
540: || ' and v.parent_id = &ITEM+ENI_ITEM_VBH_CAT ' || fnd_global.newline
541: || ' and fact.item_org_id = items.id ' ;

Line 538: || ' and v.object_type = ''CATEGORY_SET'' ' || fnd_global.newline

534: IF (p_mv_set IN ('MRGN_DTL', 'MDTL', 'CMPDTL2', 'CMPDTL1')) THEN
535: x_where_clause := x_where_clause || ' and m.functional_area_id = 11 ' || fnd_global.newline
536: || ' and v.object_id = m.category_set_id ' || fnd_global.newline
537: || ' and v.dbi_flag = ''Y'' ' || fnd_global.newline
538: || ' and v.object_type = ''CATEGORY_SET'' ' || fnd_global.newline
539: || ' and items.vbh_category_id = v.child_id ' || fnd_global.newline
540: || ' and v.parent_id = &ITEM+ENI_ITEM_VBH_CAT ' || fnd_global.newline
541: || ' and fact.item_org_id = items.id ' ;
542: ELSE

Line 539: || ' and items.vbh_category_id = v.child_id ' || fnd_global.newline

535: x_where_clause := x_where_clause || ' and m.functional_area_id = 11 ' || fnd_global.newline
536: || ' and v.object_id = m.category_set_id ' || fnd_global.newline
537: || ' and v.dbi_flag = ''Y'' ' || fnd_global.newline
538: || ' and v.object_type = ''CATEGORY_SET'' ' || fnd_global.newline
539: || ' and items.vbh_category_id = v.child_id ' || fnd_global.newline
540: || ' and v.parent_id = &ITEM+ENI_ITEM_VBH_CAT ' || fnd_global.newline
541: || ' and fact.item_org_id = items.id ' ;
542: ELSE
543: x_where_clause := x_where_clause || ' and m.functional_area_id = 11 ' || fnd_global.newline

Line 540: || ' and v.parent_id = &ITEM+ENI_ITEM_VBH_CAT ' || fnd_global.newline

536: || ' and v.object_id = m.category_set_id ' || fnd_global.newline
537: || ' and v.dbi_flag = ''Y'' ' || fnd_global.newline
538: || ' and v.object_type = ''CATEGORY_SET'' ' || fnd_global.newline
539: || ' and items.vbh_category_id = v.child_id ' || fnd_global.newline
540: || ' and v.parent_id = &ITEM+ENI_ITEM_VBH_CAT ' || fnd_global.newline
541: || ' and fact.item_org_id = items.id ' ;
542: ELSE
543: x_where_clause := x_where_clause || ' and m.functional_area_id = 11 ' || fnd_global.newline
544: || ' and v.object_id = m.category_set_id ' || fnd_global.newline

Line 543: x_where_clause := x_where_clause || ' and m.functional_area_id = 11 ' || fnd_global.newline

539: || ' and items.vbh_category_id = v.child_id ' || fnd_global.newline
540: || ' and v.parent_id = &ITEM+ENI_ITEM_VBH_CAT ' || fnd_global.newline
541: || ' and fact.item_org_id = items.id ' ;
542: ELSE
543: x_where_clause := x_where_clause || ' and m.functional_area_id = 11 ' || fnd_global.newline
544: || ' and v.object_id = m.category_set_id ' || fnd_global.newline
545: || ' and v.dbi_flag = ''Y'' ' || fnd_global.newline
546: || ' and v.object_type = ''CATEGORY_SET'' ' || fnd_global.newline
547: || ' and fact.product_category_id = v.child_id ' || fnd_global.newline

Line 544: || ' and v.object_id = m.category_set_id ' || fnd_global.newline

540: || ' and v.parent_id = &ITEM+ENI_ITEM_VBH_CAT ' || fnd_global.newline
541: || ' and fact.item_org_id = items.id ' ;
542: ELSE
543: x_where_clause := x_where_clause || ' and m.functional_area_id = 11 ' || fnd_global.newline
544: || ' and v.object_id = m.category_set_id ' || fnd_global.newline
545: || ' and v.dbi_flag = ''Y'' ' || fnd_global.newline
546: || ' and v.object_type = ''CATEGORY_SET'' ' || fnd_global.newline
547: || ' and fact.product_category_id = v.child_id ' || fnd_global.newline
548: || ' and v.parent_id = &ITEM+ENI_ITEM_VBH_CAT ';

Line 545: || ' and v.dbi_flag = ''Y'' ' || fnd_global.newline

541: || ' and fact.item_org_id = items.id ' ;
542: ELSE
543: x_where_clause := x_where_clause || ' and m.functional_area_id = 11 ' || fnd_global.newline
544: || ' and v.object_id = m.category_set_id ' || fnd_global.newline
545: || ' and v.dbi_flag = ''Y'' ' || fnd_global.newline
546: || ' and v.object_type = ''CATEGORY_SET'' ' || fnd_global.newline
547: || ' and fact.product_category_id = v.child_id ' || fnd_global.newline
548: || ' and v.parent_id = &ITEM+ENI_ITEM_VBH_CAT ';
549: END IF;

Line 546: || ' and v.object_type = ''CATEGORY_SET'' ' || fnd_global.newline

542: ELSE
543: x_where_clause := x_where_clause || ' and m.functional_area_id = 11 ' || fnd_global.newline
544: || ' and v.object_id = m.category_set_id ' || fnd_global.newline
545: || ' and v.dbi_flag = ''Y'' ' || fnd_global.newline
546: || ' and v.object_type = ''CATEGORY_SET'' ' || fnd_global.newline
547: || ' and fact.product_category_id = v.child_id ' || fnd_global.newline
548: || ' and v.parent_id = &ITEM+ENI_ITEM_VBH_CAT ';
549: END IF;
550: END IF;

Line 547: || ' and fact.product_category_id = v.child_id ' || fnd_global.newline

543: x_where_clause := x_where_clause || ' and m.functional_area_id = 11 ' || fnd_global.newline
544: || ' and v.object_id = m.category_set_id ' || fnd_global.newline
545: || ' and v.dbi_flag = ''Y'' ' || fnd_global.newline
546: || ' and v.object_type = ''CATEGORY_SET'' ' || fnd_global.newline
547: || ' and fact.product_category_id = v.child_id ' || fnd_global.newline
548: || ' and v.parent_id = &ITEM+ENI_ITEM_VBH_CAT ';
549: END IF;
550: END IF;
551:

Line 654: x_where_clause := x_where_clause ||'((&RANGE'||p_bucket_range_ids_tbl(i)||'_LOW is null OR ' || p_col_name || ' >= &RANGE'||p_bucket_range_ids_tbl(i)||'_LOW)' || fnd_global.newline ||

650: x_bucket_range_ids_tbl => p_bucket_range_ids_tbl);
651:
652: FOR i IN p_bucket_range_ids_tbl.FIRST .. p_bucket_range_ids_tbl.LAST LOOP
653:
654: x_where_clause := x_where_clause ||'((&RANGE'||p_bucket_range_ids_tbl(i)||'_LOW is null OR ' || p_col_name || ' >= &RANGE'||p_bucket_range_ids_tbl(i)||'_LOW)' || fnd_global.newline ||
655: ' AND (&RANGE'||p_bucket_range_ids_tbl(i)||'_HIGH is null OR '|| p_col_name || ' < &RANGE'||p_bucket_range_ids_tbl(i)||'_HIGH))';
656: bind_low_high( p_range_id => p_bucket_range_ids_tbl(i)
657: ,p_short_name => p_bucket_short_name
658: ,p_dim_level => 'BIV_DR_BACKLOG_BUCKET+BIV_DR_BACKLOG_BUCKET'

Line 795: l_viewby_sel := 'v.value2 VIEWBY, ' || fnd_global.newline || 'v.id VIEWBYID, ';

791: IS
792: l_viewby_sel VARCHAR2(200);
793: BEGIN
794: if p_viewby = 'BIV_REPAIR_TYPE+BIV_REPAIR_TYPE' then
795: l_viewby_sel := 'v.value2 VIEWBY, ' || fnd_global.newline || 'v.id VIEWBYID, ';
796: ELSE
797: l_viewby_sel := 'v.value VIEWBY, ' || fnd_global.newline || 'v.id VIEWBYID, ';
798: END IF;
799:

Line 797: l_viewby_sel := 'v.value VIEWBY, ' || fnd_global.newline || 'v.id VIEWBYID, ';

793: BEGIN
794: if p_viewby = 'BIV_REPAIR_TYPE+BIV_REPAIR_TYPE' then
795: l_viewby_sel := 'v.value2 VIEWBY, ' || fnd_global.newline || 'v.id VIEWBYID, ';
796: ELSE
797: l_viewby_sel := 'v.value VIEWBY, ' || fnd_global.newline || 'v.id VIEWBYID, ';
798: END IF;
799:
800: return l_viewby_sel;
801: