The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT hzpty.party_name
FROM hz_cust_accounts hzacct,
hz_cust_account_roles hzrole,
hz_parties hzpty
WHERE hzacct.account_number = l_account_number
AND hzrole.cust_account_id = hzacct.cust_account_id
AND hzpty.party_id = hzrole.party_id;
SELECT CIR.OBJECT_ID
FROM CSI_II_RELATIONSHIPS CIR
START WITH Object_Id = P_Object_ID
CONNECT BY PRIOR OBJECT_ID = SUBJECT_ID
ORDER BY OBJECT_ID;
SELECT CII.INSTANCE_NUMBER REFERENCE,
CII.SERIAL_NUMBER SERIAL,
CII.LOT_NUMBER LOT,
MSIK.CONCATENATED_SEGMENTS PRODUCT,
MSIK.DESCRIPTION DESCRIPTION
FROM CSI_ITEM_INSTANCES CII,
MTL_SYSTEM_ITEMS_KFV MSIK
WHERE MSIK.INVENTORY_ITEM_ID = CII.INVENTORY_ITEM_ID
AND CII.INSTANCE_ID = P_INSTANCE_ID
AND MSIK.ORGANIZATION_ID = CII.INV_MASTER_ORGANIZATION_ID;
SELECT MSIK.Concatenated_Segments,
MSIK.DESCRIPTION,
CII.Instance_Number,
CII.Serial_Number,
CII.Lot_Number
FROM CSI_Item_Instances CII,
MTL_SYSTEM_ITEMS_KFV MSIK
WHERE CII.Instance_Id = P_Customer_Product_Id
AND CII.Inventory_Item_Id = MSIK.Inventory_Item_ID
AND CII.Inv_Master_Organization_Id = MSIK.Organization_Id;
SELECT Subject_ID
FROM CSI_II_RELATIONSHIPS
WHERE OBJECT_ID = P_Customer_Product_Id
AND ACTIVE_END_DATE IS NULL;
SELECT CII.Instance_Id,
CIIR.OBJECT_ID,
CIIR.RELATIONSHIP_TYPE_CODE,
CII.OWNER_PARTY_ACCOUNT_ID,
CII.INVENTORY_ITEM_ID,
CII.SERIAL_NUMBER,
CII.LOT_NUMBER
FROM CSI_ITEM_INSTANCES CII,
CSI_II_RELATIONSHIPS CIIR
WHERE CII.INSTANCE_ID = CIIR.SUBJECT_ID
AND l_AS_OF_DATE BETWEEN NVL(CIIR.ACTIVE_START_DATE,l_As_Of_Date-1) AND NVL(CIIR.ACTIVE_END_DATE,l_As_Of_Date+1)
CONNECT BY PRIOR CIIR.SUBJECT_ID = CIIR.OBJECT_ID;
SELECT Instance_Number,
serial_number
INTO l_reference_number,
l_curr_serial_number
FROM csi_Item_Instances
WHERE Instance_id = c1.customer_product_id;
l_config_tbl.DELETE;
SELECT Instance_Number,
serial_number
INTO l_reference_number,
l_curr_serial_number
FROM csi_Item_Instances
WHERE Instance_id = c1.customer_product_id;
l_config_tbl.DELETE;
SELECT CIR.OBJECT_ID
FROM CSI_II_RELATIONSHIPS CIR
START WITH Object_Id = P_Object_ID
CONNECT BY PRIOR OBJECT_ID = SUBJECT_ID
ORDER BY OBJECT_ID;