[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
claim_id
,object_version_number
,last_update_date
,last_updated_by
,creation_date
,created_by
,last_update_login
,request_id
,program_application_id
,program_update_date
,program_id
,created_from
,batch_id
,claim_number
,claim_type_id
,claim_class
,claim_date
,due_date
,owner_id
,history_event
,history_event_date
,history_event_description
,split_from_claim_id
,duplicate_claim_id
,split_date
,root_claim_id
,amount
,amount_adjusted
,amount_remaining
,amount_settled
,acctd_amount
,acctd_amount_remaining
,tax_amount
,tax_code
,tax_calculation_flag
,currency_code
,exchange_rate_type
,exchange_rate_date
,exchange_rate
,set_of_books_id
,original_claim_date
,source_object_id
,source_object_class
,source_object_type_id
,source_object_number
,cust_account_id
,cust_billto_acct_site_id
,cust_shipto_acct_site_id
,location_id
,pay_related_account_flag
,related_cust_account_id
,related_site_use_id
,relationship_type
,vendor_id
,vendor_site_id
,reason_type
,reason_code_id
,task_template_group_id
,status_code
,user_status_id
,sales_rep_id
,collector_id
,contact_id
,broker_id
,territory_id
,customer_ref_date
,customer_ref_number
,assigned_to
,receipt_id
,receipt_number
,doc_sequence_id
,doc_sequence_value
,gl_date
,payment_method
,voucher_id
,voucher_number
,payment_reference_id
,payment_reference_number
,payment_reference_date
,payment_status
,approved_flag
,approved_date
,approved_by
,settled_date
,settled_by
,effective_date
,custom_setup_id
,task_id
,country_id
,comments
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,deduction_attribute_category
,deduction_attribute1
,deduction_attribute2
,deduction_attribute3
,deduction_attribute4
,deduction_attribute5
,deduction_attribute6
,deduction_attribute7
,deduction_attribute8
,deduction_attribute9
,deduction_attribute10
,deduction_attribute11
,deduction_attribute12
,deduction_attribute13
,deduction_attribute14
,deduction_attribute15
,org_id
,order_type_id
INTO
x_claim_rec.claim_id
,x_claim_rec.object_version_number
,x_claim_rec.last_update_date
,x_claim_rec.last_updated_by
,x_claim_rec.creation_date
,x_claim_rec.created_by
,x_claim_rec.last_update_login
,x_claim_rec.request_id
,x_claim_rec.program_application_id
,x_claim_rec.program_update_date
,x_claim_rec.program_id
,x_claim_rec.created_from
,x_claim_rec.batch_id
,x_claim_rec.claim_number
,x_claim_rec.claim_type_id
,x_claim_rec.claim_class
,x_claim_rec.claim_date
,x_claim_rec.due_date
,x_claim_rec.owner_id
,x_claim_rec.history_event
,x_claim_rec.history_event_date
,x_claim_rec.history_event_description
,x_claim_rec.split_from_claim_id
,x_claim_rec.duplicate_claim_id
,x_claim_rec.split_date
,x_claim_rec.root_claim_id
,x_claim_rec.amount
,x_claim_rec.amount_adjusted
,x_claim_rec.amount_remaining
,x_claim_rec.amount_settled
,x_claim_rec.acctd_amount
,x_claim_rec.acctd_amount_remaining
,x_claim_rec.tax_amount
,x_claim_rec.tax_code
,x_claim_rec.tax_calculation_flag
,x_claim_rec.currency_code
,x_claim_rec.exchange_rate_type
,x_claim_rec.exchange_rate_date
,x_claim_rec.exchange_rate
,x_claim_rec.set_of_books_id
,x_claim_rec.original_claim_date
,x_claim_rec.source_object_id
,x_claim_rec.source_object_class
,x_claim_rec.source_object_type_id
,x_claim_rec.source_object_number
,x_claim_rec.cust_account_id
,x_claim_rec.cust_billto_acct_site_id
,x_claim_rec.cust_shipto_acct_site_id
,x_claim_rec.location_id
,x_claim_rec.pay_related_account_flag
,x_claim_rec.related_cust_account_id
,x_claim_rec.related_site_use_id
,x_claim_rec.relationship_type
,x_claim_rec.vendor_id
,x_claim_rec.vendor_site_id
,x_claim_rec.reason_type
,x_claim_rec.reason_code_id
,x_claim_rec.task_template_group_id
,x_claim_rec.status_code
,x_claim_rec.user_status_id
,x_claim_rec.sales_rep_id
,x_claim_rec.collector_id
,x_claim_rec.contact_id
,x_claim_rec.broker_id
,x_claim_rec.territory_id
,x_claim_rec.customer_ref_date
,x_claim_rec.customer_ref_number
,x_claim_rec.assigned_to
,x_claim_rec.receipt_id
,x_claim_rec.receipt_number
,x_claim_rec.doc_sequence_id
,x_claim_rec.doc_sequence_value
,x_claim_rec.gl_date
,x_claim_rec.payment_method
,x_claim_rec.voucher_id
,x_claim_rec.voucher_number
,x_claim_rec.payment_reference_id
,x_claim_rec.payment_reference_number
,x_claim_rec.payment_reference_date
,x_claim_rec.payment_status
,x_claim_rec.approved_flag
,x_claim_rec.approved_date
,x_claim_rec.approved_by
,x_claim_rec.settled_date
,x_claim_rec.settled_by
,x_claim_rec.effective_date
,x_claim_rec.custom_setup_id
,x_claim_rec.task_id
,x_claim_rec.country_id
,x_claim_rec.comments
,x_claim_rec.attribute_category
,x_claim_rec.attribute1
,x_claim_rec.attribute2
,x_claim_rec.attribute3
,x_claim_rec.attribute4
,x_claim_rec.attribute5
,x_claim_rec.attribute6
,x_claim_rec.attribute7
,x_claim_rec.attribute8
,x_claim_rec.attribute9
,x_claim_rec.attribute10
,x_claim_rec.attribute11
,x_claim_rec.attribute12
,x_claim_rec.attribute13
,x_claim_rec.attribute14
,x_claim_rec.attribute15
,x_claim_rec.deduction_attribute_category
,x_claim_rec.deduction_attribute1
,x_claim_rec.deduction_attribute2
,x_claim_rec.deduction_attribute3
,x_claim_rec.deduction_attribute4
,x_claim_rec.deduction_attribute5
,x_claim_rec.deduction_attribute6
,x_claim_rec.deduction_attribute7
,x_claim_rec.deduction_attribute8
,x_claim_rec.deduction_attribute9
,x_claim_rec.deduction_attribute10
,x_claim_rec.deduction_attribute11
,x_claim_rec.deduction_attribute12
,x_claim_rec.deduction_attribute13
,x_claim_rec.deduction_attribute14
,x_claim_rec.deduction_attribute15
,x_claim_rec.org_id
,x_claim_rec.order_type_id
FROM ozf_claims
WHERE claim_id = p_claim_id ;
SELECT claim_line_id
, source_object_class
, source_object_id
, source_object_line_id
, item_id
, quantity
, quantity_uom
, rate
, claim_currency_amount
, tax_code
, payment_status
FROM ozf_claim_lines
WHERE claim_id = cv_claim_id;
SELECT reason_code
FROM ozf_reason_codes_vl
WHERE reason_code_id = cv_reason_code_id;
SELECT default_inbound_line_type_id
FROM oe_transaction_types_vl
WHERE transaction_type_id = cv_order_type_id;
SELECT rctl.customer_trx_line_id
FROM ra_customer_trx_lines rctl
, oe_order_lines ol
WHERE rctl.customer_trx_line_id = cv_invoice_line_id
AND TO_NUMBER(rctl.interface_line_attribute6) = ol.line_id;
SELECT cust_account_role_id
FROM hz_cust_account_roles
WHERE party_id = cv_party_id;
SELECT ql.list_price
FROM qp_list_lines ql
, qp_pricing_attributes atr
WHERE ql.list_line_id = atr.list_line_id
AND atr.product_attribute_context = 'ITEM'
AND atr.product_attribute = 'PRICING_ATTRIBUTE1'
AND atr.product_attr_value = TO_CHAR(cv_item_id) --ninarasi fix for bug 12939639
AND atr.list_header_id = cv_price_list_id
AND atr.excluder_flag = 'N';
SELECT sales_credit_type_id
FROM ra_salesreps
WHERE salesrep_id = cv_salesrep_id;
SELECT unit_selling_price
FROM oe_order_lines_all
WHERE line_id = cv_line_id;
SELECT list_header_id
FROM qp_list_lines
WHERE list_line_id = cv_list_line_id;
SELECT order_source_id
FROM oe_order_sources
WHERE order_source_id = cv_order_source_id;
l_header_rec.operation := OE_GLOBALS.g_opr_update;
l_line_tbl(i).operation := OE_GLOBALS.g_opr_update;
l_line_adj_tbl(l_adj_idx).updated_flag := 'Y';
| 6. Update RMA order information in Claim after order is
| been successfully created.
*------------------------------------------------------*/
UPDATE ozf_claims_all
SET payment_reference_id = l_x_header_rec.header_id
, payment_reference_number = l_x_header_rec.order_number
, payment_reference_date = l_x_header_rec.ordered_date
WHERE claim_id = p_x_claim_rec.claim_id;
UPDATE ozf_claim_lines_all
SET payment_reference_id = l_x_line_tbl(i).line_id
, payment_reference_number = l_x_line_tbl(i).line_number
WHERE claim_line_id = p_claim_line_tbl(i).claim_line_id;
UPDATE ozf_claim_lines_all
SET payment_status = 'PENDING'
WHERE claim_id = p_claim_id;