[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT scn_id
FROM okc_section_contents
WHERE id = p_scc_id;
SELECT id, LEVEL
FROM okc_sections_b
CONNECT BY PRIOR scn_id = id
START WITH id = p_scn_id;
SELECT id
FROM okc_k_accesses_v
WHERE chr_id = p_from_chr_id;
SELECT id
FROM okc_k_processes
WHERE chr_id = p_from_chr_id;
SELECT cgcv.id
FROM okc_k_grpings_v cgcv,
okc_k_groups_b cgpv
WHERE cgcv.included_chr_id = p_from_chr_id
AND cgcv.cgp_parent_id = cgpv.id
AND (cgpv.public_yn = 'Y' OR cgpv.user_id = fnd_global.user_id);
SELECT id
FROM okc_governances
WHERE dnz_chr_id = p_from_chr_id
AND cle_id IS NULL;
SELECT
DNZ_CHR_ID,
ISA_AGREEMENT_ID,
CHR_ID,
CLE_ID,
CHR_ID_REFERRED,
CLE_ID_REFERRED,
COPIED_ONLY_YN
FROM OKC_GOVERNANCES
WHERE ID = p_gve_id;
SELECT dnz_chr_id
FROM okc_k_lines_b
WHERE id = p_id;
SELECT id
FROM okc_article_trans
WHERE cat_id = p_id;
SELECT id
FROM okc_section_contents
WHERE cat_id = p_cat_id;
SELECT dnz_chr_id
FROM okc_k_lines_b
WHERE id = p_id;
SELECT id
FROM okc_contacts
WHERE cpl_id = p_cpl_id;
SELECT dnz_chr_id
FROM okc_k_lines_b
WHERE id = p_id;
SELECT price_uom
FROM oks_k_headers_b
WHERE chr_id = p_chr_id;
UPDATE oks_k_lines_b SET
trxn_extension_id = l_trx_ext_id
WHERE cle_id = p_cle_id;
SELECT dnz_chr_id, price_level_ind
FROM okc_k_lines_b
WHERE id = p_to_cle_id;
SELECT id
FROM okc_k_items
WHERE cle_id = p_from_cle_id;
SELECT application_id
FROM okc_k_headers_b
WHERE id = p_chr_id;
SELECT to_char(major_version)
FROM okc_k_vers_numbers
WHERE chr_id = p_chr_id;
SELECT dnz_chr_id
FROM okc_k_lines_b
WHERE id = p_to_cle_id;
SELECT id
FROM okc_price_att_values
WHERE cle_id = p_from_cle_id;
SELECT id
FROM okc_k_party_roles_b
WHERE cle_id = p_from_cle_id
AND rle_code <> 'LICENCEE_ACCT'
AND dnz_chr_id = p_from_chr_id;
SELECT lty_code,
priced_yn
FROM okc_line_styles_b
WHERE id = p_id;
SELECT id
FROM okc_k_items
WHERE cle_id = p_cle_id
AND priced_item_yn = 'Y';
SELECT a.object1_id1, b.standard_cov_yn
FROM okc_k_items a, oks_k_lines_b b
WHERE a.cle_id = p_old_cle_id
AND b.cle_id = p_old_cle_id;
SELECT Counter_Group_id
FROM OKX_CTR_ASSOCIATIONS_V
WHERE Source_Object_Id = p_id;
UPDATE oks_k_lines_b SET
coverage_id = l_actual_coverage_id
WHERE cle_id = p_new_cle_id;
SELECT start_date, end_date
FROM okc_k_lines_b
WHERE id = p_to_cle_id;
SELECT start_date, end_date
FROM okc_k_headers_b
WHERE id = p_to_chr_id;
SELECT id, currency_code
FROM okc_k_headers_b
WHERE id = (SELECT dnz_chr_id
FROM okc_k_lines_b
WHERE id = p_cle_id);
SELECT CONVERSION_TYPE, CONVERSION_RATE, CONVERSION_RATE_DATE
FROM okc_k_headers_b
WHERE id = p_chr_id;
select name
from okx_conversion_types_v
where id1 = p_id;
SELECT MAX(to_number(line_number))
FROM okc_k_lines_b
WHERE dnz_chr_id = p_id
AND cle_id IS NULL;
SELECT MAX(to_number(line_number))
FROM okc_k_lines_b
WHERE cle_id = p_id
AND lse_id IN (7, 8, 9, 10, 11, 35, 25);
l_olev_rec.SELECT_YN := 'Y';
SELECT ID,
CAT_ID,
CLE_ID,
RUL_ID,
DNZ_CHR_ID
FROM OKC_ARTICLE_TRANS_V
WHERE ID = p_atn_id;
SELECT ID,
CHR_ID,
CLE_ID,
CAT_ID,
SFWT_FLAG,
SAV_SAE_ID,
SAV_SAV_RELEASE,
SBT_CODE,
DNZ_CHR_ID,
COMMENTS,
FULLTEXT_YN,
VARIATION_DESCRIPTION,
NAME,
TEXT,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
CAT_TYPE
FROM OKC_K_ARTICLES_V
WHERE ID = p_cat_id;
SELECT ID,
CLE_ID,
CHR_ID,
CLE_ID_FOR,
DNZ_CHR_ID,
OBJECT1_ID1,
OBJECT1_ID2,
JTOT_OBJECT1_CODE,
UOM_CODE,
EXCEPTION_YN,
NUMBER_OF_ITEMS,
PRICED_ITEM_YN
FROM OKC_K_ITEMS_V
WHERE ID = p_cim_id;
SELECT ID,
GROUP_ID,
CHR_ID,
RESOURCE_ID,
ACCESS_LEVEL
FROM OKC_K_ACCESSES_V
WHERE ID = p_cac_id;
SELECT ID,
SFWT_FLAG,
CHR_ID,
CLE_ID,
RLE_CODE,
DNZ_CHR_ID,
OBJECT1_ID1,
OBJECT1_ID2,
JTOT_OBJECT1_CODE,
COGNOMEN,
CODE,
FACILITY,
MINORITY_GROUP_LOOKUP_CODE,
SMALL_BUSINESS_FLAG,
WOMEN_OWNED_FLAG,
ALIAS,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
FROM OKC_K_PARTY_ROLES_V
WHERE ID = p_cpl_id;
SELECT ID,
PDF_ID,
CHR_ID,
USER_ID,
CRT_ID,
PROCESS_ID,
IN_PROCESS_YN,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
FROM OKC_K_PROCESSES_V
WHERE ID = p_cps_id;
SELECT ID,
CGP_PARENT_ID,
INCLUDED_CHR_ID,
INCLUDED_CGP_ID
FROM OKC_K_GRPINGS_V
WHERE ID = p_cgc_id;
SELECT ID,
SFWT_FLAG,
ACN_ID,
COUNTER_GROUP_ID,
DESCRIPTION,
SHORT_DESCRIPTION,
COMMENTS,
ONE_TIME_YN,
NAME,
CONDITION_VALID_YN,
BEFORE_AFTER,
TRACKED_YN,
CNH_VARIANCE,
DNZ_CHR_ID,
TEMPLATE_YN,
DATE_ACTIVE,
OBJECT_ID,
DATE_INACTIVE,
JTOT_OBJECT_CODE,
TASK_OWNER_ID,
CNH_TYPE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
FROM OKC_CONDITION_HEADERS_V
WHERE ID = p_cnh_id;
SELECT ID,
SFWT_FLAG,
START_AT,
CNH_ID,
PDF_ID,
AAE_ID,
LEFT_CTR_MASTER_ID,
RIGHT_CTR_MASTER_ID,
LEFT_COUNTER_ID,
RIGHT_COUNTER_ID,
DNZ_CHR_ID,
SORTSEQ,
CNL_TYPE,
DESCRIPTION,
LEFT_PARENTHESIS,
RELATIONAL_OPERATOR,
RIGHT_PARENTHESIS,
LOGICAL_OPERATOR,
TOLERANCE,
RIGHT_OPERAND,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
FROM OKC_CONDITION_LINES_V
WHERE ID = p_cnl_id;
SELECT ID,
CPL_ID,
CRO_CODE,
DNZ_CHR_ID,
CONTACT_SEQUENCE,
OBJECT1_ID1,
OBJECT1_ID2,
JTOT_OBJECT1_CODE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
FROM OKC_CONTACTS_V
WHERE ID = p_ctc_id;
SELECT
id
,cle_id
,dnz_chr_id
,discount_list
,acct_rule_id
,payment_type
,cc_no
,cc_expiry_date
,cc_bank_acct_id
,cc_auth_code
,commitment_id
,locked_price_list_id
,usage_est_yn
,usage_est_method
,usage_est_start_date
,termn_method
,ubt_amount
,credit_amount
,suppressed_credit
,override_amount
,cust_po_number_req_yn
,cust_po_number
,grace_duration
,grace_period
,inv_print_flag
,price_uom
,tax_amount
,tax_inclusive_yn
,tax_status
,tax_code
,tax_exemption_id
,ib_trans_type
,ib_trans_date
,prod_price
,service_price
,clvl_list_price
,clvl_quantity
,clvl_extended_amt
,clvl_uom_code
,toplvl_operand_code
,toplvl_operand_val
,toplvl_quantity
,toplvl_uom_code
,toplvl_adj_price
,toplvl_price_qty
,averaging_interval
,settlement_interval
,minimum_quantity
,default_quantity
,amcv_flag
,fixed_quantity
,usage_duration
,usage_period
,level_yn
,usage_type
,uom_quantified
,base_reading
,billing_schedule_type
,full_credit
,locked_price_list_line_id
,break_uom
,prorate
,coverage_type
,exception_cov_id
,limit_uom_quantified
,discount_amount
,discount_percent
,offset_duration
,offset_period
,incident_severity_id
,pdf_id
,work_thru_yn
,react_active_yn
,transfer_option
,prod_upgrade_yn
,inheritance_type
,pm_program_id
,pm_conf_req_yn
,pm_sch_exists_yn
,allow_bt_discount
,apply_default_timezone
,sync_date_install
,sfwt_flag
,invoice_text
,ib_trx_details
,status_text
,react_time_name
,object_version_number
,security_group_id
,request_id
,created_by
,creation_date
,last_updated_by
,last_update_date
,last_update_login
,trxn_extension_id
,tax_classification_code
,exempt_certificate_number
,exempt_reason_code
,coverage_id
,standard_cov_yn
,orig_system_id1
,orig_system_reference1
,orig_system_source_code
,counter_value_id
FROM OKS_K_LINES_V
WHERE cle_id = cp_cle_id;
,x_klnv_rec.last_updated_by
,x_klnv_rec.last_update_date
,x_klnv_rec.last_update_login
,x_klnv_rec.trxn_extension_id
,x_klnv_rec.tax_classification_code
,x_klnv_rec.exempt_certificate_number
,x_klnv_rec.exempt_reason_code
,x_klnv_rec.coverage_id
,x_klnv_rec.standard_cov_yn
,x_klnv_rec.orig_system_id1
,x_klnv_rec.orig_system_reference1
,x_klnv_rec.orig_system_source_code
,x_klnv_rec.counter_value_id;
SELECT
id
,object_version_number
,sfwt_flag
,chr_id
,cle_id
,cle_id_renewed
,cle_id_renewed_to
,lse_id
,line_number
,sts_code
,display_sequence
,trn_code
,dnz_chr_id
,comments
,item_description
,oke_boe_description
,cognomen
,hidden_ind
,price_unit
,price_unit_percent
,price_negotiated
,price_negotiated_renewed
,price_level_ind
,invoice_line_level_ind
,dpas_rating
,block23text
,exception_yn
,template_used
,date_terminated
,name
,start_date
,end_date
,date_renewed
,upg_orig_system_ref
,upg_orig_system_ref_id
,orig_system_source_code
,orig_system_id1
,orig_system_reference1
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,created_by
,creation_date
,last_updated_by
,last_update_date
,price_type
,currency_code
,currency_code_renewed
,last_update_login
,request_id
,program_application_id
,program_id
,program_update_date
,price_list_id
,pricing_date
,price_list_line_id
,line_list_price
,item_to_price_yn
,price_basis_yn
,config_header_id
,config_revision_number
,config_complete_yn
,config_valid_yn
,config_top_model_line_id
,config_item_type
,CONFIG_ITEM_ID
,service_item_yn
,ph_pricing_type
,ph_price_break_basis
,ph_min_qty
,ph_min_amt
,ph_qp_reference_id
,ph_value
,ph_enforce_price_list_yn
,ph_adjustment
,ph_integrated_with_qp
,cust_acct_id
,bill_to_site_use_id
,inv_rule_id
,line_renewal_type_code
,ship_to_site_use_id
,payment_term_id
,date_cancelled
,term_cancel_source
,cancelled_amount
,annualized_factor
,payment_instruction_type
FROM OKC_K_LINES_V
WHERE id = p_cle_id;
,x_clev_rec.last_updated_by
,x_clev_rec.last_update_date
,x_clev_rec.price_type
,x_clev_rec.currency_code
,x_clev_rec.currency_code_renewed
,x_clev_rec.last_update_login
,x_clev_rec.request_id
,x_clev_rec.program_application_id
,x_clev_rec.program_id
,x_clev_rec.program_update_date
,x_clev_rec.price_list_id
,x_clev_rec.pricing_date
,x_clev_rec.price_list_line_id
,x_clev_rec.line_list_price
,x_clev_rec.item_to_price_yn
,x_clev_rec.price_basis_yn
,x_clev_rec.config_header_id
,x_clev_rec.config_revision_number
,x_clev_rec.config_complete_yn
,x_clev_rec.config_valid_yn
,x_clev_rec.config_top_model_line_id
,x_clev_rec.config_item_type
,x_clev_rec.CONFIG_ITEM_ID
,x_clev_rec.service_item_yn
,x_clev_rec.ph_pricing_type
,x_clev_rec.ph_price_break_basis
,x_clev_rec.ph_min_qty
,x_clev_rec.ph_min_amt
,x_clev_rec.ph_qp_reference_id
,x_clev_rec.ph_value
,x_clev_rec.ph_enforce_price_list_yn
,x_clev_rec.ph_adjustment
,x_clev_rec.ph_integrated_with_qp
,x_clev_rec.cust_acct_id
,x_clev_rec.bill_to_site_use_id
,x_clev_rec.inv_rule_id
,x_clev_rec.line_renewal_type_code
,x_clev_rec.ship_to_site_use_id
,x_clev_rec.payment_term_id
,x_clev_rec.date_cancelled
,x_clev_rec.term_cancel_source
,x_clev_rec.cancelled_amount
,x_clev_rec.annualized_factor
,x_clev_rec.payment_instruction_type;
SELECT ID,
SCN_TYPE,
CHR_ID,
SAT_CODE,
SECTION_SEQUENCE,
LABEL,
HEADING,
SCN_ID,
SFWT_FLAG,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
FROM OKC_SECTIONS_V
WHERE ID = p_scn_id;
SELECT ID,
SCN_ID,
LABEL,
CAT_ID,
CLE_ID,
SAE_ID,
CONTENT_SEQUENCE,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
FROM OKC_SECTION_CONTENTS_V
WHERE ID = p_scc_id;
SELECT ID,
CHR_ID,
CLE_ID,
FLEX_TITLE,
PRICING_CONTEXT,
PRICING_ATTRIBUTE1,
PRICING_ATTRIBUTE2,
PRICING_ATTRIBUTE3,
PRICING_ATTRIBUTE4,
PRICING_ATTRIBUTE5,
PRICING_ATTRIBUTE6,
PRICING_ATTRIBUTE7,
PRICING_ATTRIBUTE8,
PRICING_ATTRIBUTE9,
PRICING_ATTRIBUTE10,
PRICING_ATTRIBUTE11,
PRICING_ATTRIBUTE12,
PRICING_ATTRIBUTE13,
PRICING_ATTRIBUTE14,
PRICING_ATTRIBUTE15,
PRICING_ATTRIBUTE16,
PRICING_ATTRIBUTE17,
PRICING_ATTRIBUTE18,
PRICING_ATTRIBUTE19,
PRICING_ATTRIBUTE20,
PRICING_ATTRIBUTE21,
PRICING_ATTRIBUTE22,
PRICING_ATTRIBUTE23,
PRICING_ATTRIBUTE24,
PRICING_ATTRIBUTE25,
PRICING_ATTRIBUTE26,
PRICING_ATTRIBUTE27,
PRICING_ATTRIBUTE28,
PRICING_ATTRIBUTE29,
PRICING_ATTRIBUTE30,
PRICING_ATTRIBUTE31,
PRICING_ATTRIBUTE32,
PRICING_ATTRIBUTE33,
PRICING_ATTRIBUTE34,
PRICING_ATTRIBUTE35,
PRICING_ATTRIBUTE36,
PRICING_ATTRIBUTE37,
PRICING_ATTRIBUTE38,
PRICING_ATTRIBUTE39,
PRICING_ATTRIBUTE40,
PRICING_ATTRIBUTE41,
PRICING_ATTRIBUTE42,
PRICING_ATTRIBUTE43,
PRICING_ATTRIBUTE44,
PRICING_ATTRIBUTE45,
PRICING_ATTRIBUTE46,
PRICING_ATTRIBUTE47,
PRICING_ATTRIBUTE48,
PRICING_ATTRIBUTE49,
PRICING_ATTRIBUTE50,
PRICING_ATTRIBUTE51,
PRICING_ATTRIBUTE52,
PRICING_ATTRIBUTE53,
PRICING_ATTRIBUTE54,
PRICING_ATTRIBUTE55,
PRICING_ATTRIBUTE56,
PRICING_ATTRIBUTE57,
PRICING_ATTRIBUTE58,
PRICING_ATTRIBUTE59,
PRICING_ATTRIBUTE60,
PRICING_ATTRIBUTE61,
PRICING_ATTRIBUTE62,
PRICING_ATTRIBUTE63,
PRICING_ATTRIBUTE64,
PRICING_ATTRIBUTE65,
PRICING_ATTRIBUTE66,
PRICING_ATTRIBUTE67,
PRICING_ATTRIBUTE68,
PRICING_ATTRIBUTE69,
PRICING_ATTRIBUTE70,
PRICING_ATTRIBUTE71,
PRICING_ATTRIBUTE72,
PRICING_ATTRIBUTE73,
PRICING_ATTRIBUTE74,
PRICING_ATTRIBUTE75,
PRICING_ATTRIBUTE76,
PRICING_ATTRIBUTE77,
PRICING_ATTRIBUTE78,
PRICING_ATTRIBUTE79,
PRICING_ATTRIBUTE80,
PRICING_ATTRIBUTE81,
PRICING_ATTRIBUTE82,
PRICING_ATTRIBUTE83,
PRICING_ATTRIBUTE84,
PRICING_ATTRIBUTE85,
PRICING_ATTRIBUTE86,
PRICING_ATTRIBUTE87,
PRICING_ATTRIBUTE88,
PRICING_ATTRIBUTE89,
PRICING_ATTRIBUTE90,
PRICING_ATTRIBUTE91,
PRICING_ATTRIBUTE92,
PRICING_ATTRIBUTE93,
PRICING_ATTRIBUTE94,
PRICING_ATTRIBUTE95,
PRICING_ATTRIBUTE96,
PRICING_ATTRIBUTE97,
PRICING_ATTRIBUTE98,
PRICING_ATTRIBUTE99,
PRICING_ATTRIBUTE100,
QUALIFIER_CONTEXT,
QUALIFIER_ATTRIBUTE1,
QUALIFIER_ATTRIBUTE2,
QUALIFIER_ATTRIBUTE3,
QUALIFIER_ATTRIBUTE4,
QUALIFIER_ATTRIBUTE5,
QUALIFIER_ATTRIBUTE6,
QUALIFIER_ATTRIBUTE7,
QUALIFIER_ATTRIBUTE8,
QUALIFIER_ATTRIBUTE9,
QUALIFIER_ATTRIBUTE10,
QUALIFIER_ATTRIBUTE11,
QUALIFIER_ATTRIBUTE12,
QUALIFIER_ATTRIBUTE13,
QUALIFIER_ATTRIBUTE14,
QUALIFIER_ATTRIBUTE15,
QUALIFIER_ATTRIBUTE16,
QUALIFIER_ATTRIBUTE17,
QUALIFIER_ATTRIBUTE18,
QUALIFIER_ATTRIBUTE19,
QUALIFIER_ATTRIBUTE20,
QUALIFIER_ATTRIBUTE21,
QUALIFIER_ATTRIBUTE22,
QUALIFIER_ATTRIBUTE23,
QUALIFIER_ATTRIBUTE24,
QUALIFIER_ATTRIBUTE25,
QUALIFIER_ATTRIBUTE26,
QUALIFIER_ATTRIBUTE27,
QUALIFIER_ATTRIBUTE28,
QUALIFIER_ATTRIBUTE29,
QUALIFIER_ATTRIBUTE30,
QUALIFIER_ATTRIBUTE31,
QUALIFIER_ATTRIBUTE32,
QUALIFIER_ATTRIBUTE33,
QUALIFIER_ATTRIBUTE34,
QUALIFIER_ATTRIBUTE35,
QUALIFIER_ATTRIBUTE36,
QUALIFIER_ATTRIBUTE37,
QUALIFIER_ATTRIBUTE38,
QUALIFIER_ATTRIBUTE39,
QUALIFIER_ATTRIBUTE40,
QUALIFIER_ATTRIBUTE41,
QUALIFIER_ATTRIBUTE42,
QUALIFIER_ATTRIBUTE43,
QUALIFIER_ATTRIBUTE44,
QUALIFIER_ATTRIBUTE45,
QUALIFIER_ATTRIBUTE46,
QUALIFIER_ATTRIBUTE47,
QUALIFIER_ATTRIBUTE48,
QUALIFIER_ATTRIBUTE49,
QUALIFIER_ATTRIBUTE50,
QUALIFIER_ATTRIBUTE51,
QUALIFIER_ATTRIBUTE52,
QUALIFIER_ATTRIBUTE53,
QUALIFIER_ATTRIBUTE54,
QUALIFIER_ATTRIBUTE55,
QUALIFIER_ATTRIBUTE56,
QUALIFIER_ATTRIBUTE57,
QUALIFIER_ATTRIBUTE58,
QUALIFIER_ATTRIBUTE59,
QUALIFIER_ATTRIBUTE60,
QUALIFIER_ATTRIBUTE61,
QUALIFIER_ATTRIBUTE62,
QUALIFIER_ATTRIBUTE63,
QUALIFIER_ATTRIBUTE64,
QUALIFIER_ATTRIBUTE65,
QUALIFIER_ATTRIBUTE66,
QUALIFIER_ATTRIBUTE67,
QUALIFIER_ATTRIBUTE68,
QUALIFIER_ATTRIBUTE69,
QUALIFIER_ATTRIBUTE70,
QUALIFIER_ATTRIBUTE71,
QUALIFIER_ATTRIBUTE72,
QUALIFIER_ATTRIBUTE73,
QUALIFIER_ATTRIBUTE74,
QUALIFIER_ATTRIBUTE75,
QUALIFIER_ATTRIBUTE76,
QUALIFIER_ATTRIBUTE77,
QUALIFIER_ATTRIBUTE78,
QUALIFIER_ATTRIBUTE79,
QUALIFIER_ATTRIBUTE80,
QUALIFIER_ATTRIBUTE81,
QUALIFIER_ATTRIBUTE82,
QUALIFIER_ATTRIBUTE83,
QUALIFIER_ATTRIBUTE84,
QUALIFIER_ATTRIBUTE85,
QUALIFIER_ATTRIBUTE86,
QUALIFIER_ATTRIBUTE87,
QUALIFIER_ATTRIBUTE88,
QUALIFIER_ATTRIBUTE89,
QUALIFIER_ATTRIBUTE90,
QUALIFIER_ATTRIBUTE91,
QUALIFIER_ATTRIBUTE92,
QUALIFIER_ATTRIBUTE93,
QUALIFIER_ATTRIBUTE94,
QUALIFIER_ATTRIBUTE95,
QUALIFIER_ATTRIBUTE96,
QUALIFIER_ATTRIBUTE97,
QUALIFIER_ATTRIBUTE98,
QUALIFIER_ATTRIBUTE99,
QUALIFIER_ATTRIBUTE100
FROM OKC_PRICE_ATT_VALUES_V
WHERE ID = p_pav_id;
SELECT cas.cust_account_id cust_account_id, ca.party_id party_id
FROM hz_cust_site_uses_all csu, hz_cust_acct_sites_all cas, hz_cust_accounts_all ca
WHERE csu.site_use_id = cp_bill_to_site_use_id
AND cas.cust_acct_site_id = csu.cust_acct_site_id
AND ca.cust_account_id = cas.cust_account_id;
SELECT ca.party_id party_id
FROM hz_cust_accounts_all ca
WHERE ca.cust_account_id = cp_cust_acct_id;
SELECT instr_assignment_id
FROM iby_trxn_extensions_v
WHERE trxn_extension_id = cp_trx_ext_id;