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.AHL_PRD_PRINT_PVT dependencies on QA_RESULTS

Line 1122: --local variable to hold the query string to retrieve qa results

1118: QA_PLAN_CHARS_V QA
1119: WHERE
1120: plan_id = p_plan_id;
1121:
1122: --local variable to hold the query string to retrieve qa results
1123: l_query_string VARCHAR2(30000) := null; --pdoki changed for Bug 6777371
1124: l_rec_count NUMBER;
1125: l_result_column_name VARCHAR2(100);
1126: l_item_found VARCHAR2(1);

Line 1188: l_query_string := l_query_string || ' FROM QA_RESULTS_V RESULTS ';

1184:
1185: --l_query_string := l_query_string || ' ,'''||TO_CHAR(l_rec_count-1)||''''||' AS FIELD_COUNT';
1186:
1187: -- Results will all be included in the from clause
1188: l_query_string := l_query_string || ' FROM QA_RESULTS_V RESULTS ';
1189:
1190: -- Append required FROM clauses for the API.
1191: IF l_item_found = FND_API.G_TRUE THEN
1192: l_query_string := l_query_string || ' , MTL_SYSTEM_ITEMS_KFV ITEM ';

Line 2428: FROM QA_RESULTS

2424:
2425: CURSOR qa_result_csr(c_collection_id IN NUMBER)
2426: IS
2427: SELECT occurrence
2428: FROM QA_RESULTS
2429: WHERE collection_id = c_collection_id;
2430:
2431: CURSOR get_visit_no(c_visit_id IN NUMBER)
2432: IS

Line 2850: QA_RESULTS_V QR

2846: SELECT QC.char_id "CharId",
2847: CI.attribute_value "AttributeValue"
2848: FROM CSI_IEA_VALUES CI,
2849: QA_PLAN_CHARS QC ,
2850: QA_RESULTS_V QR
2851: WHERE QC.plan_id = QR.plan_id
2852: AND CI.instance_id(+) = QR.csi_instance_id
2853: AND QR.collection_id = :1';
2854:

Line 7534: --local variable to hold the query string to retrieve qa results

7530: AND enabled_flag = 1
7531: AND displayed_flag = 1
7532: order by prompt_sequence;
7533:
7534: --local variable to hold the query string to retrieve qa results
7535: l_query_string VARCHAR2(30000) := null; --pdoki changed for Bug 6777371
7536: l_rec_count NUMBER;
7537: l_result_column_name VARCHAR2(100);
7538: l_item_found VARCHAR2(1);

Line 7597: l_query_string := l_query_string || ' FROM QA_RESULTS_V RESULTS ';

7593:
7594: END LOOP;
7595:
7596: -- Results will all be included in the from clause
7597: l_query_string := l_query_string || ' FROM QA_RESULTS_V RESULTS ';
7598:
7599: -- Append required FROM clauses for the API.
7600: IF l_item_found = FND_API.G_TRUE THEN
7601: l_query_string := l_query_string || ' , MTL_SYSTEM_ITEMS_KFV ITEM ';

Line 8115: FROM QA_RESULTS

8111:
8112: CURSOR qa_result_csr(c_collection_id IN NUMBER)
8113: IS
8114: SELECT occurrence
8115: FROM QA_RESULTS
8116: WHERE collection_id = c_collection_id;
8117:
8118: CURSOR get_visit_no(c_visit_id IN NUMBER)
8119: IS

Line 8319: QA_RESULTS_V QR

8315: SELECT QC.char_id "CharId",
8316: CI.attribute_value "AttributeValue"
8317: FROM CSI_IEA_VALUES CI,
8318: QA_PLAN_CHARS QC ,
8319: QA_RESULTS_V QR
8320: WHERE QC.plan_id = QR.plan_id
8321: AND CI.instance_id(+) = QR.csi_instance_id
8322: AND QR.collection_id = :1';
8323: