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.HZ_DQM_MR_PVT dependencies on HZ_TRANS_FUNCTIONS_VL

Line 501: FROM hz_secondary_trans st, hz_trans_functions_vl f

497: inner_row_counter := 0;
498:
499: FOR trans in (
500: SELECT round(transformation_weight/100*attrs.score) score, staged_attribute_column
501: FROM hz_secondary_trans st, hz_trans_functions_vl f
502: where f.function_id=st.function_id
503: and st.secondary_attribute_id = attrs.secondary_attribute_id
504: order by transformation_weight desc)
505: LOOP

Line 587: FROM hz_primary_trans pt, hz_trans_functions_vl f

583: END IF;
584:
585: FIRST := TRUE;
586: FOR trans in ( SELECT staged_attribute_column
587: FROM hz_primary_trans pt, hz_trans_functions_vl f
588: where f.function_id = pt.function_id
589: and pt.primary_attribute_id = attrs.primary_attribute_id
590: )
591: LOOP

Line 635: FROM hz_primary_trans pt, hz_trans_functions_vl f

631: l('and');
632:
633: FIRST := TRUE;
634: FOR trans in ( SELECT staged_attribute_column
635: FROM hz_primary_trans pt, hz_trans_functions_vl f
636: where f.function_id = pt.function_id
637: and pt.primary_attribute_id = attrs.primary_attribute_id
638: )
639: LOOP

Line 710: FROM hz_primary_trans pt, hz_trans_functions_vl f

706: l('and');
707:
708: FIRST := TRUE;
709: FOR trans in ( SELECT staged_attribute_column
710: FROM hz_primary_trans pt, hz_trans_functions_vl f
711: where f.function_id = pt.function_id
712: and pt.primary_attribute_id = attrs.primary_attribute_id
713: )
714: LOOP

Line 812: FROM hz_secondary_trans st, hz_trans_functions_vl f

808: inner_row_counter := 0;
809:
810: FOR trans in (
811: SELECT round(transformation_weight/100*attrs.score) score, staged_attribute_column
812: FROM hz_secondary_trans st, hz_trans_functions_vl f
813: where f.function_id=st.function_id
814: and st.secondary_attribute_id = attrs.secondary_attribute_id
815: order by transformation_weight desc)
816: LOOP

Line 875: FROM hz_primary_trans pt, hz_trans_functions_vl f

871: END IF;
872:
873: FIRST := TRUE;
874: FOR trans in ( SELECT staged_attribute_column
875: FROM hz_primary_trans pt, hz_trans_functions_vl f
876: where f.function_id = pt.function_id
877: and pt.primary_attribute_id = attrs.primary_attribute_id
878: )
879: LOOP

Line 923: FROM hz_primary_trans pt, hz_trans_functions_vl f

919:
920:
921: FIRST := TRUE;
922: FOR trans in ( SELECT staged_attribute_column
923: FROM hz_primary_trans pt, hz_trans_functions_vl f
924: where f.function_id = pt.function_id
925: and pt.primary_attribute_id = attrs.primary_attribute_id
926: )
927: LOOP

Line 1316: FROM hz_secondary_trans st, hz_trans_functions_vl f

1312: inner_row_counter := 0;
1313:
1314: FOR trans in (
1315: SELECT round(transformation_weight/100*attrs.score) score, staged_attribute_column
1316: FROM hz_secondary_trans st, hz_trans_functions_vl f
1317: where f.function_id=st.function_id
1318: and st.secondary_attribute_id = attrs.secondary_attribute_id
1319: order by transformation_weight desc)
1320: LOOP

Line 1416: FROM hz_primary_trans pt, hz_trans_functions_vl f

1412: END IF;
1413:
1414: FIRST := TRUE;
1415: FOR trans in ( SELECT staged_attribute_column
1416: FROM hz_primary_trans pt, hz_trans_functions_vl f
1417: where f.function_id = pt.function_id
1418: and pt.primary_attribute_id = attrs.primary_attribute_id
1419: )
1420: LOOP

Line 1467: FROM hz_primary_trans pt, hz_trans_functions_vl f

1463: l('and ');
1464:
1465: FIRST := TRUE;
1466: FOR trans in ( SELECT staged_attribute_column
1467: FROM hz_primary_trans pt, hz_trans_functions_vl f
1468: where f.function_id = pt.function_id
1469: and pt.primary_attribute_id = attrs.primary_attribute_id
1470: )
1471: LOOP

Line 1555: FROM hz_secondary_trans st, hz_trans_functions_vl f

1551: inner_row_counter := 0;
1552:
1553: FOR trans in (
1554: SELECT round(transformation_weight/100*attrs.score) score, staged_attribute_column
1555: FROM hz_secondary_trans st, hz_trans_functions_vl f
1556: where f.function_id=st.function_id
1557: and st.secondary_attribute_id = attrs.secondary_attribute_id
1558: order by transformation_weight desc)
1559: LOOP

Line 1622: FROM hz_primary_trans pt, hz_trans_functions_vl f

1618: END IF;
1619:
1620: FIRST := TRUE;
1621: FOR trans in ( SELECT staged_attribute_column
1622: FROM hz_primary_trans pt, hz_trans_functions_vl f
1623: where f.function_id = pt.function_id
1624: and pt.primary_attribute_id = attrs.primary_attribute_id
1625: )
1626: LOOP

Line 1670: FROM hz_primary_trans pt, hz_trans_functions_vl f

1666: l('and ');
1667:
1668: FIRST := TRUE;
1669: FOR trans in ( SELECT staged_attribute_column
1670: FROM hz_primary_trans pt, hz_trans_functions_vl f
1671: where f.function_id = pt.function_id
1672: and pt.primary_attribute_id = attrs.primary_attribute_id
1673: )
1674: LOOP

Line 1757: FROM hz_primary_trans pt, hz_trans_functions_vl f

1753: l('and');
1754:
1755: FIRST := TRUE;
1756: FOR trans in ( SELECT staged_attribute_column
1757: FROM hz_primary_trans pt, hz_trans_functions_vl f
1758: where f.function_id = pt.function_id
1759: and pt.primary_attribute_id = attrs.primary_attribute_id
1760: )
1761: LOOP

Line 1851: FROM hz_secondary_trans st, hz_trans_functions_vl f

1847: inner_row_counter := 0;
1848:
1849: FOR trans in (
1850: SELECT round(transformation_weight/100*attrs.score) score, staged_attribute_column
1851: FROM hz_secondary_trans st, hz_trans_functions_vl f
1852: where f.function_id=st.function_id
1853: and st.secondary_attribute_id = attrs.secondary_attribute_id
1854: order by transformation_weight desc)
1855: LOOP

Line 1914: FROM hz_primary_trans pt, hz_trans_functions_vl f

1910: END IF;
1911:
1912: FIRST := TRUE;
1913: FOR trans in ( SELECT staged_attribute_column
1914: FROM hz_primary_trans pt, hz_trans_functions_vl f
1915: where f.function_id = pt.function_id
1916: and pt.primary_attribute_id = attrs.primary_attribute_id
1917: )
1918: LOOP

Line 1962: FROM hz_primary_trans pt, hz_trans_functions_vl f

1958: l('and ');
1959:
1960: FIRST := TRUE;
1961: FOR trans in ( SELECT staged_attribute_column
1962: FROM hz_primary_trans pt, hz_trans_functions_vl f
1963: where f.function_id = pt.function_id
1964: and pt.primary_attribute_id = attrs.primary_attribute_id
1965: )
1966: LOOP

Line 2427: FROM hz_secondary_trans st, hz_trans_functions_vl f

2423: inner_row_counter := 0;
2424:
2425: FOR trans in (
2426: SELECT round(transformation_weight/100*attrs.score) score, staged_attribute_column
2427: FROM hz_secondary_trans st, hz_trans_functions_vl f
2428: where f.function_id=st.function_id
2429: and st.secondary_attribute_id = attrs.secondary_attribute_id
2430: order by transformation_weight desc)
2431: LOOP

Line 2507: FROM hz_primary_trans pt, hz_trans_functions_vl f

2503: END IF;
2504:
2505: FIRST := TRUE;
2506: FOR trans in ( SELECT staged_attribute_column
2507: FROM hz_primary_trans pt, hz_trans_functions_vl f
2508: where f.function_id = pt.function_id
2509: and pt.primary_attribute_id = attrs.primary_attribute_id
2510: )
2511: LOOP

Line 2558: FROM hz_primary_trans pt, hz_trans_functions_vl f

2554: l('and ');
2555:
2556: FIRST := TRUE;
2557: FOR trans in ( SELECT staged_attribute_column
2558: FROM hz_primary_trans pt, hz_trans_functions_vl f
2559: where f.function_id = pt.function_id
2560: and pt.primary_attribute_id = attrs.primary_attribute_id
2561: )
2562: LOOP

Line 2647: FROM hz_secondary_trans st, hz_trans_functions_vl f

2643: inner_row_counter := 0;
2644:
2645: FOR trans in (
2646: SELECT round(transformation_weight/100*attrs.score) score, staged_attribute_column
2647: FROM hz_secondary_trans st, hz_trans_functions_vl f
2648: where f.function_id=st.function_id
2649: and st.secondary_attribute_id = attrs.secondary_attribute_id
2650: order by transformation_weight desc)
2651: LOOP

Line 2721: FROM hz_primary_trans pt, hz_trans_functions_vl f

2717: END IF;
2718:
2719: FIRST := TRUE;
2720: FOR trans in ( SELECT staged_attribute_column
2721: FROM hz_primary_trans pt, hz_trans_functions_vl f
2722: where f.function_id = pt.function_id
2723: and pt.primary_attribute_id = attrs.primary_attribute_id
2724: )
2725: LOOP

Line 2769: FROM hz_primary_trans pt, hz_trans_functions_vl f

2765: l('and ');
2766:
2767: FIRST := TRUE;
2768: FOR trans in ( SELECT staged_attribute_column
2769: FROM hz_primary_trans pt, hz_trans_functions_vl f
2770: where f.function_id = pt.function_id
2771: and pt.primary_attribute_id = attrs.primary_attribute_id
2772: )
2773: LOOP

Line 2844: FROM hz_primary_trans pt, hz_trans_functions_vl f

2840: l('and');
2841:
2842: FIRST := TRUE;
2843: FOR trans in ( SELECT staged_attribute_column
2844: FROM hz_primary_trans pt, hz_trans_functions_vl f
2845: where f.function_id = pt.function_id
2846: and pt.primary_attribute_id = attrs.primary_attribute_id
2847: )
2848: LOOP

Line 2937: FROM hz_secondary_trans st, hz_trans_functions_vl f

2933: inner_row_counter := 0;
2934:
2935: FOR trans in (
2936: SELECT round(transformation_weight/100*attrs.score) score, staged_attribute_column
2937: FROM hz_secondary_trans st, hz_trans_functions_vl f
2938: where f.function_id=st.function_id
2939: and st.secondary_attribute_id = attrs.secondary_attribute_id
2940: order by transformation_weight desc)
2941: LOOP

Line 3010: FROM hz_primary_trans pt, hz_trans_functions_vl f

3006: END IF;
3007:
3008: FIRST := TRUE;
3009: FOR trans in ( SELECT staged_attribute_column
3010: FROM hz_primary_trans pt, hz_trans_functions_vl f
3011: where f.function_id = pt.function_id
3012: and pt.primary_attribute_id = attrs.primary_attribute_id
3013: )
3014: LOOP

Line 3056: FROM hz_primary_trans pt, hz_trans_functions_vl f

3052: l('and ');
3053:
3054: FIRST := TRUE;
3055: FOR trans in ( SELECT staged_attribute_column
3056: FROM hz_primary_trans pt, hz_trans_functions_vl f
3057: where f.function_id = pt.function_id
3058: and pt.primary_attribute_id = attrs.primary_attribute_id
3059: )
3060: LOOP