APPS.QA_SKIPLOT_RES_ENGINE dependencies on QA_INSP_COLLECTIONS_DTL_TEMP

Line 36: from qa_insp_collections_dtl_temp

32:
33: CURSOR insp_coll_dtl IS
34: select organization_id, item_id, lpn_id, xfr_lpn_id,
35: lot_number, serial_number, insp_result, sum(insp_qty)
36: from qa_insp_collections_dtl_temp
37: where collection_id = p_collection_id
38: group by organization_id, item_id, lpn_id, xfr_lpn_id,
39: lot_number, serial_number, insp_result;
40:

Line 94: -- the temp table qa_insp_collections_dtl_temp.

90: l_rti_loc_id NUMBER := NULL;
91: begin
92:
93: -- First, post the Inspection details from qa_results onto
94: -- the temp table qa_insp_collections_dtl_temp.
95: -- Here we build the detail temp table for the plan.
96:
97: qa_sampling_pkg.post_insp_coll_details(p_collection_id);
98:

Line 105: -- Fetch the records in qa_insp_collections_dtl_temp for calling the

101: OPEN vend_lot_num(p_transaction_id);
102: FETCH vend_lot_num INTO l_vendor_lot_num;
103: CLOSE vend_lot_num;
104:
105: -- Fetch the records in qa_insp_collections_dtl_temp for calling the
106: -- RCV API. We have grouped the records in cursor so that it gives the
107: -- consolidated picture.
108:
109: OPEN insp_coll_dtl;