APPS.QA_SAMPLING_PKG dependencies on QA_SAMPLING_PLANS

Line 1088: QA_SAMPLING_PLANS qsp,

1084: x_organization_id number,
1085: x_item_category_id number) IS
1086: SELECT Nvl(micv.category_id,-1) item_category_id
1087: FROM MTL_ITEM_CATEGORIES_V MICV,
1088: QA_SAMPLING_PLANS qsp,
1089: qa_sampling_rcv_criteria_val_v qsrcvv
1090: WHERE micv.inventory_item_id= x_item_id AND
1091: micv.organization_id= x_organization_id AND
1092: qsrcvv.item_category_id = micv.category_id AND

Line 1179: --checks QA_SAMPLING_PLANS table and gets the standard code, c number

1175:
1176: --
1177: --This checks the QA_SAMPLING_CUSTOM_RULES table based on sampling plan id
1178: --and lot size and return the custom sample size if found. Otherwise, it
1179: --checks QA_SAMPLING_PLANS table and gets the standard code, c number
1180: --and AQL and checks the QA_SAMPLING_STD_RULES table and return the std.
1181: --sample size
1182: --Note: Some alterations to the table columns were being made
1183: --Please refer to detail design for more information

Line 1203: from QA_SAMPLING_PLANS qsp

1199:
1200: cursor sampling_plan_cur
1201: is
1202: select sampling_std_code, AQL, insp_level_code
1203: from QA_SAMPLING_PLANS qsp
1204: where sampling_plan_id = p_sampling_plan_id;
1205:
1206: cursor custom_sample_cur
1207: is

Line 1374: l_sampling_std_code qa_sampling_plans.sampling_std_code%type;

1370: l_c_num number := 0;
1371: l_rej_num number := 1;
1372: l_criteria_id number;
1373: l_sampling_plan_id number;
1374: l_sampling_std_code qa_sampling_plans.sampling_std_code%type;
1375: out_wf_item_key number;
1376:
1377: cursor sampling_flag_cur
1378: is

Line 1394: from qa_sampling_plans

1390:
1391: cursor sampling_std_code_cur (x_sampling_plan_id number)
1392: is
1393: select sampling_std_code
1394: from qa_sampling_plans
1395: where sampling_plan_id = x_sampling_plan_id;
1396:
1397: begin
1398: open sampling_flag_cur;