The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT returnable_flag, customer_order_enabled_flag, serviceable_product_flag FROM MTL_SYSTEM_ITEMS_B
WHERE inventory_item_id = l_inv_item_id
AND organization_id = p_qte_line_rec.organization_id;
SELECT inventory_item_id, line_category_code from aso_quote_lines_all
where quote_line_id = p_qte_line_rec.quote_line_id;
SELECT item_type_code FROM aso_quote_lines_all
WHERE quote_line_id = p_qte_line_rec.quote_line_id;
SELECT count(related_quote_line_id) FROM aso_line_relationships
WHERE quote_line_id = p_qte_line_rec.quote_line_id
AND relationship_type_code = 'SERVICE';
SELECT start_date_active, end_date_active
FROM OE_WF_LINE_ASSIGN_V
WHERE order_type_id = p_qte_header_rec.order_type_id
and line_type_id = p_qte_line_rec.order_line_type_id
and (trunc(sysdate) BETWEEN NVL(start_date_active, sysdate) AND
NVL(end_date_active, sysdate));
IF p_qte_line_rec.operation_code = 'UPDATE' then
OPEN C_inventory_item;
end if; -- end check update operation.
aso_debug_pub.add('Line category code after update check = ' || l_line_category_code, 2, 'N');
aso_debug_pub.add('inventory item after update check = ' || l_inventory_item_id,2, 'N');
IF p_qte_line_rec.operation_code = 'UPDATE' AND
l_serviceable_product_flag = 'Y' THEN
/* p_qte_line_rec.item_type_code = 'SVA' THEN */
OPEN C_Service_Available;
IF p_qte_line_rec.operation_code = 'UPDATE' THEN
IF p_qte_line_rec.item_type_code <> 'CFG' AND
p_qte_line_rec.item_type_code IS NOT NULL AND
p_qte_line_rec.item_type_code <> FND_API.G_MISS_CHAR THEN
x_return_status := FND_API.G_RET_STS_ERROR;
END IF; -- 'UPDATE'
SELECT order_category_code, start_date_active, end_date_active
--FROM OE_TRANSACTION_TYPES_ALL Commented Code yogeshwar (MOAC)
FROM OE_TRANSACTION_TYPES_VL --New Code Yogeshwar (MOAC)
WHERE transaction_type_id = l_order_type_id
and Transaction_type_code = 'ORDER' ;
SELECT order_category_code, start_date_active, end_date_active
--FROM OE_TRANSACTION_TYPES_ALL Commented Code yogeshwar (MOAC)
FROM OE_TRANSACTION_TYPES_VL --New Code Yogeshwar (MOAC)
WHERE transaction_type_id = l_order_line_type_id
and Transaction_type_code = 'LINE' ;
SELECT a.inventory_item_id, a.quantity, a.unit_of_measure,
a.last_oe_order_line_id, b.bom_item_type, b.returnable_flag
FROM CSI_ITEM_INSTANCES a, MTL_SYSTEM_ITEMS_B b
WHERE a.inventory_item_id = b.inventory_item_id
AND a.instance_id = l_instance_id
AND b.organization_id = l_organization_id;
SELECT subject_id
FROM CSI_II_RELATIONSHIPS
WHERE relationship_type_code='COMPONENT-OF'
START WITH object_id = l_instance_id
CONNECT BY object_id = prior subject_id;
SELECT 'Y'
FROM ASO_QUOTE_LINES_ALL a, ASO_QUOTE_LINE_DETAILS b
WHERE a.quote_line_id = b.quote_line_id
AND a.quote_header_id = l_header_id
AND b.instance_id = l_instance_id;
SELECT header_id
FROM OE_ORDER_LINES_ALL
WHERE line_id = l_line_id;
SELECT org_id
FROM ASO_QUOTE_HEADERS_ALL
WHERE quote_header_id = l_header_id;
aso_debug_pub.add('p_qte_header_rec.last_update_date = '||
to_char(p_qte_header_rec.last_update_date,'DD-MM-YYYY HH:MI:SS'),1,'N');
aso_debug_pub.add('Add_Lines_from_InstallBase - calling ASO_QUOTE_PUB.Update_Quote: ', 1, 'N');
ASO_QUOTE_PUB.Update_Quote(
p_api_version_number => 1.0,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
p_control_rec => l_control_rec,
p_qte_header_rec => p_qte_header_rec,
P_Qte_Line_Tbl => l_Qte_Line_Tbl,
P_Qte_Line_dtl_Tbl => l_Qte_Line_dtl_Tbl,
P_ln_Shipment_Tbl => l_ln_shipment_tbl,
X_Qte_Header_Rec => x_qte_header_rec,
X_Qte_Line_Tbl => x_Qte_Line_Tbl,
X_Qte_Line_Dtl_Tbl => x_Qte_Line_Dtl_Tbl,
X_hd_Price_Attributes_Tbl => lx_hd_Price_Attr_Tbl,
X_hd_Payment_Tbl => lx_hd_Payment_Tbl,
X_hd_Shipment_Tbl => lx_hd_Shipment_Tbl,
X_hd_Freight_Charge_Tbl => lx_hd_Freight_Charge_Tbl,
X_hd_Tax_Detail_Tbl => lx_hd_Tax_Detail_Tbl,
X_hd_Attr_Ext_Tbl => lX_hd_Attr_Ext_Tbl,
X_hd_Sales_Credit_Tbl => lx_hd_Sales_Credit_Tbl,
X_hd_Quote_Party_Tbl => lx_Quote_Party_Tbl,
X_Line_Attr_Ext_Tbl => lx_Line_Attr_Ext_Tbl,
X_line_rltship_tbl => lx_line_rltship_tbl,
X_Price_Adjustment_Tbl => lx_Price_Adjustment_Tbl,
X_Price_Adj_Attr_Tbl => lx_Price_Adj_Attr_Tbl,
X_Price_Adj_Rltship_Tbl => lx_Price_Adj_Rltship_Tbl,
X_ln_Price_Attributes_Tbl => lx_ln_Price_Attr_Tbl,
X_ln_Payment_Tbl => lx_ln_Payment_Tbl,
X_ln_Shipment_Tbl => x_ln_Shipment_Tbl,
X_ln_Freight_Charge_Tbl => lx_ln_Freight_Charge_Tbl,
X_ln_Tax_Detail_Tbl => lx_ln_Tax_Detail_Tbl,
X_Ln_Sales_Credit_Tbl => lX_Ln_Sales_Credit_Tbl,
X_Ln_Quote_Party_Tbl => lX_Ln_Quote_Party_Tbl,
X_Return_Status => x_Return_Status,
X_Msg_Count => x_Msg_Count,
X_Msg_Data => x_Msg_Data);
aso_debug_pub.add('Add_Lines_from_InstallBase - after update_quote: x_ret_status: '||x_return_status, 1, 'N');
aso_debug_pub.add('x_qte_header_rec.last_update_date = '||
to_char(x_qte_header_rec.last_update_date,'DD-MM-YYYY HH:MI:SS'),1,'N');
SELECT instance_id, return_ref_type, return_ref_line_id
FROM ASO_QUOTE_LINE_DETAILS
WHERE quote_line_id = l_line_id;
SELECT quantity
FROM ASO_QUOTE_LINES_ALL
WHERE quote_line_id = l_line_id;
SELECT ordered_quantity
FROM OE_ORDER_LINES_ALL
WHERE line_id = l_line_id;
SELECT quantity
FROM CSI_ITEM_INSTANCES
WHERE instance_id = l_inst_id;
SELECT last_oe_order_line_id
FROM CSI_ITEM_INSTANCES
WHERE instance_id = l_inst_id;
IF p_qte_line_rec.operation_code = 'UPDATE' THEN
OPEN C_Get_Dtl_Info(p_qte_line_rec.quote_line_id);