[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
IM.ITEM_ID,
IL.LOT_ID
FROM
IC_ITEM_MST IM,
IC_LOTS_MST IL
WHERE IM.ITEM_NO = P_ITEM_NO
AND IM.ITEM_ID = IL.ITEM_ID
AND IL.LOT_NO = P_LOT_NO
AND ( P_SUBLOT_NO IS NULL
OR ( P_SUBLOT_NO IS NOT NULL
AND P_SUBLOT_NO = SUBLOT_NO ) )
ORDER BY
IL.LOT_ID;
SELECT
GMI_LOT_TRACE_ID_S.NEXTVAL
INTO P_TRACE_ID
FROM
DUAL;
DELETE FROM GMI_LOT_TRACE
WHERE LOT_TRACE_ID = P_TRACE_ID;
SELECT
TRANS_DATE,
DOC_TYPE,
ORGN_CODE,
DOC_ID,
LINE_ID,
SUM(TRANS_QTY) TR_QTY,
TRANS_UM
FROM
IC_TRAN_VW1
WHERE ITEM_ID = ITEM_NOFORMULA.ITEM_ID
AND LOT_ID = ITEM_NOFORMULA.LOT_ID
AND COMPLETED_IND = 1
AND DOC_TYPE not in ( 'GRDI' , 'GRDR' , 'TRNI' , 'TRNR' , 'STSI' , 'STSR' )
GROUP BY
TRANS_DATE,
DOC_TYPE,
ORGN_CODE,
DOC_ID,
LINE_ID,
TRANS_UM
ORDER BY
TRANS_DATE ASC;
SELECT
IJM.ORGN_CODE,
IJM.JOURNAL_NO
FROM
IC_JRNL_MST IJM,
IC_ADJS_JNL IAJ
WHERE IJM.JOURNAL_ID = IAJ.JOURNAL_ID
AND IAJ.DOC_ID = REC_DOCDTL.DOC_ID;
SELECT
PLANT_CODE,
BATCH_NO
FROM
PM_BTCH_HDR
WHERE BATCH_ID = REC_DOCDTL.DOC_ID;
SELECT
PRH.ORGN_CODE RECV_ORGN,
PVM.VENDOR_NO VEND_NO,
PVM.VENDOR_NAME VEND_NAME,
PRH.RECV_NO RECV_NO,
POH.PO_NO PO_NO,
POH.ORGN_CODE PO_ORGN
FROM
PO_RECV_HDR PRH,
PO_RECV_DTL PRD,
PO_VEND_MST PVM,
PO_ORDR_HDR POH
WHERE PRH.RECV_ID = REC_DOCDTL.DOC_ID
AND PRH.RECV_ID = PRD.RECV_ID
AND PRD.LINE_ID = REC_DOCDTL.LINE_ID
AND PRD.PO_ID = poh.po_id (+)
AND PVM.VENDOR_ID = PRD.SHIPVEND_ID;
SELECT
SHIPMENT_HEADER_ID,
PO_HEADER_ID,
VENDOR_ID,
VENDOR_SITE_ID
FROM
RCV_TRANSACTIONS
WHERE SHIPMENT_HEADER_ID = REC_DOCDTL.DOC_ID
AND TRANSACTION_ID = REC_DOCDTL.LINE_ID;
SELECT
VEND.SEGMENT1,
VEND.VENDOR_NAME,
SITE.VENDOR_SITE_CODE
FROM
PO_VENDORS VEND,
PO_VENDOR_SITES_ALL SITE
WHERE VEND.VENDOR_ID = REC_RCV_TRANSACTIONS.VENDOR_ID
AND VEND.VENDOR_ID = SITE.VENDOR_ID
AND SITE.VENDOR_SITE_ID = REC_RCV_TRANSACTIONS.VENDOR_SITE_ID;
SELECT
RECEIPT_NUM
FROM
RCV_SHIPMENT_HEADERS
WHERE SHIPMENT_HEADER_ID = REC_RCV_TRANSACTIONS.SHIPMENT_HEADER_ID;
SELECT
SEGMENT1,
ATTRIBUTE15
FROM
PO_HEADERS_ALL
WHERE PO_HEADER_ID = REC_RCV_TRANSACTIONS.PO_HEADER_ID;
SELECT
VENDOR_NO,
VENDOR_NAME
FROM
PO_VEND_MST
WHERE VENDOR_ID = (
SELECT
SHIPVEND_ID
FROM
IC_LOTS_MST
WHERE ITEM_ID = ITEM_NOFORMULA.ITEM_ID
AND LOT_ID = ITEM_NOFORMULA.LOT_ID );
SELECT
IM.ITEM_NO,
IM.ITEM_DESC1,
IM.SHELF_LIFE,
IM.RETEST_INTERVAL,
IL.LOT_NO,
IL.SUBLOT_NO,
IM.INV_CLASS,
IM.INV_TYPE,
IL.EXPIRE_DATE,
IL.RETEST_DATE,
IL.QC_GRADE,
IL.VENDOR_LOT_NO
INTO L_ITEM_NO,ITEM_DESC,SHELF_LIFE,RETEST_INTERVAL,LOT_NO,SUBLOT_NO,INV_CLASS,INV_TYPE,EXPIRE_DATE,RETEST_DATE,GRADE,VEND_LOT_NO
FROM
IC_ITEM_MST IM,
IC_LOTS_MST IL
WHERE IM.ITEM_ID = ITEM_NOFORMULA.ITEM_ID
AND IL.LOT_ID = ITEM_NOFORMULA.LOT_ID
AND IM.ITEM_ID = IL.ITEM_ID;
SELECT
IM.ITEM_NO,
IM.ITEM_DESC1,
IL.LOT_NO,
IL.SUBLOT_NO
INTO L_ITEM_NO,I_ITEM_DESC,I_LOT_NO,I_SUBLOT_NO
FROM
IC_ITEM_MST IM,
IC_LOTS_MST IL
WHERE IM.ITEM_ID = ITEM_ID2
AND IL.LOT_ID = LOT_ID3
AND IM.ITEM_ID = IL.ITEM_ID;
SELECT
IJM.JOURNAL_NO
FROM
IC_ADJS_JNL IAJ,
IC_JRNL_MST IJM
WHERE IAJ.JOURNAL_ID = IJM.JOURNAL_ID
AND IAJ.DOC_ID = DOC_NOFORMULA.DOC_ID;
SELECT
BATCH_NO
FROM
PM_BTCH_HDR
WHERE BATCH_ID = DOC_ID;
SELECT
PRH.RECV_NO RECV_NO
FROM
PO_RECV_HDR PRH
WHERE PRH.RECV_ID = DOC_ID;
SELECT
CYCLE_NO
FROM
IC_CYCL_HDR
WHERE CYCLE_ID = DOC_ID;
SELECT
BOL_NO
FROM
OP_BILL_LAD
WHERE BOL_ID = DOC_ID;
SELECT
ORDER_NO
FROM
OP_ORDR_HDR
WHERE ORDER_ID = DOC_ID;
SELECT
PO_NO
FROM
PO_ORDR_HDR
WHERE PO_ID = DOC_ID;
SELECT
RETURN_NO
FROM
PO_RTRN_HDR
WHERE RETURN_ID = DOC_ID;
SELECT
HDR.ORDER_NUMBER,
ORG.NAME
FROM
OE_ORDER_HEADERS_ALL HDR,
OE_ORDER_LINES_ALL DTL,
HR_OPERATING_UNITS ORG
WHERE ORG.ORGANIZATION_ID = HDR.ORG_ID
AND DTL.LINE_ID = DOC_NOFORMULA.LINE_ID
AND DTL.HEADER_ID = HDR.HEADER_ID;
SELECT
RECEIPT_NUM
FROM
RCV_SHIPMENT_HEADERS
WHERE SHIPMENT_HEADER_ID = DOC_ID;
SELECT
TEST_TYPE
FROM
GMD_QC_TESTS_B
WHERE TEST_ID = QCASSY_TYP_ID;
SELECT
DECODE(L_ASSAY_TYPE
,'U'
,A.TARGET_VALUE_CHAR
,'V'
,A.TARGET_VALUE_CHAR
,'N'
,TO_CHAR(A.TARGET_VALUE_NUM)),
A.MIN_VALUE_NUM,
A.MAX_VALUE_NUM
FROM
GMD_SPEC_TESTS_B A,
GMD_QC_TESTS_B B
WHERE A.SPEC_ID = QC_SPEC_ID
AND A.TEST_ID = B.TEST_ID;
SELECT
ITEM_UM,
ITEM_UM2
INTO L_UOM,UOM2
FROM
IC_ITEM_MST
WHERE ITEM_ID = ITEM_ID1;
select count(*) into n
from gmd_results a, gmd_spec_results b, gmd_samples c
where nvl(b.evaluation_ind,'N') in ('0A','1V')
and a.result_id = b.result_id
and a.sample_id = c.sample_id
and a.sample_id not in (select sample_id from gmd_samples where
(supplier_id is not null or cust_id is not null) or
(batch_id is not null or formula_id is not null or
routing_id is not null or oprn_id is not null))
and a.delete_mark = 0
and c.item_id = M_6FormatTrigger.item_id
and c.lot_id = M_6FormatTrigger.lot_id;
SELECT count(*) into n
from GMI_LOTS_COMP_v
where product_item_id = M_5FormatTrigger.item_id
and product_lot_id = M_5FormatTrigger.lot_id;
SELECT count(*) into n
from GMI_LOTS_DEST_v
where ingred_item_id = M_5FormatTrigger.item_id
and ingred_lot_id = M_5FormatTrigger.lot_id;