[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'x' col1
FROM CSD_REPAIR_ESTIMATE_V
WHERE repair_estimate_id = p_estimate_id
AND repair_line_id = p_repair_line_id
AND NVL(ESTIMATE_FREEZE_FLAG, 'N') = 'N';
SELECT 1 col1
FROM fnd_lookup_values_vl
WHERE lookup_type = 'CSD_ESTIMATE_STATUS'
AND enabled_flag = 'Y'
AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE)) AND
TRUNC(NVL(end_date_active, SYSDATE))
AND lookup_code = p_estimate_status;
SELECT 1 col1
FROM fnd_lookup_values_vl
WHERE lookup_type = DECODE(p_status,
C_EST_STATUS_REJECTED,
'CSD_REJECT_REASON',
C_EST_STATUS_ACCEPTED,
'CSD_REASON')
AND enabled_flag = 'Y'
AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE)) AND
TRUNC(NVL(end_date_active, SYSDATE))
AND lookup_code = p_reason_code;
SELECT 1 col1
FROM fnd_lookup_values_vl
WHERE lookup_type = 'CSD_UNIT_OF_MEASURE'
AND enabled_flag = 'Y'
AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE)) AND
TRUNC(NVL(end_date_active, SYSDATE))
AND lookup_code = p_lead_time_uom;
SELECT 1 col1
FROM mtl_item_uoms_view
WHERE inventory_item_id = p_item_id
AND organization_id = Cs_Std.get_item_valdn_orgzn_id
AND uom_type =
(SELECT allowed_units_lookup_code
FROM mtl_system_items_b
WHERE organization_id = Cs_Std.get_item_valdn_orgzn_id
AND inventory_item_id = p_item_id)
AND uom_code = p_uom_code;
SELECT 1 col1
FROM oe_price_lists
WHERE price_list_id = p_price_list_id;
SELECT A.ORDER_NUMBER
FROM oe_order_headers_all A
WHERE A.HEADER_ID = p_order_header_id;
SELECT INSTANCE_NUMBER
FROM CSI_ITEM_INSTANCES
WHERE INSTANCE_ID = p_instance_id;
SELECT 1 col1
FROM mtl_item_revisions
WHERE revision = p_revision
AND inventory_item_id = p_item_id
AND organization_id = p_org_id;
SELECT 1 col1
FROM mtl_serial_numbers
WHERE serial_number = p_serial_number
AND inventory_item_id = p_item_id;
SELECT 1 col1
FROM fnd_lookup_values
WHERE lookup_code = P_BILLING_TYPE
AND lookup_type = 'CSD_EST_BILLING_TYPE'
AND enabled_flag = 'Y'
AND LANGUAGE = 'US'
AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active, SYSDATE)) AND
TRUNC(NVL(end_date_active, SYSDATE));
SELECT 'x' col1
FROM csd_repairs
WHERE repair_line_id = p_repair_line_id
AND status <> l_C_STATUS_CLOSED;
SELECT 'x' col1
FROM cs_incidents_all_b A, cs_incident_statuses_b B
WHERE A.incident_id = p_incident_id
AND B.INCIDENT_STATUS_ID = A.INCIDENT_STATUS_ID
AND B.incident_subtype = 'INC'
AND TRUNC(SYSDATE) BETWEEN
TRUNC(NVL(B.start_date_active, SYSDATE)) AND
TRUNC(NVL(B.end_date_active, SYSDATE))
AND B.CLOSE_FLAG = 'Y';
SELECT 1 col1
FROM CSD_REPAIR_ESTIMATE
WHERE REPAIR_LINE_ID = p_repair_line_id
AND ROWNUM = 1;
SELECT A.QUANTITY, A.OBJECT_VERSION_NUMBER, B.SUMMARY, B.INCIDENT_ID
FROM CSD_REPAIRS A, CS_INCIDENTS_ALL_VL B
WHERE A.REPAIR_LINE_ID = p_repair_line_id
AND A.INCIDENT_ID = B.INCIDENT_ID;
IF (p_estimate_hdr_rec.last_update_date IS NOT NULL) then
x_est_pvt_hdr_rec.last_update_date := p_estimate_hdr_rec.last_update_date;
IF (p_estimate_hdr_rec.last_updated_by IS NOT NULL) then
x_est_pvt_hdr_rec.last_updated_by := p_estimate_hdr_rec.last_updated_by;
IF (p_estimate_hdr_rec.last_update_login IS NOT NULL) then
x_est_pvt_hdr_rec.last_update_login := p_estimate_hdr_rec.last_update_login;
/* DEscription: Creates the record required for private update api */
/* */
/* Change History : Created 25th June2005 by Vijay */
/*------------------------------------------------------------------------*/
PROCEDURE COPY_TO_EST_HDR_REC_UPD(p_estimate_hdr_rec IN Csd_Repair_Estimate_Pub.estimate_hdr_Rec,
x_est_pvt_hdr_rec OUT NOCOPY Csd_Repair_Estimate_Pvt.REPAIR_ESTIMATE_REC) IS
BEGIN
-- swai: bug 9462789
x_est_pvt_hdr_rec.repair_estimate_id := p_estimate_hdr_rec.repair_estimate_id;
SELECT NVL(ctt.no_charge_flag, 'N') no_charge_flag,
ctt.transaction_Type_id
FROM cs_txn_billing_types ctbt, cs_transaction_types ctt
WHERE ctbt.txn_billing_type_id = p_txn_billing_type_id
AND ctbt.transaction_type_id = ctt.transaction_type_id;
SELECT A.INCIDENT_ID,
A.CONTRACT_LINE_ID,
B.BUSINESS_PROCESS_ID,
B.REPAIR_TYPE_ID
FROM CSD_REPAIRS A, CSD_REPAIR_TYPES_B B
WHERE A.REPAIR_LINE_ID = p_repair_line_id
AND A.REPAIR_TYPE_ID = B.REPAIR_TYPE_ID;
SELECT HD.ID CONTRACT_ID, HD.CONTRACT_NUMBER
FROM OKC_K_HEADERS_B HD, OKC_K_LINES_B KL
WHERE HD.ID = KL.DNZ_CHR_ID
AND KL.CLE_ID = p_contract_line_id
AND ROWNUM = 1;
SELECT material_billable_flag
FROM mtl_system_items_b
WHERE inventory_item_id = p_item_id
AND organization_id = Cs_Std.GET_ITEM_VALDN_ORGZN_ID;
SELECT item_cost item_cost
FROM cst_item_costs a, cst_cost_types b
WHERE a.cost_type_id = b.cost_type_id
AND UPPER(b.cost_type) = 'FROZEN'
AND a.inventory_item_id = p_item_id
AND a.organization_id = Cs_Std.GET_ITEM_VALDN_ORGZN_ID;
SELECT txn_billing_type_id
FROM csd_repair_types_sar_vl
WHERE repair_type_id = p_repair_type_id
AND BILLING_CATEGORY = p_billing_Category
AND BILLING_TYPE = p_billing_Type;
SELECT instance_number, instance_id
FROM csi_item_instances
WHERE inventory_item_id = p_item_id
AND serial_number = p_serial_number;
SELECT DECODE(revision_qty_Control_code, 2, 'Y', 'N') revision_control,
DECODE(serial_number_control_Code, 1, 'N', '6', 'N', 'Y') serial_control,
comms_nl_trackable_Flag ib_control,
primary_uom_code,
material_billable_flag
FROM mtl_system_items_b
WHERE inventory_item_id = p_item_id
AND organization_id = Cs_Std.GET_ITEM_VALDN_ORGZN_ID;
IF (p_estimate_line_rec.last_update_date IS NOT NULL) then
x_est_pvt_line_rec.last_update_date := p_estimate_line_rec.last_update_date ;
IF (p_estimate_line_rec.last_updated_by IS NOT NULL) then
x_est_pvt_line_rec.last_updated_by := p_estimate_line_rec.last_updated_by ;
IF (p_estimate_line_rec.last_update_login IS NOT NULL) then
x_est_pvt_line_rec.last_update_login := p_estimate_line_rec.last_update_login ;