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

Line 27: -- records entered in qa_results.

23:
24: BEGIN
25:
26: -- We assume that these information are common for all inspection
27: -- records entered in qa_results.
28:
29: OPEN dtl_info;
30: FETCH dtl_info INTO l_org_id, l_item_id, l_lpn_id;
31: CLOSE dtl_info;

Line 98: l_lot_num qa_results.lot_number%TYPE;

94:
95: -- OPM Conv R12 Tracking Bug 4345760
96: -- change variable size for lot num
97:
98: l_lot_num qa_results.lot_number%TYPE;
99:
100:
101: l_serial_num VARCHAR2(30);
102: l_quantity NUMBER;

Line 165: l_lot_number qa_results.lot_number%TYPE;

161:
162: -- OPM Conv R12 Tracking Bug 4345760
163: -- change variable size for lot num
164:
165: l_lot_number qa_results.lot_number%TYPE;
166:
167:
168: l_serial_number VARCHAR2(30);
169: l_insp_qty NUMBER;

Line 271: l_lot_number qa_results.lot_number%TYPE;

267:
268: -- OPM Conv R12 Tracking Bug 4345760
269: -- change variable size for lot num
270:
271: l_lot_number qa_results.lot_number%TYPE;
272:
273:
274: l_serial_number VARCHAR2(30);
275: l_qty_rem NUMBER;

Line 487: l_lot_number qa_results.lot_number%TYPE;

483:
484: -- OPM Conv R12 Tracking Bug 4345760
485: -- change variable size for lot num
486:
487: l_lot_number qa_results.lot_number%TYPE;
488:
489:
490: l_serial_number VARCHAR2(30);
491: l_insp_result VARCHAR2(80);

Line 521: -- First, post the Inspection details from qa_results onto

517: BEGIN
518: -- We dont need to check the sampling flag here because
519: -- launch_shipment_action() calls this only for sampling scenario.
520:
521: -- First, post the Inspection details from qa_results onto
522: -- the temp table qa_insp_collections_dtl_temp.
523: -- Here we build the detail temp table for the plan.
524:
525: post_insp_coll_details(p_collection_id);

Line 853: --this function returns the softcoded column in qa_results

849:
850: res_col varchar2(20);
851:
852: begin
853: --this function returns the softcoded column in qa_results
854: --where Inspection Result is stored for the given plan_id
855: open res_cur;
856:
857: fetch res_cur into res_col;

Line 1377: sql_str := 'select sum(quantity) from qa_results where exists ' ||

1373: -- can be in any language, we use in statement to check
1374: -- inspection result in all possible language
1375: --
1376: /*
1377: sql_str := 'select sum(quantity) from qa_results where exists ' ||
1378: '(select ' || result_column || ' from qa_results ' ||
1379: 'where collection_id = :1 and plan_id = :2 and '||
1380: result_column || ' in (' || in_str || ' ))';
1381: */

Line 1378: '(select ' || result_column || ' from qa_results ' ||

1374: -- inspection result in all possible language
1375: --
1376: /*
1377: sql_str := 'select sum(quantity) from qa_results where exists ' ||
1378: '(select ' || result_column || ' from qa_results ' ||
1379: 'where collection_id = :1 and plan_id = :2 and '||
1380: result_column || ' in (' || in_str || ' ))';
1381: */
1382:

Line 1390: -- qa_results row by plan_id and collection_id.

1386: -- restricting by plan_id and collection_id results in multiple
1387: -- rows being returned which are then summed up as rejected qty.
1388: -- This in turn causes the whole lot to be rejected inspite of high
1389: -- AQL. Following sql computes correct rejected qty by restricting the
1390: -- qa_results row by plan_id and collection_id.
1391:
1392: --
1393: -- Bug 6129041
1394: -- Commented the below code and replaced with the code which

Line 1402: sql_str := 'select sum(quantity) from qa_results ' ||

1398: -- procedure executes as before.
1399: -- skolluku Wed Jul 11 03:37:20 PDT 2007
1400: --
1401: /*
1402: sql_str := 'select sum(quantity) from qa_results ' ||
1403: 'where collection_id = :1 and plan_id = :2 and ' ||
1404: result_column || ' in (' || in_str || ' )';
1405:
1406: execute immediate sql_str into reject_qty

Line 1409: sql_str := 'select sum(quantity) from qa_results ' ||

1405:
1406: execute immediate sql_str into reject_qty
1407: using p_collection_id, p_coll_plan_id;
1408: */
1409: sql_str := 'select sum(quantity) from qa_results ' ||
1410: 'where collection_id = :1 and plan_id = :2 and ';
1411: if p_item_id is not null then
1412: sql_str := sql_str || ' item_id = :3 and ';
1413: end if;

Line 1593: --from qa_results for a particular Collection Id

1589: l_plan_count NUMBER;
1590:
1591: --BUG 4741324
1592: --Added a new variable to get a count of the LPN IDs
1593: --from qa_results for a particular Collection Id
1594: --ntungare Mon Nov 21 20:44:54 PST 2005
1595: l_license_plate_no_id number;
1596:
1597: begin

Line 1617: -- The following select stmt is based on qa_results which is similar

1613: close plan_count_cur;
1614:
1615: --
1616: -- Bug 4732741:
1617: -- The following select stmt is based on qa_results which is similar
1618: -- to the way LPN_ID's are fetched and processed in the procedure
1619: -- launch_shipment_action_int. In that procedure we fetch the
1620: -- lpn_id's from qa_results and post them in to temp table
1621: -- qa_insp_collections_dtl_temp and then process them. So based

Line 1620: -- lpn_id's from qa_results and post them in to temp table

1616: -- Bug 4732741:
1617: -- The following select stmt is based on qa_results which is similar
1618: -- to the way LPN_ID's are fetched and processed in the procedure
1619: -- launch_shipment_action_int. In that procedure we fetch the
1620: -- lpn_id's from qa_results and post them in to temp table
1621: -- qa_insp_collections_dtl_temp and then process them. So based
1622: -- this cursor to fetch count of lpn_id from qa_results for the particular
1623: -- collection_id and if count is 0 stop calling the procedure
1624: -- launch_shipment_action_int.

Line 1622: -- this cursor to fetch count of lpn_id from qa_results for the particular

1618: -- to the way LPN_ID's are fetched and processed in the procedure
1619: -- launch_shipment_action_int. In that procedure we fetch the
1620: -- lpn_id's from qa_results and post them in to temp table
1621: -- qa_insp_collections_dtl_temp and then process them. So based
1622: -- this cursor to fetch count of lpn_id from qa_results for the particular
1623: -- collection_id and if count is 0 stop calling the procedure
1624: -- launch_shipment_action_int.
1625: -- ntungare Mon Nov 14 21:11:30 PST 2005
1626: --

Line 1628: FROM qa_results

1624: -- launch_shipment_action_int.
1625: -- ntungare Mon Nov 14 21:11:30 PST 2005
1626: --
1627: SELECT Count(lpn_id) INTO l_license_plate_no_id
1628: FROM qa_results
1629: WHERE collection_id = p_collection_id;
1630:
1631: -- If the Plan count is 1, call the new procedure and return.
1632: -- IF (l_plan_count = 1) THEN

Line 2110: l_lot_num qa_results.lot_number%TYPE;

2106:
2107: -- OPM Conv R12 Tracking Bug 4345760
2108: -- change variable size for lot num
2109:
2110: l_lot_num qa_results.lot_number%TYPE;
2111:
2112: l_serial_num VARCHAR2(25);
2113: l_qty NUMBER;
2114:

Line 2139: -- the results entered in Inspection Plan in qa_results.

2135:
2136: l_result_column := get_softcoded_column(l_plan_id);
2137:
2138: -- Construct the SQL for fetching REJECT and ACCEPT from
2139: -- the results entered in Inspection Plan in qa_results.
2140:
2141: in_str_reject :=
2142: ' select displayed_field' ||
2143: ' from po_lookup_codes' ||

Line 2156: ' lot_number, serial_number, quantity from qa_results' ||

2152: ' and lookup_code = ''ACCEPT''';
2153:
2154:
2155: l_sql_rej := 'select occurrence, organization_id, item_id, lpn_id, xfr_lpn_id,'||
2156: ' lot_number, serial_number, quantity from qa_results' ||
2157: ' where collection_id = :1 and plan_id = :2 and ' ||
2158: l_result_column || ' in (' || in_str_reject || ' )';
2159:
2160: l_sql_acc := 'select occurrence, organization_id, item_id, lpn_id, xfr_lpn_id,'||

Line 2161: ' lot_number, serial_number, quantity from qa_results' ||

2157: ' where collection_id = :1 and plan_id = :2 and ' ||
2158: l_result_column || ' in (' || in_str_reject || ' )';
2159:
2160: l_sql_acc := 'select occurrence, organization_id, item_id, lpn_id, xfr_lpn_id,'||
2161: ' lot_number, serial_number, quantity from qa_results' ||
2162: ' where collection_id = :1 and plan_id = :2 and ' ||
2163: l_result_column || ' in (' || in_str_accept || ' )';
2164:
2165: