Profile

Cover photo
shiva kumar kandigatla
Lived in 520 S State St,chicago, il, 60605
255 followers|358,377 views
AboutPostsPhotosYouTube+1'sReviews

Stream

shiva kumar kandigatla

Shared publicly  - 
 
How to find Supplier or Customer in TCA Oracle Applications
select  PARTY_USAGE_CODE from hz_party_usg_assignments; Party usage code in Party_usg_assginments will show is the party Customer or Supplier or Bank.
select  PARTY_USAGE_CODE from hz_party_usg_assignments; Party usage code in Party_usg_assginments will show is the party Customer or Supplier or Bank.
1
Add a comment...

shiva kumar kandigatla

Shared publicly  - 
 
API to Delete Values in Value Set in Oracle Applications
DECLARE    l_err_msg   VARCHAR2 (500) := NULL;     CURSOR c1    IS       SELECT ffv.flex_value_id, ffv.flex_value         FROM fnd_flex_value_sets ffvs,              fnd_flex_values ffv,              fnd_flex_values_tl ffvt        WHERE     flex_value_set_n...
DECLARE    l_err_msg   VARCHAR2 (500) := NULL;     CURSOR c1    IS       SELECT ffv.flex_value_id, ffv.flex_value         FROM fnd_flex_value_sets ffvs,              fnd_flex_values ffv,              fnd_flex_values_tl...
1
Add a comment...

shiva kumar kandigatla

Shared publicly  - 
 
REF CURSOR Procedure as a OUTPUT variable in Oracle as a result set output for JAVA and VB.NET or C#
CREATE OR REPLACE PACKAGE APPS.PRICE_BOOK_PKG AS    TYPE R_CURSOR IS REF CURSOR;    PROCEDURE GETPRICEBOOKDATA (P_PRICEBOOK_REQUEST_ID   IN     NUMBER,                                cur_pricebookdata           OUT R_CURSOR);    PROCEDURE GETPRICEBOOKDATA (...
CREATE OR REPLACE PACKAGE APPS.PRICE_BOOK_PKG AS    TYPE R_CURSOR IS REF CURSOR;    PROCEDURE GETPRICEBOOKDATA (P_PRICEBOOK_REQUEST_ID   IN     NUMBER,                                cur_pricebookdata           OUT R_CURSOR);...
1
Add a comment...

shiva kumar kandigatla

Shared publicly  - 
 
How to Register shell script in Oracle Applications
Basics for people like me who are poor in unix…and not confident in doing shell scripting..:) we dont need to develop huge scripts in apps..most of the times it will be moving files between servers or deleting files after completion… Recently I developed a ...
Basics for people like me who are poor in unix…and not confident in doing shell scripting..:) we dont need to develop huge scripts in apps..most of the times it will be moving files between servers or deleting files after com...
1
Add a comment...

shiva kumar kandigatla

Shared publicly  - 
 
FND API to Delete, Add and Update value set values in Oracle Applications
ALTER SESSION SET CURRENT_SCHEMA = APPS; DECLARE    l_err_msg   VARCHAR2 (500) := NULL;    CURSOR c1    IS       SELECT ffv.flex_value_id, ffv.flex_value         FROM apps.fnd_flex_value_sets ffvs             ,apps.fnd_flex_values ffv             ,apps.fnd_...
ALTER SESSION SET CURRENT_SCHEMA = APPS; DECLARE    l_err_msg   VARCHAR2 (500) := NULL;    CURSOR c1    IS       SELECT ffv.flex_value_id, ffv.flex_value         FROM apps.fnd_flex_value_sets ffvs             ,apps.fnd_fl...
1
Add a comment...

shiva kumar kandigatla

Shared publicly  - 
 
Concurrent program Trace File Path and File name in Oracle Applications
SELECT req.request_id, req.logfile_node_name node, req.oracle_process_id       ,req.enable_trace       ,    dest.VALUE         || '/'         || LOWER (dbnm.VALUE)         || '_ora_'         || oracle_process_id         || '.trc' trace_filename       ,prog....
SELECT req.request_id, req.logfile_node_name node, req.oracle_process_id       ,req.enable_trace       ,    dest.VALUE         || '/'         || LOWER (dbnm.VALUE)         || '_ora_'         || oracle_process_id         || '...
1
Add a comment...
Have him in circles
255 people
Srikanth Karnati's profile photo
Praveen Gangidi's profile photo
Suresh Margam's profile photo
muralidhar gunti's profile photo
vishnu prasad's profile photo
vijay ellendula's profile photo
Praveenkumar Achanta's profile photo
vijaya lakshmi rajola's profile photo
sumanth reddy Gajulapalli's profile photo

shiva kumar kandigatla

Shared publicly  - 
 
How to Delete Empty rows from Excel
1) If you want to remove only Empty cells just select all data click on F5 then Click on Special > then select Blacks radio button and click Ok. It will select all Empty cell. Then click CTRL+ '' . It will ask to delete Cells up or only Cells or Only Cell...
1) If you want to remove only Empty cells just select all data click on F5 then Click on Special -> then select Blacks radio button and click Ok. It will select all Empty cell. Then click CTRL+ '-' . It will ask to delete Cel...
1
Add a comment...

shiva kumar kandigatla

Shared publicly  - 
 
Concurrent Program and XML Publisher or BI Publisher Data Definition and Template details
         select USER_CONCURRENT_PROGRAM_NAME, cpn.CONCURRENT_PROGRAM_NAME CONCURRENT_PROGRAM_SHORT_NAME,fe.EXECUTABLE_NAME           ,dsn.DATA_SOURCE_NAME, ds.DATA_SOURCE_CODE,tn.TEMPLATE_NAME,   t.TEMPLATE_CODE           from apps.fnd_concurrent_programs_v...
         select USER_CONCURRENT_PROGRAM_NAME, cpn.CONCURRENT_PROGRAM_NAME CONCURRENT_PROGRAM_SHORT_NAME,fe.EXECUTABLE_NAME           ,dsn.DATA_SOURCE_NAME, ds.DATA_SOURCE_CODE,tn.TEMPLATE_NAME,   t.TEMPLATE_CODE           fro...
1
Add a comment...

shiva kumar kandigatla

Shared publicly  - 
 
QP_DEBUG Tables
S. No Table Name Description 1 QP_DEBUG_REQ This table contains information about the pricing requests. 2 QP_DEBUG_REQ_LINES This table contains details about the lines being priced. 3 QP_DEBUG_REQ_LDETS This table contains information about the line detail...
S. No Table Name Description 1 QP_DEBUG_REQ This table contains information about the pricing requests. 2 QP_DEBUG_REQ_LINES This table contains details about the lines being priced. 3 QP_DEBUG_REQ_LDETS This table contains i...
1
Add a comment...

shiva kumar kandigatla

Shared publicly  - 
 
Creating Soft Link or Symbolic Link in Oracle Applications or Oracle Apps
Soft Link or Symbolic Link is required to read a shell script (.prog file) through a concurrent program. We can create soft links or symbolic links for Concurrent Manager program files as follows: Step 1:Go to the custom top as below: >cd $xxtest_TOP/bin te...
Soft Link or Symbolic Link is required to read a shell script (.prog file) through a concurrent program. We can create soft links or symbolic links for Concurrent Manager program files as follows: Step 1:Go to the custom top ...
1
Add a comment...

shiva kumar kandigatla

Shared publicly  - 
 
convert comma separated string into rows in SQL Oracle
SELECT DISTINCT TRIM (EXTRACT (VALUE (d), '//row/text()').getstringval ())            FROM (SELECT XMLTYPE (   ' '                                  || REPLACE ('47 X 48 X 49'                                             ,'X'                                  ...
SELECT DISTINCT TRIM (EXTRACT (VALUE (d), '//row/text()').getstringval ())            FROM (SELECT XMLTYPE (   ''                                  || REPLACE ('47 X 48 X 49'                                             ,'X'   ...
1
Add a comment...

shiva kumar kandigatla

Shared publicly  - 
 
Order Details Query in Order Management of Oracle APPS
SELECT oha.order_number, oha.ordered_date,wdd.delivery_detail_id, wnd.delivery_id, wt.trip_id       ,wdd.batch_id move_order#, customer.party_name, customer.account_number       ,hp_ship.party_name ship_party_name       ,hps_ship.party_site_name ship_party_...
SELECT oha.order_number, oha.ordered_date,wdd.delivery_detail_id, wnd.delivery_id, wt.trip_id       ,wdd.batch_id move_order#, customer.party_name, customer.account_number       ,hp_ship.party_name ship_party_name       ,hps_...
1
Add a comment...
People
Have him in circles
255 people
Srikanth Karnati's profile photo
Praveen Gangidi's profile photo
Suresh Margam's profile photo
muralidhar gunti's profile photo
vishnu prasad's profile photo
vijay ellendula's profile photo
Praveenkumar Achanta's profile photo
vijaya lakshmi rajola's profile photo
sumanth reddy Gajulapalli's profile photo
Collections shiva kumar is following
Places
Map of the places this user has livedMap of the places this user has livedMap of the places this user has lived
Previously
520 S State St,chicago, il, 60605 - 3860 charter oak way, columbus, oh - 141 paterson ave, lodi, nj, 07644
Basic Information
Gender
Male
shiva kumar kandigatla's +1's are the things they like, agree with, or want to recommend.
XE - The World's Favorite Currency and Foreign Exchange Site
www.xe.com

Get free live currency rates, tools, and analysis using the most accurate data. Other services include XE Trade money transfers, XE Datafeed

Honda Motor Co Ltd (ADR)
www.google.com

Get detailed financial information on Honda Motor Co Ltd (ADR) (NYSE:HMC) including real-time stock quotes, historical charts & financial ne

Kindle - Apps on Android Market
market.android.com

Read books on your phone, including thousands of free Kindle books. The Kindle app puts over a million books at your fingertips. It’s the a

Aamir Khan's Satyamev Jayate in Telugu : Domestic Violence|Satyamev Jayate
ap7am.com

Tv 9 TVU N Tv ABN i news Sakshi Tv etv2 Studio N HMTv Raj News Zee 24 Maha Tv Tv5 T News SVBC · Gmail Yahoo Mail Hot Mail Rediff Mail Meebo

YouTube - Daddy: Chiru, Rajendra Prasad go on a househunt
www.youtube.com

Create AccountSign In. Home. BrowseMoviesUpload. Hey there, this is not a commercial interruption. You're using an outdated browser, whi

YouTube - THE GREAT INDIAN INVENTIONS
www.youtube.com

Create AccountSign In. Home. BrowseMoviesUpload. Hey there, this is not a commercial interruption. You're using an outdated browser, whi

Oracle E-Business Suite Upgrade
marketing.delphix.com

Delphix reduces the complexities of Oracle E-Business Suite (EBS) upgrades through efficient creation and refresh of nonproduction database

Awesome Match-3 Game
market.android.com

Awesome Match-3 is a fun and addictive match-3 puzzle game for android. It’s an adventurous and exciting experience! The classic mode is a m

CEO Cook kicks off Apple's iPad-unveiling event
www.reuters.com

SAN FRANCISCO (Reuters) - Apple Inc is expected to take the wraps off a faster 4G-equipped iPad on Wednesday, hoping the latest version of i

Mahjong - Apps on Android Market
market.android.com

Mahjong for Android Mahjong is a free solitaire matching game which uses a set of Mahjong tiles. The goal of this pyramid game is to match o

AR Invoice API (Application Program Interface ) | OracleApps Epicenter
www.oracleappshub.com

AR Invoice API allows users to create an invoice using simple calls to PL/SQL functions. The Invoice Creation API is another options for Tra

Google + attacks Facebook with games - The Times of India
timesofindia.indiatimes.com

Internet search leader Google Inc is bringing a little more gamesmanship to its duel with Facebook.

Oracle Forms Tutorial (www.aboutoracleapps.com)
www.slideshare.net

To download Slides from Slideshare visit - http://www.aboutonlinetips.com/download-slides-from-slidesharenet-%e2%80%93-firefox-add-on/

YouTube - Robot transforming
www.youtube.com

Create AccountSign In. Home. BrowseMoviesUpload. Hey there, this is not a commercial interruption. You're using an outdated browser, whi

One of the worst appartments in Alpharetta. The mainatance is worst. I have lived there. I gave maintenance notice. But no one showed up until 3 months that to i got called more than 10 times and personally went and asked then he come after 3 months. The office staff also not good.
Public - 6 months ago
reviewed 6 months ago
1 review
Map
Map
Map