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.BIM_I_LEAD_MGMT_PVT dependencies on ENI_ITEM_VBH_NODES_V

Line 590: SELECT LEAF_NODE_FLAG INTO L_LEAF_NODE FROM ENI_ITEM_VBH_NODES_V

586: RETURN BOOLEAN
587: IS L_LEAF_node VARCHAR2(1);
588: BEGIN
589:
590: SELECT LEAF_NODE_FLAG INTO L_LEAF_NODE FROM ENI_ITEM_VBH_NODES_V
591: WHERE PARENT_ID = replace(l_Category_ID,'''','')
592: AND PARENT_ID = CHILD_ID;
593:
594: IF(l_leaf_node = 'Y') THEN

Line 1678: FROM eni_item_vbh_nodes_v e

1674: 0 leads_closed,
1675: SUM(case when c.report_date=&BIS_CURRENT_ASOF_DATE then b.leads_changed else 0 end) curr_leads_changed
1676: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b,
1677: ( SELECT e.parent_id parent_id ,e.value value,e.leaf_node_flag leaf_node_flag
1678: FROM eni_item_vbh_nodes_v e
1679: WHERE e.top_node_flag=''Y''
1680: AND e.child_id = e.parent_id) p
1681: ,eni_denorm_hierarchies edh
1682: ,mtl_default_category_sets d

Line 1716: FROM eni_item_vbh_nodes_v e

1712: sum(leads_closed) leads_closed,
1713: 0 curr_leads_changed
1714: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b,
1715: ( SELECT e.parent_id parent_id ,e.value value,e.leaf_node_flag leaf_node_flag
1716: FROM eni_item_vbh_nodes_v e
1717: WHERE e.top_node_flag=''Y''
1718: AND e.child_id = e.parent_id) p
1719: ,eni_denorm_hierarchies edh
1720: ,mtl_default_category_sets d

Line 1810: FROM eni_item_vbh_nodes_v e

1806: 0 leads_closed,
1807: SUM(case when c.report_date=&BIS_CURRENT_ASOF_DATE then b.leads_changed else 0 end) curr_leads_changed
1808: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b,
1809: ( SELECT e.parent_id parent_id ,e.value value,e.leaf_node_flag leaf_node_flag
1810: FROM eni_item_vbh_nodes_v e
1811: WHERE e.top_node_flag=''Y''
1812: AND e.child_id = e.parent_id) p
1813: ,eni_denorm_hierarchies edh
1814: ,mtl_default_category_sets d

Line 1848: FROM eni_item_vbh_nodes_v e

1844: sum(leads_closed) leads_closed,
1845: 0 curr_leads_changed
1846: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b,
1847: ( SELECT e.parent_id parent_id ,e.value value,e.leaf_node_flag leaf_node_flag
1848: FROM eni_item_vbh_nodes_v e
1849: WHERE e.top_node_flag=''Y''
1850: AND e.child_id = e.parent_id) p
1851: ,eni_denorm_hierarchies edh
1852: ,mtl_default_category_sets d

Line 1933: FROM eni_item_vbh_nodes_v e

1929: FROM FII_TIME_RPT_STRUCT c,BIM_I_LP_GEN_SG_MV b
1930: ,eni_denorm_hierarchies edh
1931: ,mtl_default_category_sets mdc
1932: ,(SELECT e.id,e.value,leaf_node_flag
1933: FROM eni_item_vbh_nodes_v e
1934: WHERE e.parent_id =&ITEM+ENI_ITEM_VBH_CAT
1935: AND e.id = e.child_id
1936: AND ((e.leaf_node_flag=''N'' AND e.parent_id<>e.id) OR e.leaf_node_flag=''Y'')
1937: ) p

Line 1964: FROM eni_item_vbh_nodes_v e

1960: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b
1961: ,eni_denorm_hierarchies edh
1962: ,mtl_default_category_sets mdc
1963: ,(SELECT e.id,e.value,leaf_node_flag
1964: FROM eni_item_vbh_nodes_v e
1965: WHERE e.parent_id =&ITEM+ENI_ITEM_VBH_CAT
1966: AND e.id = e.child_id
1967: AND ((e.leaf_node_flag=''N'' AND e.parent_id<>e.id) OR e.leaf_node_flag=''Y'')
1968: ) p

Line 1997: FROM eni_item_vbh_nodes_v e

1993: SUM(case when c.report_date=&BIS_CURRENT_ASOF_DATE then b.leads else 0 end) curr_total,
1994: 0 leads_converted,0 leads_new,0 leads_dead,0 leads_closed,SUM(case when c.report_date=&BIS_CURRENT_ASOF_DATE then b.leads_changed else 0 end) curr_leads_changed
1995: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b
1996: ,(SELECT e.id id,e.value value
1997: FROM eni_item_vbh_nodes_v e
1998: WHERE e.parent_id = &ITEM+ENI_ITEM_VBH_CAT
1999: AND e.parent_id = e.child_id
2000: AND leaf_node_flag <> ''Y''
2001: ) p

Line 2023: FROM eni_item_vbh_nodes_v e

2019: 0 prior_open,0 curr_open,0 curr_total,sum(leads_converted) leads_converted,sum(leads_new) leads_new,sum(leads_dead) leads_dead,sum(leads_closed) leads_closed,
2020: 0 curr_leads_changed
2021: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b
2022: ,(SELECT e.id id,e.value value
2023: FROM eni_item_vbh_nodes_v e
2024: WHERE e.parent_id = &ITEM+ENI_ITEM_VBH_CAT
2025: AND e.parent_id = e.child_id
2026: AND leaf_node_flag <> ''Y''
2027: ) p

Line 2082: FROM eni_item_vbh_nodes_v e

2078: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b
2079: ,eni_denorm_hierarchies edh
2080: ,mtl_default_category_sets mdc
2081: ,(SELECT e.id,e.value,leaf_node_flag
2082: FROM eni_item_vbh_nodes_v e
2083: WHERE e.parent_id =&ITEM+ENI_ITEM_VBH_CAT
2084: AND e.id = e.child_id
2085: AND ((e.leaf_node_flag=''N'' AND e.parent_id<>e.id) OR e.leaf_node_flag=''Y'')
2086: ) p

Line 2112: FROM eni_item_vbh_nodes_v e

2108: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b
2109: ,eni_denorm_hierarchies edh
2110: ,mtl_default_category_sets mdc
2111: ,(SELECT e.id,e.value,leaf_node_flag
2112: FROM eni_item_vbh_nodes_v e
2113: WHERE e.parent_id =&ITEM+ENI_ITEM_VBH_CAT
2114: AND e.id = e.child_id
2115: AND ((e.leaf_node_flag=''N'' AND e.parent_id<>e.id) OR e.leaf_node_flag=''Y'')
2116: ) p

Line 2145: FROM eni_item_vbh_nodes_v e

2141: SUM(case when c.report_date=&BIS_CURRENT_ASOF_DATE then b.leads else 0 end) curr_total,
2142: 0 leads_converted,0 leads_new,0 leads_dead,0 leads_closed,SUM(case when c.report_date=&BIS_CURRENT_ASOF_DATE then b.leads_changed else 0 end) curr_leads_changed
2143: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b
2144: ,(SELECT e.id id,e.value value
2145: FROM eni_item_vbh_nodes_v e
2146: WHERE e.parent_id = &ITEM+ENI_ITEM_VBH_CAT
2147: AND e.parent_id = e.child_id
2148: AND leaf_node_flag <> ''Y''
2149: ) p

Line 2171: FROM eni_item_vbh_nodes_v e

2167: sum(leads_converted) leads_converted,sum(leads_new) leads_new,sum(leads_dead) leads_dead,
2168: sum(leads_closed) leads_closed,0 curr_leads_changed
2169: FROM FII_TIME_RPT_STRUCT c,BIM_I_LP_GEN_SG_MV b
2170: ,(SELECT e.id id,e.value value
2171: FROM eni_item_vbh_nodes_v e
2172: WHERE e.parent_id = &ITEM+ENI_ITEM_VBH_CAT
2173: AND e.parent_id = e.child_id
2174: AND leaf_node_flag <> ''Y''
2175: ) p

Line 3593: FROM eni_item_vbh_nodes_v e

3589: 0 prev_open,
3590: sum(decode(c.report_date,&BIS_PREVIOUS_ASOF_DATE,leads_converted,0)) prev_lead_converted
3591: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b
3592: ,( SELECT e.parent_id parent_id ,e.value value,e.leaf_node_flag leaf_node_flag
3593: FROM eni_item_vbh_nodes_v e
3594: WHERE e.top_node_flag=''Y''
3595: AND e.child_id = e.parent_id) p
3596: ,eni_denorm_hierarchies edh
3597: ,mtl_default_category_sets d

Line 3628: FROM eni_item_vbh_nodes_v e

3624: sum(b.leads-(b.leads_closed+b.leads_dead+b.leads_converted)) prev_open,
3625: 0 prev_lead_converted
3626: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b
3627: ,( SELECT e.parent_id parent_id ,e.value value,e.leaf_node_flag leaf_node_flag
3628: FROM eni_item_vbh_nodes_v e
3629: WHERE e.top_node_flag=''Y''
3630: AND e.child_id = e.parent_id) p
3631: ,eni_denorm_hierarchies edh
3632: ,mtl_default_category_sets d

Line 3657: FROM eni_item_vbh_nodes_v e

3653: sum(decode(c.report_date,&BIS_PREVIOUS_ASOF_DATE,cnv_opty_amt'||l_curr_suffix||',0)) prev_oppt_amt,
3654: 0,0,0,0,0
3655: FROM FII_TIME_RPT_STRUCT c, bil_bi_opty_pg_mv f
3656: ,( SELECT e.parent_id parent_id ,e.value value,e.leaf_node_flag leaf_node_flag
3657: FROM eni_item_vbh_nodes_v e
3658: WHERE e.top_node_flag=''Y''
3659: AND e.child_id = e.parent_id) p
3660: ,eni_denorm_hierarchies edh
3661: ,mtl_default_category_sets d

Line 3734: FROM eni_item_vbh_nodes_v e

3730: 0 prev_open,
3731: sum(decode(c.report_date,&BIS_PREVIOUS_ASOF_DATE,leads_converted,0)) prev_lead_converted
3732: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b
3733: ,( SELECT e.parent_id parent_id ,e.value value,e.leaf_node_flag leaf_node_flag
3734: FROM eni_item_vbh_nodes_v e
3735: WHERE e.top_node_flag=''Y''
3736: AND e.child_id = e.parent_id) p
3737: ,eni_denorm_hierarchies edh
3738: ,mtl_default_category_sets d

Line 3769: FROM eni_item_vbh_nodes_v e

3765: sum(b.leads-(b.leads_closed+b.leads_dead+b.leads_converted)) prev_open,
3766: 0 prev_lead_converted
3767: FROM FII_TIME_RPT_STRUCT c,BIM_I_LP_GEN_SG_MV b
3768: ,( SELECT e.parent_id parent_id ,e.value value,e.leaf_node_flag leaf_node_flag
3769: FROM eni_item_vbh_nodes_v e
3770: WHERE e.top_node_flag=''Y''
3771: AND e.child_id = e.parent_id) p
3772: ,eni_denorm_hierarchies edh
3773: ,mtl_default_category_sets d

Line 3801: FROM eni_item_vbh_nodes_v e

3797: sum(decode(c.report_date,&BIS_PREVIOUS_ASOF_DATE,cnv_opty_amt'||l_curr_suffix||',0)) prev_oppt_amt,
3798: 0,0,0,0,0
3799: FROM FII_TIME_RPT_STRUCT c, bil_bi_opty_pg_mv f
3800: , ( SELECT e.parent_id parent_id ,e.value value,e.leaf_node_flag leaf_node_flag
3801: FROM eni_item_vbh_nodes_v e
3802: WHERE e.top_node_flag=''Y''
3803: AND e.child_id = e.parent_id) p
3804: ,eni_denorm_hierarchies edh
3805: ,mtl_default_category_sets d

Line 3886: FROM eni_item_vbh_nodes_v e

3882: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b
3883: ,eni_denorm_hierarchies edh
3884: ,mtl_default_category_sets mdc
3885: ,(SELECT e.id,e.value,leaf_node_flag
3886: FROM eni_item_vbh_nodes_v e
3887: WHERE e.parent_id =&ITEM+ENI_ITEM_VBH_CAT
3888: AND e.id = e.child_id
3889: AND ((e.leaf_node_flag=''N'' AND e.parent_id<>e.id) OR e.leaf_node_flag=''Y'')
3890: ) p

Line 3923: FROM eni_item_vbh_nodes_v e

3919: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b
3920: ,eni_denorm_hierarchies edh
3921: ,mtl_default_category_sets mdc
3922: ,(SELECT e.id,e.value,leaf_node_flag
3923: FROM eni_item_vbh_nodes_v e
3924: WHERE e.parent_id =&ITEM+ENI_ITEM_VBH_CAT
3925: AND e.id = e.child_id
3926: AND ((e.leaf_node_flag=''N'' AND e.parent_id<>e.id) OR e.leaf_node_flag=''Y'')
3927: ) p

Line 3960: FROM eni_item_vbh_nodes_v e

3956: 0 prev_open,
3957: sum(decode(c.report_date,&BIS_PREVIOUS_ASOF_DATE,leads_converted,0)) prev_lead_converted
3958: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b
3959: ,(SELECT e.id id,e.value value
3960: FROM eni_item_vbh_nodes_v e
3961: WHERE e.parent_id = &ITEM+ENI_ITEM_VBH_CAT
3962: AND e.parent_id = e.child_id
3963: AND leaf_node_flag <> ''Y''
3964: ) p

Line 3991: FROM eni_item_vbh_nodes_v e

3987: sum(b.leads-(b.leads_closed+b.leads_dead+b.leads_converted)) prev_open,
3988: 0 prev_lead_converted
3989: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b
3990: ,(SELECT e.id id,e.value value
3991: FROM eni_item_vbh_nodes_v e
3992: WHERE e.parent_id = &ITEM+ENI_ITEM_VBH_CAT
3993: AND e.parent_id = e.child_id
3994: AND leaf_node_flag <> ''Y''
3995: ) p

Line 4021: FROM eni_item_vbh_nodes_v e

4017: FROM FII_TIME_RPT_STRUCT c, bil_bi_opty_pg_mv f
4018: ,eni_denorm_hierarchies edh
4019: ,mtl_default_category_sets mdc
4020: ,(SELECT e.id,e.value,leaf_node_flag
4021: FROM eni_item_vbh_nodes_v e
4022: WHERE e.parent_id =&ITEM+ENI_ITEM_VBH_CAT
4023: AND e.id = e.child_id
4024: AND ((e.leaf_node_flag=''N'' AND e.parent_id<>e.id) OR e.leaf_node_flag=''Y'')
4025: ) p

Line 4049: FROM eni_item_vbh_nodes_v e

4045: sum(decode(c.report_date,&BIS_PREVIOUS_ASOF_DATE,cnv_opty_amt'||l_curr_suffix||',0)) prev_oppt_amt,
4046: 0,0,0,0,0
4047: FROM FII_TIME_RPT_STRUCT c, bil_bi_opty_pg_mv f
4048: , (SELECT e.id id,e.value value
4049: FROM eni_item_vbh_nodes_v e
4050: WHERE e.parent_id = &ITEM+ENI_ITEM_VBH_CAT
4051: AND e.parent_id = e.child_id
4052: AND leaf_node_flag <> ''Y''
4053: ) p

Line 4125: FROM eni_item_vbh_nodes_v e

4121: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b
4122: ,eni_denorm_hierarchies edh
4123: ,mtl_default_category_sets mdc
4124: ,(SELECT e.id,e.value,leaf_node_flag
4125: FROM eni_item_vbh_nodes_v e
4126: WHERE e.parent_id =&ITEM+ENI_ITEM_VBH_CAT
4127: AND e.id = e.child_id
4128: AND ((e.leaf_node_flag=''N'' AND e.parent_id<>e.id) OR e.leaf_node_flag=''Y'')
4129: ) p

Line 4162: FROM eni_item_vbh_nodes_v e

4158: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b
4159: ,eni_denorm_hierarchies edh
4160: ,mtl_default_category_sets mdc
4161: ,(SELECT e.id,e.value,leaf_node_flag
4162: FROM eni_item_vbh_nodes_v e
4163: WHERE e.parent_id =&ITEM+ENI_ITEM_VBH_CAT
4164: AND e.id = e.child_id
4165: AND ((e.leaf_node_flag=''N'' AND e.parent_id<>e.id) OR e.leaf_node_flag=''Y'')
4166: ) p

Line 4199: FROM eni_item_vbh_nodes_v e

4195: 0 prev_open,
4196: sum(decode(c.report_date,&BIS_PREVIOUS_ASOF_DATE,leads_converted,0)) prev_lead_converted
4197: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b
4198: ,(SELECT e.id id,e.value value
4199: FROM eni_item_vbh_nodes_v e
4200: WHERE e.parent_id = &ITEM+ENI_ITEM_VBH_CAT
4201: AND e.parent_id = e.child_id
4202: AND leaf_node_flag <> ''Y''
4203: ) p

Line 4230: FROM eni_item_vbh_nodes_v e

4226: sum(b.leads-(b.leads_closed+b.leads_dead+b.leads_converted)) prev_open,
4227: 0 prev_lead_converted
4228: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b
4229: ,(SELECT e.id id,e.value value
4230: FROM eni_item_vbh_nodes_v e
4231: WHERE e.parent_id = &ITEM+ENI_ITEM_VBH_CAT
4232: AND e.parent_id = e.child_id
4233: AND leaf_node_flag <> ''Y''
4234: ) p

Line 4260: from eni_item_vbh_nodes_v e

4256: FROM FII_TIME_RPT_STRUCT c, bil_bi_opty_pg_mv f
4257: ,eni_denorm_hierarchies edh
4258: ,mtl_default_category_sets mdc
4259: ,(select e.id,e.value,leaf_node_flag
4260: from eni_item_vbh_nodes_v e
4261: where e.parent_id =&ITEM+ENI_ITEM_VBH_CAT
4262: AND e.id = e.child_id
4263: AND ((e.leaf_node_flag=''N'' AND e.parent_id<>e.id) OR e.leaf_node_flag=''Y'')
4264: ) p

Line 4288: FROM eni_item_vbh_nodes_v e

4284: sum(decode(c.report_date,&BIS_PREVIOUS_ASOF_DATE,cnv_opty_amt'||l_curr_suffix||',0)) prev_oppt_amt,
4285: 0,0,0,0,0
4286: FROM FII_TIME_RPT_STRUCT c, bil_bi_opty_pg_mv f
4287: ,(SELECT e.id id,e.value value
4288: FROM eni_item_vbh_nodes_v e
4289: WHERE e.parent_id = &ITEM+ENI_ITEM_VBH_CAT
4290: AND e.parent_id = e.child_id
4291: AND leaf_node_flag <> ''Y''
4292: ) p

Line 5250: FROM eni_item_vbh_nodes_v e

5246: 0 prev_open,
5247: sum(decode(c.report_date,&BIS_PREVIOUS_ASOF_DATE,leads_converted,0)) prev_lead_converted,
5248: 0 prev_new_lead_converted
5249: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b,( SELECT e.parent_id parent_id ,e.value value,e.leaf_node_flag leaf_node_flag
5250: FROM eni_item_vbh_nodes_v e
5251: WHERE e.top_node_flag=''Y''
5252: AND e.child_id = e.parent_id) p
5253: ,eni_denorm_hierarchies edh
5254: ,mtl_default_category_sets d

Line 5286: FROM eni_item_vbh_nodes_v e

5282: 0 prev_open,
5283: 0 prev_lead_converted,
5284: 0 prev_new_lead_converted
5285: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b,( SELECT e.parent_id parent_id ,e.value value,e.leaf_node_flag leaf_node_flag
5286: FROM eni_item_vbh_nodes_v e
5287: WHERE e.top_node_flag=''Y''
5288: AND e.child_id = e.parent_id) p
5289: ,eni_denorm_hierarchies edh
5290: ,mtl_default_category_sets d

Line 5322: FROM eni_item_vbh_nodes_v e

5318: 0 prev_open,
5319: 0 prev_lead_converted,
5320: sum(leads_new_conv) prev_new_lead_converted
5321: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b,( SELECT e.parent_id parent_id ,e.value value,e.leaf_node_flag leaf_node_flag
5322: FROM eni_item_vbh_nodes_v e
5323: WHERE e.top_node_flag=''Y''
5324: AND e.child_id = e.parent_id) p
5325: ,eni_denorm_hierarchies edh
5326: ,mtl_default_category_sets d

Line 5357: FROM eni_item_vbh_nodes_v e

5353: sum(b.leads-(b.leads_closed+b.leads_dead+b.leads_converted)) prev_open,
5354: 0 prev_lead_converted,
5355: 0 prev_new_lead_converted
5356: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b,( SELECT e.parent_id parent_id ,e.value value,e.leaf_node_flag leaf_node_flag
5357: FROM eni_item_vbh_nodes_v e
5358: WHERE e.top_node_flag=''Y''
5359: AND e.child_id = e.parent_id) p
5360: ,eni_denorm_hierarchies edh
5361: ,mtl_default_category_sets d

Line 5437: FROM eni_item_vbh_nodes_v e

5433: 0 prev_open,
5434: sum(decode(c.report_date,&BIS_PREVIOUS_ASOF_DATE,leads_converted,0)) prev_lead_converted,
5435: 0 prev_new_lead_converted
5436: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b,( SELECT e.parent_id parent_id ,e.value value,e.leaf_node_flag leaf_node_flag
5437: FROM eni_item_vbh_nodes_v e
5438: WHERE e.top_node_flag=''Y''
5439: AND e.child_id = e.parent_id) p
5440: ,eni_denorm_hierarchies edh
5441: ,mtl_default_category_sets d

Line 5473: FROM eni_item_vbh_nodes_v e

5469: 0 prev_open,
5470: 0 prev_lead_converted,
5471: 0 prev_new_lead_converted
5472: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b,( SELECT e.parent_id parent_id ,e.value value,e.leaf_node_flag leaf_node_flag
5473: FROM eni_item_vbh_nodes_v e
5474: WHERE e.top_node_flag=''Y''
5475: AND e.child_id = e.parent_id) p
5476: ,eni_denorm_hierarchies edh
5477: ,mtl_default_category_sets d

Line 5509: FROM eni_item_vbh_nodes_v e

5505: 0 prev_open,
5506: 0 prev_lead_converted,
5507: sum(leads_new_conv) prev_new_lead_converted
5508: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b,( SELECT e.parent_id parent_id ,e.value value,e.leaf_node_flag leaf_node_flag
5509: FROM eni_item_vbh_nodes_v e
5510: WHERE e.top_node_flag=''Y''
5511: AND e.child_id = e.parent_id) p
5512: ,eni_denorm_hierarchies edh
5513: ,mtl_default_category_sets d

Line 5544: FROM eni_item_vbh_nodes_v e

5540: sum(b.leads-(b.leads_closed+b.leads_dead+b.leads_converted)) prev_open,
5541: 0 prev_lead_converted,
5542: 0 prev_new_lead_converted
5543: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b,( SELECT e.parent_id parent_id ,e.value value,e.leaf_node_flag leaf_node_flag
5544: FROM eni_item_vbh_nodes_v e
5545: WHERE e.top_node_flag=''Y''
5546: AND e.child_id = e.parent_id) p
5547: ,eni_denorm_hierarchies edh
5548: ,mtl_default_category_sets d

Line 5633: from eni_item_vbh_nodes_v e

5629: 0 prev_new_lead_converted
5630: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b,eni_denorm_hierarchies edh
5631: ,mtl_default_category_sets mdc
5632: ,(select e.id,e.value,leaf_node_flag
5633: from eni_item_vbh_nodes_v e
5634: where
5635: e.parent_id =&ITEM+ENI_ITEM_VBH_CAT
5636: AND e.id = e.child_id
5637: AND((e.leaf_node_flag=''N'' AND e.parent_id<>e.id) OR e.leaf_node_flag=''Y'')

Line 5672: from eni_item_vbh_nodes_v e

5668: 0 prev_new_lead_converted
5669: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b,eni_denorm_hierarchies edh
5670: ,mtl_default_category_sets mdc
5671: ,(select e.id,e.value,leaf_node_flag
5672: from eni_item_vbh_nodes_v e
5673: where
5674: e.parent_id =&ITEM+ENI_ITEM_VBH_CAT
5675: AND e.id = e.child_id
5676: AND((e.leaf_node_flag=''N'' AND e.parent_id<>e.id) OR e.leaf_node_flag=''Y'')

Line 5710: from eni_item_vbh_nodes_v e

5706: sum(leads_new_conv) prev_new_lead_converted
5707: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b,eni_denorm_hierarchies edh
5708: ,mtl_default_category_sets mdc
5709: ,(select e.id,e.value,leaf_node_flag
5710: from eni_item_vbh_nodes_v e
5711: where
5712: e.parent_id =&ITEM+ENI_ITEM_VBH_CAT
5713: AND e.id = e.child_id
5714: AND((e.leaf_node_flag=''N'' AND e.parent_id<>e.id) OR e.leaf_node_flag=''Y'')

Line 5748: from eni_item_vbh_nodes_v e

5744: 0 prev_new_lead_converted
5745: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b,eni_denorm_hierarchies edh
5746: ,mtl_default_category_sets mdc
5747: ,(select e.id,e.value,leaf_node_flag
5748: from eni_item_vbh_nodes_v e
5749: where
5750: e.parent_id =&ITEM+ENI_ITEM_VBH_CAT
5751: AND e.id = e.child_id
5752: AND((e.leaf_node_flag=''N'' AND e.parent_id<>e.id) OR e.leaf_node_flag=''Y'')

Line 5786: from eni_item_vbh_nodes_v e

5782: 0 prev_open,
5783: sum(decode(c.report_date,&BIS_PREVIOUS_ASOF_DATE,leads_converted,0)) prev_lead_converted,
5784: 0 prev_new_lead_converted
5785: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b,(select e.id id,e.value value
5786: from eni_item_vbh_nodes_v e
5787: where e.parent_id = &ITEM+ENI_ITEM_VBH_CAT
5788: AND e.parent_id = e.child_id
5789: AND leaf_node_flag <> ''Y''
5790: ) p

Line 5818: from eni_item_vbh_nodes_v e

5814: 0 prev_open,
5815: 0 prev_lead_converted,
5816: 0 prev_new_lead_converted
5817: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b,(select e.id id,e.value value
5818: from eni_item_vbh_nodes_v e
5819: where e.parent_id = &ITEM+ENI_ITEM_VBH_CAT
5820: AND e.parent_id = e.child_id
5821: AND leaf_node_flag <> ''Y''
5822: ) p

Line 5850: from eni_item_vbh_nodes_v e

5846: 0 prev_open,
5847: 0 prev_lead_converted,
5848: sum(leads_new_conv) prev_new_lead_converted
5849: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b,(select e.id id,e.value value
5850: from eni_item_vbh_nodes_v e
5851: where e.parent_id = &ITEM+ENI_ITEM_VBH_CAT
5852: AND e.parent_id = e.child_id
5853: AND leaf_node_flag <> ''Y''
5854: ) p

Line 5881: from eni_item_vbh_nodes_v e

5877: sum(b.leads-(b.leads_closed+b.leads_dead+b.leads_converted)) prev_open,
5878: 0 prev_lead_converted,
5879: 0 prev_new_lead_converted
5880: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b,(select e.id id,e.value value
5881: from eni_item_vbh_nodes_v e
5882: where e.parent_id = &ITEM+ENI_ITEM_VBH_CAT
5883: AND e.parent_id = e.child_id
5884: AND leaf_node_flag <> ''Y''
5885: ) p

Line 5961: from eni_item_vbh_nodes_v e

5957: 0 prev_new_lead_converted
5958: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b,eni_denorm_hierarchies edh
5959: ,mtl_default_category_sets mdc
5960: ,(select e.id,e.value,leaf_node_flag
5961: from eni_item_vbh_nodes_v e
5962: where
5963: e.parent_id =&ITEM+ENI_ITEM_VBH_CAT
5964: AND e.id = e.child_id
5965: AND((e.leaf_node_flag=''N'' AND e.parent_id<>e.id) OR e.leaf_node_flag=''Y'')

Line 6000: from eni_item_vbh_nodes_v e

5996: 0 prev_new_lead_converted
5997: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b,eni_denorm_hierarchies edh
5998: ,mtl_default_category_sets mdc
5999: ,(select e.id,e.value,leaf_node_flag
6000: from eni_item_vbh_nodes_v e
6001: where
6002: e.parent_id =&ITEM+ENI_ITEM_VBH_CAT
6003: AND e.id = e.child_id
6004: AND((e.leaf_node_flag=''N'' AND e.parent_id<>e.id) OR e.leaf_node_flag=''Y'')

Line 6039: from eni_item_vbh_nodes_v e

6035: sum(leads_new_conv) prev_new_lead_converted
6036: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b,eni_denorm_hierarchies edh
6037: ,mtl_default_category_sets mdc
6038: ,(select e.id,e.value,leaf_node_flag
6039: from eni_item_vbh_nodes_v e
6040: where
6041: e.parent_id =&ITEM+ENI_ITEM_VBH_CAT
6042: AND e.id = e.child_id
6043: AND((e.leaf_node_flag=''N'' AND e.parent_id<>e.id) OR e.leaf_node_flag=''Y'')

Line 6077: from eni_item_vbh_nodes_v e

6073: 0 prev_new_lead_converted
6074: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b,eni_denorm_hierarchies edh
6075: ,mtl_default_category_sets mdc
6076: ,(select e.id,e.value,leaf_node_flag
6077: from eni_item_vbh_nodes_v e
6078: where
6079: e.parent_id =&ITEM+ENI_ITEM_VBH_CAT
6080: AND e.id = e.child_id
6081: AND((e.leaf_node_flag=''N'' AND e.parent_id<>e.id) OR e.leaf_node_flag=''Y'')

Line 6115: from eni_item_vbh_nodes_v e

6111: 0 prev_open,
6112: sum(decode(c.report_date,&BIS_PREVIOUS_ASOF_DATE,leads_converted,0)) prev_lead_converted,
6113: 0 prev_new_lead_converted
6114: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b,(select e.id id,e.value value
6115: from eni_item_vbh_nodes_v e
6116: where e.parent_id = &ITEM+ENI_ITEM_VBH_CAT
6117: AND e.parent_id = e.child_id
6118: AND leaf_node_flag <> ''Y''
6119: ) p

Line 6147: from eni_item_vbh_nodes_v e

6143: 0 prev_open,
6144: 0 prev_lead_converted,
6145: 0 prev_new_lead_converted
6146: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b,(select e.id id,e.value value
6147: from eni_item_vbh_nodes_v e
6148: where e.parent_id = &ITEM+ENI_ITEM_VBH_CAT
6149: AND e.parent_id = e.child_id
6150: AND leaf_node_flag <> ''Y''
6151: ) p

Line 6179: from eni_item_vbh_nodes_v e

6175: 0 prev_open,
6176: 0 prev_lead_converted,
6177: sum(leads_new_conv) prev_new_lead_converted
6178: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b,(select e.id id,e.value value
6179: from eni_item_vbh_nodes_v e
6180: where e.parent_id = &ITEM+ENI_ITEM_VBH_CAT
6181: AND e.parent_id = e.child_id
6182: AND leaf_node_flag <> ''Y''
6183: ) p

Line 6210: from eni_item_vbh_nodes_v e

6206: sum(b.leads-(b.leads_closed+b.leads_dead+b.leads_converted)) prev_open,
6207: 0 prev_lead_converted,
6208: 0 prev_new_lead_converted
6209: FROM FII_TIME_RPT_STRUCT c, BIM_I_LP_GEN_SG_MV b,(select e.id id,e.value value
6210: from eni_item_vbh_nodes_v e
6211: where e.parent_id = &ITEM+ENI_ITEM_VBH_CAT
6212: AND e.parent_id = e.child_id
6213: AND leaf_node_flag <> ''Y''
6214: ) p

Line 8372: FROM eni_item_vbh_nodes_v e

8368: sum(rank_z) rank_z,
8369: sum(rank_a + rank_b + rank_c + rank_d + rank_z) rank_total,
8370: sum(leads_qualified) leads_qualified
8371: FROM FII_TIME_RPT_STRUCT c,( SELECT e.parent_id parent_id ,e.value value,e.leaf_node_flag leaf_node_flag
8372: FROM eni_item_vbh_nodes_v e
8373: WHERE e.top_node_flag=''Y''
8374: AND e.child_id = e.parent_id) p
8375: ,eni_denorm_hierarchies edh
8376: ,mtl_default_category_sets d

Line 8449: FROM eni_item_vbh_nodes_v e

8445: sum(rank_z) rank_z,
8446: sum(rank_a + rank_b + rank_c + rank_d + rank_z) rank_total,
8447: sum(leads_qualified) leads_qualified
8448: FROM FII_TIME_RPT_STRUCT c,( SELECT e.parent_id parent_id ,e.value value,e.leaf_node_flag leaf_node_flag
8449: FROM eni_item_vbh_nodes_v e
8450: WHERE e.top_node_flag=''Y''
8451: AND e.child_id = e.parent_id) p
8452: ,eni_denorm_hierarchies edh
8453: ,mtl_default_category_sets d, BIM_I_LP_GEN_SG_MV b

Line 8521: from eni_item_vbh_nodes_v e

8517: sum(leads_qualified) leads_qualified
8518: FROM FII_TIME_RPT_STRUCT c,BIM_I_LP_GEN_SG_MV b,eni_denorm_hierarchies edh
8519: ,mtl_default_category_sets mdc
8520: ,(select e.id,e.value,leaf_node_flag
8521: from eni_item_vbh_nodes_v e
8522: where
8523: e.parent_id =&ITEM+ENI_ITEM_VBH_CAT
8524: AND e.id = e.child_id
8525: AND((e.leaf_node_flag=''N'' AND e.parent_id<>e.id) OR e.leaf_node_flag=''Y'')

Line 8558: from eni_item_vbh_nodes_v e

8554: sum(rank_z) rank_z,
8555: sum(rank_a + rank_b + rank_c + rank_d + rank_z) rank_total,
8556: sum(leads_qualified) leads_qualified
8557: FROM FII_TIME_RPT_STRUCT c,BIM_I_LP_GEN_SG_MV b,(select e.id id,e.value value
8558: from eni_item_vbh_nodes_v e
8559: where e.parent_id = &ITEM+ENI_ITEM_VBH_CAT
8560: AND e.parent_id = e.child_id
8561: AND leaf_node_flag <> ''Y''
8562: ) p

Line 8614: from eni_item_vbh_nodes_v e

8610: sum(leads_qualified) leads_qualified
8611: FROM FII_TIME_RPT_STRUCT c,BIM_I_LP_GEN_SG_MV b,eni_denorm_hierarchies edh
8612: ,mtl_default_category_sets mdc
8613: ,(select e.id,e.value,leaf_node_flag
8614: from eni_item_vbh_nodes_v e
8615: where
8616: e.parent_id =&ITEM+ENI_ITEM_VBH_CAT
8617: AND e.id = e.child_id
8618: AND((e.leaf_node_flag=''N'' AND e.parent_id<>e.id) OR e.leaf_node_flag=''Y'')

Line 8644: from eni_item_vbh_nodes_v e

8640: p.id VIEWBYID,''Y'' leaf_node_flag,1 dir_flag,sum(rank_a) rank_a,sum(rank_b) rank_b,
8641: sum(rank_c) rank_c,sum(rank_d) rank_d,sum(rank_z) rank_z,sum(rank_a + rank_b + rank_c + rank_d + rank_z) rank_total,
8642: sum(leads_qualified) leads_qualified
8643: FROM FII_TIME_RPT_STRUCT c,BIM_I_LP_GEN_SG_MV b ,(select e.id id,e.value value
8644: from eni_item_vbh_nodes_v e
8645: where e.parent_id = &ITEM+ENI_ITEM_VBH_CAT
8646: AND e.parent_id = e.child_id
8647: AND leaf_node_flag <> ''Y''
8648: ) p

Line 9513: FROM BIM_I_LP_AGE_SG_MV b,ENI_ITEM_VBH_NODES_V e

9509: sum(age_3_below) age_3_below, sum(age_3_to_7) age_3_to_7, sum(age_8_to_14) age_8_to_14,
9510: sum(age_15_to_21) age_15_to_21, sum(age_22_to_28) age_22_to_28, sum(age_29_to_35) age_29_to_35,
9511: sum(age_36_to_42) age_36_to_42, sum(age_42_to_above) age_42_to_above,
9512: 1 row_order
9513: FROM BIM_I_LP_AGE_SG_MV b,ENI_ITEM_VBH_NODES_V e
9514: WHERE
9515: b.group_id = &ORGANIZATION+JTF_ORG_SALES_GROUP
9516: AND e.parent_id = b.product_category_id
9517: AND e.parent_id = e.child_id

Line 9568: FROM BIM_I_LP_AGE_SG_MV b,ENI_ITEM_VBH_NODES_V e

9564: sum(age_3_below) age_3_below, sum(age_3_to_7) age_3_to_7, sum(age_8_to_14) age_8_to_14,
9565: sum(age_15_to_21) age_15_to_21, sum(age_22_to_28) age_22_to_28, sum(age_29_to_35) age_29_to_35,
9566: sum(age_36_to_42) age_36_to_42, sum(age_42_to_above) age_42_to_above,
9567: 1 row_order
9568: FROM BIM_I_LP_AGE_SG_MV b,ENI_ITEM_VBH_NODES_V e
9569: WHERE
9570: b.group_id = :l_group_id
9571: AND e.parent_id = b.product_category_id
9572: AND e.parent_id = e.child_id

Line 9627: FROM BIM_I_LP_AGE_SG_MV b,ENI_ITEM_VBH_NODES_V e

9623: sum(age_3_below) age_3_below, sum(age_3_to_7) age_3_to_7, sum(age_8_to_14) age_8_to_14,
9624: sum(age_15_to_21) age_15_to_21, sum(age_22_to_28) age_22_to_28, sum(age_29_to_35) age_29_to_35,
9625: sum(age_36_to_42) age_36_to_42, sum(age_42_to_above) age_42_to_above,
9626: 1 row_order
9627: FROM BIM_I_LP_AGE_SG_MV b,ENI_ITEM_VBH_NODES_V e
9628: WHERE
9629: b.group_id = &ORGANIZATION+JTF_ORG_SALES_GROUP
9630: AND e.parent_id = &ITEM+ENI_ITEM_VBH_CAT
9631: AND e.id = b.product_category_id

Line 9654: FROM BIM_I_LP_AGE_SG_MV b,ENI_ITEM_VBH_NODES_V e

9650: sum(age_3_below) age_3_below, sum(age_3_to_7) age_3_to_7, sum(age_8_to_14) age_8_to_14,
9651: sum(age_15_to_21) age_15_to_21, sum(age_22_to_28) age_22_to_28, sum(age_29_to_35) age_29_to_35,
9652: sum(age_36_to_42) age_36_to_42, sum(age_42_to_above) age_42_to_above,
9653: 1 row_order
9654: FROM BIM_I_LP_AGE_SG_MV b,ENI_ITEM_VBH_NODES_V e
9655: WHERE
9656: b.group_id = &ORGANIZATION+JTF_ORG_SALES_GROUP
9657: AND e.parent_id = &ITEM+ENI_ITEM_VBH_CAT
9658: AND e.parent_id = e.child_id

Line 9713: FROM BIM_I_LP_AGE_SG_MV b,ENI_ITEM_VBH_NODES_V e

9709: sum(age_3_below) age_3_below, sum(age_3_to_7) age_3_to_7, sum(age_8_to_14) age_8_to_14,
9710: sum(age_15_to_21) age_15_to_21, sum(age_22_to_28) age_22_to_28, sum(age_29_to_35) age_29_to_35,
9711: sum(age_36_to_42) age_36_to_42, sum(age_42_to_above) age_42_to_above,
9712: 1 row_order
9713: FROM BIM_I_LP_AGE_SG_MV b,ENI_ITEM_VBH_NODES_V e
9714: WHERE
9715: b.group_id = :l_group_id
9716: AND e.parent_id = &ITEM+ENI_ITEM_VBH_CAT
9717: AND e.id = b.product_category_id

Line 9740: FROM BIM_I_LP_AGE_SG_MV b,ENI_ITEM_VBH_NODES_V e

9736: sum(age_3_below) age_3_below, sum(age_3_to_7) age_3_to_7, sum(age_8_to_14) age_8_to_14,
9737: sum(age_15_to_21) age_15_to_21, sum(age_22_to_28) age_22_to_28, sum(age_29_to_35) age_29_to_35,
9738: sum(age_36_to_42) age_36_to_42, sum(age_42_to_above) age_42_to_above,
9739: 1 row_order
9740: FROM BIM_I_LP_AGE_SG_MV b,ENI_ITEM_VBH_NODES_V e
9741: WHERE
9742: b.group_id = :l_group_id
9743: AND e.parent_id = &ITEM+ENI_ITEM_VBH_CAT
9744: AND e.parent_id = e.child_id