ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Google
   
 
 Categories >> Software       
 
  Programming Languages (4891)   Scripts (1888)   Networking (986)   Microsoft Related (4549)   Databases (4239)
  Operating Systems (2453)   Testing (13606)   Servers (141)   MainFrame (3803)   Java Related (3448)
  Middleware (125)   Web Related (336)   Data Warehouse (5225)   HR Questions (339)   Software Design (406)
  Debugging (42)   Version Control (95)   Editors (27)   Telecom (288)   ERP CRM (11421)
  Embedded Systems (286)   Client Server (106)   Artificial Intelligence (40)   Cryptography (242)   EAI (263)
  Multimedia (39)   Software Development Life Cycle (257)   Image Processing (30)
 
Suggest New Category 
 


 

  Question  Asked @ Answers Views     select
 
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?  0  3
explain detail about ftp in datastage? ibm  0  6
CREATE OR REPLACE procedure XXPROC_OPENINT(errbuf OUT VARCHAR2, retcode OUT VARCHAR2) AS --Cursor Declaration cursor inv_cur IS SELECT INVI.INVOICE_ID ,INVI.INVOICE_TYPE_LOOKUP_CODE ,INVI.INVOICE_DATE ,INVI.VENDOR_ID ,INVI.VENDOR_SITE_ID ,INVI.INVOICE_AMOUNT ,INVI.INVOICE_CURRENCY_CODE ,INVI.STATUS ,INVI.GROUP_ID ,INVI.SOURCE ,INVI.ORG_ID ,INVI.DESCRIPTION ,INVI.CREATION_DATE ,INVI.CREATED_BY ,INVL.INVOICE_ID ,INVL.LINE_NUMBER ,INVL.LINE_TYPE_LOOKUP_CODE ,INVL.DESCRIPTION ,INVL.ORG_ID ,INVL.INVENTORY_ITEM_ID ,INVL.ACCOUNTING_DATE ,INVL.AMOUNT ,INVL.CREATION_DATE ,INVL.CREATED_BY ,INVL.PO_HEADER_ID ,INVL.PO_LINE_LOCATION_ID ,INVL.ITEM_DESCRIPTION FROM XXAP_INVOICES_INTERFACE_STG INVI ,AP_INVOICE_LINES_INTERFACE_STG INVL WHERE INVI.INVOICE_ID=INVL.INVOICE_ID AND INVI.ORG_ID=INVL.ORG_ID; l_currency_code varchar2(25); l_flag varchar2(2); l_error_msg varchar2(100); l_err_msg varchar2(100); l_err_flag varchar2(10); l_count number(9) default 0; BEGIN for rec_cur in inv_cur loop l_count:=l_count+1; --Currency Code Validation BEGIN SELECT currency_code INTO l_currency_code FROM FND_CURRENCIES WHERE currency_code ='USD'; EXCEPTION WHEN others THEN l_flag:='E'; l_error_msg:='Currency Code Does not Exists'; fnd_file.put_line(fnd_file.log,'Inserting Data Into The Interface Table'||'-'||l_count||' '||l_error_msg); END; IF l_flag!='E' THEN fnd_file.put_line(fnd_file.log,'Inserting Data Into The Interface Table'); INSERT INTO AP_INVOICES_INTERFACE( INVOICE_ID ,INVOICE_TYPE_LOOKUP_CODE ,INVOICE_DATE ,VENDOR_ID ,VENDOR_SITE_ID ,INVOICE_AMOUNT ,INVOICE_CURRENCY_CODE ,STATUS ,GROUP_ID ,SOURCE ,ORG_ID ,DESCRIPTION ,CREATION_DATE ,CREATED_BY) VALUES (rec_cur.INVOICE_ID ,rec_cur.INVOICE_TYPE_LOOKUP_CODE ,rec_cur.INVOICE_DATE ,rec_cur.VENDOR_ID ,rec_cur.VENDOR_SITE_ID ,rec_cur.INVOICE_AMOUNT ,rec_cur.INVOICE_CURRENCY_CODE ,rec_cur.STATUS ,rec_cur.GROUP_ID ,rec_cur.SOURCE ,rec_cur.ORG_ID ,rec_cur.DESCRIPTION ,rec_cur.CREATION_DATE ,rec_cur.CREATED_BY); INSERT INTO ap_invoice_lines_interface ( INVOICE_ID ,LINE_NUMBER ,LINE_TYPE_LOOKUP_CODE ,DESCRIPTION ,ORG_ID ,INVENTORY_ITEM_ID ,ACCOUNTING_DATE ,AMOUNT ,CREATION_DATE ,CREATED_BY ,PO_HEADER_ID ,PO_LINE_LOCATION_ID,ITEM_DESCRIPTION) VALUES (rec_cur.INVOICE_ID ,rec_cur.LINE_NUMBER ,rec_cur.LINE_TYPE_LOOKUP_CODE ,rec_cur.DESCRIPTION ,rec_cur.ORG_ID ,rec_cur.INVENTORY_ITEM_ID ,rec_cur.ACCOUNTING_DATE ,rec_cur.AMOUNT ,rec_cur.CREATION_DATE ,rec_cur.CREATED_BY ,rec_cur.PO_HEADER_ID ,rec_cur.PO_LINE_LOCATION_ID ,rec_cur.ITEM_DESCRIPTION); END IF; l_flag:=NULL; l_err_MSG:=NULL; END LOOP; COMMIT; END XXPROC_OPENINT; / PLS-00402: alias required in SELECT list of cursor to avoid duplicate column names  0  7
Hi this sainath iam planning to do SAP SD earlierly i have experience in sales field for 4 years can i get job in sap sd and how is the growth in this field pls help me  0  5
What is unplanned & Planned delivery cost? and how it is captured? Bosch  1  5
Hi guyes, I have cleared 2 technical rounds with cts for liferay and java techonologies, i have client round next week, please tell me how to prepare for this what questions i should be ready to face?  0  5
Hi can any one tell me the path to trans.log file in both(unix and windows ) environment  0  4
Explain roles and responsibilites of 2yrs Automation qtp engineer.  0  5
Hi,i have 3 years of experience in manual and Automation qtp.present i am searching for job in automation qtp 2Yrs,How to Explain the interviwer Roles and Responsibilites.please help me.  0  5
Can anyone let me know , Latest idoc type using in ecc and above versions for customer master. NTT-Data  0  6
What are the security measures we have to take for our site not to hack by others? Infosys  0  6
what is purchase life cycle IBM maximo  0  5
Test cases on send/ receive button of Microsoft outlook. Sungard  0  7
there is a inst named technopad which is giving sap fico training,can anyone tell me that is that a good option for sap training  0  5
who are the top faculties of SAP FICO in hyderabad  0  6
E-Mail New Answers        Answer Selected Questions       
 [1]    2  ... 266   ... 531   ... 796   ... 1061   ... 1326   ... 1591   ... 1856   ... 2121   ... 2386   ... 2651   ... 2916   ... 3181   ... 3446   ... 3711    Next
 
 
 
 
 
Un-Answered Questions
 
 Question Views Asked at   Select
 
what is mean by OLE ? Please answer me. Advance thanks. 482 Excel
What is IDOC archiving? 290 Genpact
The title of the window consists of date and time.What is the regular expression to recognize the window as unique? 267  
what is FI end user manual 126 wipro
load all subfile logic in sqlrpgle and when updating particular record it must be lock form other jobs (not a file)? 178 wipro
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ? 269 IBM
How to create a Resource only DLL? 289  
What is the difference between Lotus Notes 5.0 and Lotus Notes 7.0? 755 BT
i am facing date format issue in webi report in BI4.0 environment. i have unx based on Mysql connection. date is coming in 10 digits numeric format like(2345623456). I want to change it in dd.mm.yyyy format. Please suggest 581  
How will you edit a baseline file of a verification point? 399 Covansys
What is Cyclometric testing? 146  
When all browsers and download managers are closed data transfer continues, how to identify and stop it? 197  
E-Mail New Answers        Answer Selected Questions
 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com