eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_CREATE_FORMULA SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 15


	  formula_insert_table GMD_FORMULA_PUB.formula_insert_hdr_tbl_type;

Line: 52


	         formula_insert_table(form_count).record_type :=  rec_type;

Line: 59


             formula_insert_table(form_count).formula_no :=  UPPER(rec_type);

Line: 66


             formula_insert_table(form_count).formula_vers :=  to_number(rec_type);

Line: 73


             formula_insert_table(form_count).formula_type :=  to_number(rec_type);

Line: 80


             formula_insert_table(form_count).formula_desc1 :=  rec_type;

Line: 87


             formula_insert_table(form_count).formula_desc2 :=  (rec_type);

Line: 94


             formula_insert_table(form_count).formula_class :=  (rec_type);

Line: 101


             formula_insert_table(form_count).fmcontrol_class :=  rec_type;

Line: 108


             formula_insert_table(form_count).inactive_ind :=  to_number(rec_type);

Line: 115


             formula_insert_table(form_count).formula_id :=  to_number(rec_type);

Line: 122


             formula_insert_table(form_count).formulaline_id :=  to_number(rec_type);

Line: 129


             formula_insert_table(form_count).line_type :=  to_number(rec_type);

Line: 136


             formula_insert_table(form_count).line_no :=  to_number(rec_type);

Line: 143


             formula_insert_table(form_count).item_no :=  UPPER(rec_type);

Line: 150


             formula_insert_table(form_count).qty :=  to_number(rec_type);

Line: 157


             formula_insert_table(form_count).detail_uom :=  (rec_type);

Line: 164


             formula_insert_table(form_count).release_type :=  to_number(rec_type);

Line: 171


             formula_insert_table(form_count).scrap_factor :=  to_number(rec_type);

Line: 178


             formula_insert_table(form_count).scale_type_hdr :=  to_number(rec_type);

Line: 184


             formula_insert_table(form_count).scale_type_dtl :=  to_number(rec_type);

Line: 191


             formula_insert_table(form_count).cost_alloc :=  to_number(rec_type);

Line: 198


             formula_insert_table(form_count).phantom_type :=  to_number(rec_type);

Line: 205


             formula_insert_table(form_count).rework_type :=  to_number(rec_type);

Line: 212


             formula_insert_table(form_count).owner_organization_id :=  (rec_type);

Line: 220


             formula_insert_table(form_count).formula_status :=  (rec_type);

Line: 227


             formula_insert_table(form_count).owner_id :=  to_number(rec_type);

Line: 235


             formula_insert_table(form_count).TPFORMULA_ID :=  to_number(rec_type);

Line: 242


             formula_insert_table(form_count).IAFORMULA_ID :=  to_number(rec_type);

Line: 249


             formula_insert_table(form_count).CONTRIBUTE_STEP_QTY_IND  :=  (rec_type);

Line: 256


             formula_insert_table(form_count).user_name :=  rec_type;

Line: 263


             formula_insert_table(form_count).created_by :=  to_number(rec_type);

Line: 270


             formula_insert_table(form_count).last_updated_by :=  to_number(rec_type);

Line: 277


             formula_insert_table(form_count).creation_date :=  (rec_type);

Line: 284


             formula_insert_table(form_count).last_update_date :=  (rec_type);

Line: 291


             formula_insert_table(form_count).text_code_hdr :=  (rec_type);

Line: 298


             formula_insert_table(form_count).text_code_dtl :=  (rec_type);

Line: 308


             formula_insert_table(form_count).attribute1 :=  rec_type;

Line: 314


             formula_insert_table(form_count).attribute2 :=  rec_type;

Line: 320


             formula_insert_table(form_count).attribute3 :=  rec_type;

Line: 326


             formula_insert_table(form_count).attribute4 :=  rec_type;

Line: 332


             formula_insert_table(form_count).attribute5 :=  rec_type;

Line: 338


             formula_insert_table(form_count).attribute6 :=  rec_type;

Line: 344


             formula_insert_table(form_count).attribute7 :=  rec_type;

Line: 350


             formula_insert_table(form_count).attribute8 :=  rec_type;

Line: 356


             formula_insert_table(form_count).attribute9 :=  rec_type;

Line: 362


             formula_insert_table(form_count).attribute10 :=  rec_type;

Line: 368


             formula_insert_table(form_count).attribute11 :=  rec_type;

Line: 374


             formula_insert_table(form_count).attribute12 :=  rec_type;

Line: 380


             formula_insert_table(form_count).attribute13 :=  rec_type;

Line: 386


             formula_insert_table(form_count).attribute14 :=  rec_type;

Line: 392


             formula_insert_table(form_count).attribute15 :=  rec_type;

Line: 398


             formula_insert_table(form_count).attribute16 :=  rec_type;

Line: 404


             formula_insert_table(form_count).attribute17 :=  rec_type;

Line: 410


             formula_insert_table(form_count).attribute18 :=  rec_type;

Line: 416


             formula_insert_table(form_count).attribute19 :=  rec_type;

Line: 422


             formula_insert_table(form_count).attribute20 :=  rec_type;

Line: 428


             formula_insert_table(form_count).attribute21 :=  rec_type;

Line: 434


             formula_insert_table(form_count).attribute22 :=  rec_type;

Line: 440


             formula_insert_table(form_count).attribute23 :=  rec_type;

Line: 446


             formula_insert_table(form_count).attribute24 :=  rec_type;

Line: 452


             formula_insert_table(form_count).attribute25 :=  rec_type;

Line: 458


             formula_insert_table(form_count).attribute26 :=  rec_type;

Line: 464


             formula_insert_table(form_count).attribute27 :=  rec_type;

Line: 470


             formula_insert_table(form_count).attribute28 :=  rec_type;

Line: 476


             formula_insert_table(form_count).attribute29 :=  rec_type;

Line: 482


             formula_insert_table(form_count).attribute30 :=  rec_type;

Line: 490


             formula_insert_table(form_count).dtl_attribute1 :=  rec_type;

Line: 496


             formula_insert_table(form_count).dtl_attribute2 :=  rec_type;

Line: 502


             formula_insert_table(form_count).dtl_attribute3 :=  rec_type;

Line: 508


             formula_insert_table(form_count).dtl_attribute4 :=  rec_type;

Line: 514


             formula_insert_table(form_count).dtl_attribute5 :=  rec_type;

Line: 520


             formula_insert_table(form_count).dtl_attribute6 :=  rec_type;

Line: 526


             formula_insert_table(form_count).dtl_attribute7 :=  rec_type;

Line: 532


             formula_insert_table(form_count).dtl_attribute8 :=  rec_type;

Line: 538


             formula_insert_table(form_count).dtl_attribute9 :=  rec_type;

Line: 544


             formula_insert_table(form_count).dtl_attribute10 :=  rec_type;

Line: 550


             formula_insert_table(form_count).dtl_attribute11 :=  rec_type;

Line: 556


             formula_insert_table(form_count).dtl_attribute12 :=  rec_type;

Line: 562


             formula_insert_table(form_count).dtl_attribute13 :=  rec_type;

Line: 568


             formula_insert_table(form_count).dtl_attribute14 :=  rec_type;

Line: 574


             formula_insert_table(form_count).dtl_attribute15 :=  rec_type;

Line: 580


             formula_insert_table(form_count).dtl_attribute16 :=  rec_type;

Line: 586


             formula_insert_table(form_count).dtl_attribute17 :=  rec_type;

Line: 592


             formula_insert_table(form_count).dtl_attribute18 :=  rec_type;

Line: 598


             formula_insert_table(form_count).dtl_attribute19 :=  rec_type;

Line: 604


             formula_insert_table(form_count).dtl_attribute20 :=  rec_type;

Line: 610


             formula_insert_table(form_count).dtl_attribute21 :=  rec_type;

Line: 616


             formula_insert_table(form_count).dtl_attribute22 :=  rec_type;

Line: 622


             formula_insert_table(form_count).dtl_attribute23 :=  rec_type;

Line: 628


             formula_insert_table(form_count).dtl_attribute24 :=  rec_type;

Line: 634


             formula_insert_table(form_count).dtl_attribute25 :=  rec_type;

Line: 640


             formula_insert_table(form_count).dtl_attribute26 :=  rec_type;

Line: 646


             formula_insert_table(form_count).dtl_attribute27 :=  rec_type;

Line: 652


             formula_insert_table(form_count).dtl_attribute28 :=  rec_type;

Line: 658


             formula_insert_table(form_count).dtl_attribute29 :=  rec_type;

Line: 664


             formula_insert_table(form_count).dtl_attribute30 :=  rec_type;

Line: 671


             formula_insert_table(form_count).attribute_category :=  rec_type;

Line: 691


             GMD_FORMULA_PUB.Insert_Formula
             (  1.0                           ,
                FND_API.G_FALSE               ,
                FND_API.G_TRUE               ,
                'YES'                         ,
                l_return_status               ,
                x_msg_count                   ,
                x_msg_data                    ,
                formula_insert_table
             );