The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
TRANSACTION_SOURCE_TYPE_NAME
INTO SOURCE_TYPE_NAME
FROM
MTL_TXN_SOURCE_TYPES
WHERE TRANSACTION_SOURCE_TYPE_ID = SOURCE_TYPE_ID;
if P_TXN_SRC_TYPE_ID = 1 then select segment1 into txn_source
from po_headers_all
where po_header_id = to_number(txn_source_id);
select wip_entity_name into txn_source
from wip_entities
where wip_entity_id = to_number(txn_source_id);
elsif P_TXN_SRC_TYPE_ID = 7 then select segment1 into txn_source
from po_requisition_headers_all
where requisition_header_id =
txn_source_id;
select CYCLE_COUNT_HEADER_NAME into txn_source
from mtl_cycle_count_headers
where cycle_count_header_id = to_number(txn_source_id)
and organization_id = org_id;
select physical_inventory_name into txn_source
from mtl_physical_inventories
where physical_inventory_id = to_number(txn_source_id)
and organization_id = org_id;
select description into txn_source
from cst_cost_updates
where cost_update_id = to_number(txn_source_id)
and organization_id = org_id;
SELECT
FRV.RESPONSIBILITY_NAME,
TO_CHAR(FCR.REQUEST_DATE
,'YYYY/MM/DD HH24:MI:SS'),
FAV.APPLICATION_NAME,
FU.USER_NAME
INTO CP_RESPONSIBILITY,CP_REQUEST_TIME,CP_APPLICATION,CP_REQUESTED_BY
FROM
FND_CONCURRENT_REQUESTS FCR,
FND_RESPONSIBILITY_VL FRV,
FND_APPLICATION_VL FAV,
FND_USER FU
WHERE FCR.REQUEST_ID = P_CONC_REQUEST_ID
AND FCR.RESPONSIBILITY_APPLICATION_ID = FRV.APPLICATION_ID
AND FCR.RESPONSIBILITY_ID = FRV.RESPONSIBILITY_ID
AND FRV.APPLICATION_ID = FAV.APPLICATION_ID
AND FU.USER_ID = FCR.REQUESTED_BY;
SELECT
DISTINCT
XFI.NAME,
CCG.COST_GROUP,
CCT.COST_TYPE,
NVL(FC.PRECISION
,2),
NVL(FC.EXTENDED_PRECISION
,5),
CPP.PERIOD_NAME
INTO CP_LEGAL_ENTITY,CP_COST_GROUP,CP_COST_TYPE,CP_PRECISION,CP_EXT_PRECISION,CP_PERIOD_NAME
FROM
CST_PAC_PERIODS CPP,
XLE_FIRSTPARTY_INFORMATION_V XFI,
FND_CURRENCIES FC,
CST_COST_GROUPS CCG,
CST_COST_TYPES CCT
WHERE XFI.LEGAL_ENTITY_ID = P_LEGAL_ENTITY_ID
AND CPP.PAC_PERIOD_ID = P_PERIOD_ID
AND FC.CURRENCY_CODE = P_CURRENCY_CODE
AND CCG.COST_GROUP_ID = P_COST_GROUP_ID
AND CCT.COST_TYPE_ID = P_COST_TYPE_ID;
,'Failed in MSTK/Select')*/NULL;
,'Failed in GL#/Select')*/NULL;
SELECT
MEANING
INTO CP_SORT_BY_COV
FROM
MFG_LOOKUPS
WHERE LOOKUP_TYPE = 'CST_SRS_PAC_BOM_CSTRPMDD_XMLP_PKG_SORT'
AND LOOKUP_CODE = P_SORT_ID;
SELECT
MEANING
INTO CP_TYPE_OPTION_COV
FROM
MFG_LOOKUPS
WHERE LOOKUP_TYPE = 'INV_SRS_DST_TYPE'
AND LOOKUP_CODE = P_TYPE_OPTION
AND ENABLED_FLAG = 'Y';
RETURN ('AND mmt.transaction_source_id = cst.cost_update_id
AND cst.description BETWEEN ''' || P_SOURCE_LO || ''' AND ''' || P_SOURCE_HI || ''' ');
RETURN ('AND mmt.transaction_source_id = cst.cost_update_id
AND cst.description BETWEEN >= ''' || P_SOURCE_LO || ''' ');
RETURN ('AND mmt.transaction_source_id = cst.cost_update_id
AND cst.description <= ''' || P_SOURCE_HI || ''' ');
SELECT
CATEGORY_SET_NAME
INTO CAT_SET_NAME
FROM
MTL_CATEGORY_SETS
WHERE CATEGORY_SET_ID = CAT_SET_ID;
SELECT
TRANSACTION_TYPE_NAME
INTO TXN_TYPE_NAME
FROM
MTL_TRANSACTION_TYPES
WHERE TRANSACTION_TYPE_ID = TXN_TYPE_ID;
SELECT
REASON_NAME
INTO REASON_NAME
FROM
MTL_TRANSACTION_REASONS
WHERE REASON_ID = TXN_REASON_ID;
RETURN (', cst_cost_updates cst');
SELECT
CAH.AE_CATEGORY,
CAH.ACCOUNTING_EVENT_ID,
CAL.PO_DISTRIBUTION_ID
INTO L_EVENT_TYPE,L_TRANSACTION_ID,L_PO_DISTRIBUTION_ID
FROM
CST_AE_HEADERS CAH,
CST_AE_LINES CAL
WHERE CAL.AE_LINE_ID = L_AE_LINE_ID
AND CAH.AE_HEADER_ID = CAL.AE_HEADER_ID;
SELECT
PERIOD_END_DATE
INTO L_PERIOD_END_DATE
FROM
CST_PAC_PERIODS CPP
WHERE CPP.PAC_PERIOD_ID = P_PERIOD_ID;
SELECT
DECODE(POLL.MATCHING_BASIS
,'AMOUNT'
,1
,0),
POLL.LINE_LOCATION_ID,
DECODE(POLL.MATCHING_BASIS
,'AMOUNT'
,POLL.AMOUNT - NVL(POLL.AMOUNT_CANCELLED
,0)
,POLL.QUANTITY - NVL(POLL.QUANTITY_CANCELLED
,0)),
DECODE(POLL.MATCHING_BASIS
,'AMOUNT'
,POD.AMOUNT_ORDERED - NVL(POD.AMOUNT_CANCELLED
,0)
,POD.QUANTITY_ORDERED - NVL(POD.QUANTITY_CANCELLED
,0)),
NVL(POLL.MATCH_OPTION
,'P')
INTO L_SERVICE_FLAG,L_PO_LINE_LOCATION_ID,L_SHIPMENT_QTY,L_DIST_QTY,L_MATCH_OPTION
FROM
PO_DISTRIBUTIONS_ALL POD,
PO_LINE_LOCATIONS_ALL POLL,
PO_LINES_ALL POL
WHERE POD.PO_DISTRIBUTION_ID = L_PO_DISTRIBUTION_ID
AND POD.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID
AND POLL.PO_LINE_ID = POL.PO_LINE_ID
AND NVL(POLL.ACCRUE_ON_RECEIPT_FLAG
,'N') = 'N';
SELECT
DECODE(CAL.ACCOUNTED_DR
,NULL
,-1 * L_ACCRUAL_QTY
,L_ACCRUAL_QTY)
INTO L_TXN_QUANTITY
FROM
CST_AE_LINES CAL
WHERE CAL.AE_LINE_ID = L_AE_LINE_ID;