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.PFT_PROFITAGG_PUB dependencies on FEM_CUSTOMERS_HIER

Line 1810: FROM fem_customers_hier a

1806: SELECT customer_id
1807: BULK COLLECT INTO v_rollup_cust
1808: FROM fem_customer_profit fcp,
1809: ((SELECT child_id
1810: FROM fem_customers_hier a
1811: WHERE hierarchy_obj_def_id = l_hier_object_def_id
1812: AND parent_depth_num = l_rel_dim_group_seq_to
1813: AND child_depth_num BETWEEN
1814: l_rel_dim_group_seq_to AND (l_rel_dim_group_seq_from-1))

Line 1817: FROM fem_customers_hier a

1813: AND child_depth_num BETWEEN
1814: l_rel_dim_group_seq_to AND (l_rel_dim_group_seq_from-1))
1815: UNION (
1816: SELECT child_id
1817: FROM fem_customers_hier a
1818: WHERE hierarchy_obj_def_id = l_hier_object_def_id
1819: AND child_depth_num = l_rel_dim_group_seq_to)) hier_cust
1820: WHERE hier_cust.child_id = fcp.customer_id
1821: AND fcp.cal_period_id = p_param_rec.output_cal_period_id

Line 1853: FROM fem_customers_hier a

1849: SELECT customer_id
1850: BULK COLLECT INTO v_rollup_cust
1851: FROM fem_customer_profit fcp,
1852: ((SELECT child_id
1853: FROM fem_customers_hier a
1854: WHERE hierarchy_obj_def_id = l_hier_object_def_id
1855: AND parent_depth_num = l_rel_dim_group_seq_to
1856: AND child_depth_num = l_rel_dim_group_seq_from)
1857: UNION (SELECT child_id

Line 1858: FROM fem_customers_hier a

1854: WHERE hierarchy_obj_def_id = l_hier_object_def_id
1855: AND parent_depth_num = l_rel_dim_group_seq_to
1856: AND child_depth_num = l_rel_dim_group_seq_from)
1857: UNION (SELECT child_id
1858: FROM fem_customers_hier a
1859: WHERE hierarchy_obj_def_id = l_hier_object_def_id
1860: AND child_depth_num = l_rel_dim_group_seq_from)) hier_cust
1861: WHERE hier_cust.child_id = fcp.customer_id
1862: AND fcp.cal_period_id = p_param_rec.output_cal_period_id

Line 2770: ' FROM fem_customers_hier a ' ||

2766: FROM DUAL;
2767:
2768: p_from_clause := p_from_clause ||
2769: ' , ( (SELECT child_id, parent_id customer_id ' ||
2770: ' FROM fem_customers_hier a ' ||
2771: ' WHERE hierarchy_obj_def_id = :1';
2772:
2773: p_from_clause := p_from_clause || ' AND parent_depth_num = :2';
2774:

Line 2781: ' FROM fem_customers_hier a ' ||

2777: p_from_clause := p_from_clause || 'UNION';
2778:
2779: p_from_clause := p_from_clause ||
2780: '(SELECT child_id, child_id customer_id ' ||
2781: ' FROM fem_customers_hier a ' ||
2782: ' WHERE hierarchy_obj_def_id = :5';
2783:
2784: p_from_clause := p_from_clause || ' AND child_depth_num = :6 ) )cust_hier_dump';
2785: