[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT Nvl(micv.category_id,-1) item_category_id
FROM MTL_ITEM_CATEGORIES_V MICV,
qa_sl_sp_rcv_criteria qssrc,
qa_skiplot_association qsa,
qa_skiplot_processes qsp
WHERE micv.inventory_item_id= x_item_id AND
micv.organization_id= x_organization_id AND
qssrc.item_category_id = micv.category_id AND
qsa.criteria_id = qssrc.criteria_id AND
qsa.process_id = qsp.process_id AND
micv.category_id <> x_item_category_id
ORDER BY qsp.process_code asc;
SELECT
qsrc.criteria_id criteria_id
FROM
qa_sl_sp_rcv_criteria qsrc,
qa_skiplot_association qsa
WHERE
qsrc.vendor_id in (-1, x_vendor_id) AND
qsrc.vendor_site_id in (-1, x_vendor_site_id) AND
qsrc.item_id in (-1, x_item_id)AND
qsrc.item_revision in ('-1', x_item_revision) AND
qsrc.item_category_id in (-1, x_item_category_id) AND
qsrc.project_id in (-1, x_project_id) AND
qsrc.task_id in (-1, x_task_id) AND
qsrc.manufacturer_id in (-1, x_manufacturer_id) AND
qsrc.organization_id = x_organization_id AND
qsa.criteria_id = qsrc.criteria_id AND
trunc(sysdate) BETWEEN
nvl(trunc(qsa.effective_from), trunc(sysdate)) AND
nvl(trunc(qsa.effective_to), trunc(sysdate))
ORDER BY
qsrc.task_id desc, qsrc.project_id desc , qsrc.manufacturer_id desc,
qsrc.vendor_site_id desc, qsrc.vendor_id desc, qsrc.item_revision desc,
qsrc.item_id desc, qsrc.item_category_id desc, qsrc.last_update_date desc
FOR UPDATE NOWAIT;
select qsa.process_id
from qa_skiplot_association qsa
where qsa.criteria_id = x_c_id and
trunc(sysdate) between
nvl(trunc(qsa.effective_from), trunc(sysdate)) and
nvl(trunc(qsa.effective_to), trunc(sysdate)) and
x_lotsize between
nvl(qsa.lotsize_from, x_lotsize) and
nvl(qsa.lotsize_to, x_lotsize);
select qspp.plan_id
from qa_skiplot_process_plans qspp
where qspp.process_id = x_process_id;
SELECT INSP_STAGE
FROM qa_skiplot_association
WHERE criteria_id = x_crit_id
AND process_id = x_process_id;
SELECT qsppr.rounds
FROM qa_skiplot_process_plans qspp,
qa_skiplot_process_plan_rules qsppr
WHERE qspp.process_id = x_process_id
AND qspp.process_plan_id = qsppr.process_plan_id
AND qsppr.rule_seq=0;
SELECT MIN(rule_seq)
FROM qa_skiplot_process_plan_rules
WHERE process_plan_id = pp_id and
rule_seq > current_rule;
SELECT qspp.process_plan_id
FROM qa_skiplot_process_plans qspp, qa_skiplot_association qsa
WHERE qspp.process_id = qsa.process_id AND
qsa.criteria_id = x_crit_id AND
qspp.process_id = x_pid;
QA_SKIPLOT_UTILITY.UPDATE_PLAN_STATE (
p_process_plan_id => ps.process_plan_id,
p_criteria_id => p_criteria_id,
p_next_rule => 0,
p_next_round => 1,
p_next_lot => 0,
p_lot_accepted => 0,
p_txn => QA_SKIPLOT_UTILITY.RCV);
QA_SKIPLOT_UTILITY.update_plan_state(
p_process_plan_id => process_plan_id,
p_criteria_id => p_criteria_id,
p_next_rule => next_rule,
p_txn => p_txn);
qa_skiplot_utility.update_plan_state (
p_process_plan_id => plan_states(pID).process_plan_id,
p_criteria_id => p_criteria_id,
p_last_receipt_lot_id => x_lotID,
p_rule_start_lotid => rule_start_lotid,
p_txn => p_txn);
qa_skiplot_utility.update_plan_state (
p_process_plan_id => plan_states(pID).process_plan_id,
p_criteria_id => p_criteria_id,
p_next_lot => plan_states(pID).current_lot + 1,
p_last_receipt_lot_id => x_lotID,
p_txn => p_txn);
qa_skiplot_utility.insert_error_log (
p_module_name => 'QA_SKIPLOT_EVAL_ENGINE.EVALUATE_RULES',
p_error_message => 'QA_SKIPLOT_EVAL_RULE_FAILURE',
p_comments => SUBSTR (SQLERRM , 1 , 240));
PROCEDURE INSERT_RCV_RESULTS (
p_interface_txn_id IN NUMBER,
p_manufacturer_id IN NUMBER,
p_receipt_qty IN NUMBER,
p_criteriaID IN NUMBER,
p_insp_status IN VARCHAR2,
p_receipt_date IN DATE,
p_lotID IN NUMBER DEFAULT NULL,
p_source_inspected IN NUMBER,
p_process_id IN NUMBER,
p_lpn_id IN NUMBER) IS
x_lotID number := null;
insert into qa_skiplot_rcv_results(
INSP_LOT_ID,
CRITERIA_ID,
PROCESS_ID,
INTERFACE_TXN_ID,
SHIPMENT_LINE_ID,
RECEIPT_DATE,
MANUFACTURER_ID,
LPN_ID,
SOURCE_INSPECTED,
LOT_QTY,
TRANSACTED_QTY,
INSPECTION_STATUS,
INSPECTION_RESULT,
LAST_INSP_DATE,
VALID_FLAG,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN)
values(
x_lotID,
p_criteriaID,
p_process_id,
p_interface_txn_id,
null,
p_receipt_date,
p_manufacturer_id,
p_lpn_id,
decode(p_source_inspected, 1, 'Y', 'N'),
p_receipt_qty,
0,
p_insp_status,
null,
null,
1,
sysdate,
fnd_global.user_id,
sysdate,
fnd_global.user_id,
fnd_global.login_id);
END INSERT_RCV_RESULTS;
insert into qa_skiplot_lot_plans(
INSP_LOT_ID,
PLAN_ID,
ALTERNATE_FLAG,
SHIPMENT_LINE_ID,
PLAN_INSP_STATUS,
PLAN_INSP_RESULT,
SAMPLE_SIZE,
INSPECTED_QTY,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN)
values(
p_lotID,
plan_id,
alter_flag,
null,
p_insp_status,
null,
null,
0,
sysdate,
fnd_global.user_id,
sysdate,
fnd_global.user_id,
fnd_global.login_id);