What do you mean by auto wiring?
Wednesday, March 30, 2011
Supplier Site Bank Account tables in R12
In which tables can we find supplier site related bank account information in R12?
Tuesday, March 29, 2011
Saturday, March 26, 2011
Interview Question
Given a linked list(circular) and numbers in the list are sorted. Given a pointer to the node find the minimum number in the list.
Friday, March 25, 2011
How to retrieve Nth row from database table?
How to retrieve Nth row from SQL server?
Microsoft SQL Server Selecting the first row:
SELECT TOP 1 * FROM tblUsers
Selecting the fifth row:
SELECT TOP 1 * FROM (SELECT TOP 5 * FROM
tblusers ORDER BY 1 ASC) RANDOMSTRING
ORDER BY 1 DESC;
MySQL: How to retrieve Nth row from MySql?
SELECT * FROM tblUsers LIMIT 1,1
Selecting the fifth row:
SELECT * FROM tblUsers LIMIT 5,1
Oracle:How to retrieve Nth row from Oracle?
SELECT * FROM (SELECT ROWNUM r, username FROM tblUsers ORDER BY 1) WHERE r=1;
SELECT * FROM tblUsers WHERE rownum=1;
Selecting the username column from the fifth row:
SELECT * FROM (SELECT ROWNUM r, username FROM tblUsers ORDER BY 1) WHERE r=5;
How to retrieve Nth row from database table?
How to retrieve Nth row from SQL server?
Microsoft SQL Server Selecting the first row:
SELECT TOP 1 * FROM tblUsers
Selecting the fifth row:
SELECT TOP 1 * FROM (SELECT TOP 5 * FROM
tblusers ORDER BY 1 ASC) RANDOMSTRING
ORDER BY 1 DESC;
MySQL: How to retrieve Nth row from MySql?
SELECT * FROM tblUsers LIMIT 1,1
Selecting the fifth row:
SELECT * FROM tblUsers LIMIT 5,1
Oracle:How to retrieve Nth row from Oracle?
SELECT * FROM (SELECT ROWNUM r, username FROM tblUsers ORDER BY 1) WHERE r=1;
SELECT * FROM tblUsers WHERE rownum=1;
Selecting the username column from the fifth row:
SELECT * FROM (SELECT ROWNUM r, username FROM tblUsers ORDER BY 1) WHERE r=5;
Thursday, March 24, 2011
Saturday, March 19, 2011
Unix Question
What scheme does the Kernel in Unix System V follow while choosing a swap device among the multiple swap devices?
Unix Question
What scheme does the Kernel in Unix System V follow while choosing a swap device among the multiple swap devices?
Is XSS exists in the below case?
There exists input field, which allows all type of malicious(XSS) characters and it allows to send it to the server. But the server doesn't respond to any request. Is this vulnerable condition? if so, how to proove it?
For ex:
A application has feed back functionality. In the process of testing this functionality, an attacker sent malicious character to the server..and it allows to send any type of characters. But the application responds with a message saying "Feeb back received, thanx". Is this case vulnerable?
Is XSS exists in the below case?
There exists input field, which allows all type of malicious(XSS) characters and it allows to send it to the server. But the server doesn't respond to any request. Is this vulnerable condition? if so, how to proove it?
For ex:
A application has feed back functionality. In the process of testing this functionality, an attacker sent malicious character to the server..and it allows to send any type of characters. But the application responds with a message saying "Feeb back received, thanx". Is this case vulnerable?
Friday, March 18, 2011
Is XSS server side or client side vulnerability
Is Cross Site Scripting is server side vulnerability or client side vulnerability?
Is XSS server side or client side vulnerability
Is Cross Site Scripting is server side vulnerability or client side vulnerability?
Interview Question
Given a sorted array of size m+n which has only n elements in it. Given one more array with m elements where the elements are sorted. Without using extra space merge both the arrays to form a single sorted array. Give efficient solution.
Interview Question
Consider a two-dimensional grid of cells, each of which may be empty or filled. The filled cells that are connected form a sector. Two cells are said to be connected if they are adjacent to each other horizontally, vertically or diagonally. There may be several sectors on the grid. Your job is to find the largest sector (in terms of number of cells) on the grid.
Thursday, March 17, 2011
Java Interview Question
Given an example of tag interface? what is the use of tag interface and write a class which is a tag interface
Wednesday, March 16, 2011
PO Approval Workflow stucket at "Deferred" status
Hi,
I have a PO which is waiting for approval from user. But, the notification has not gone to approver's worklist. How to rectify this in workflow?
Thanks..
PO Approval Workflow stucket at "Deferred" status
Hi,
I have a PO which is waiting for approval from user. But, the notification has not gone to approver's worklist. How to rectify this in workflow?
Thanks..
query to find vendor’s responses to negotiations for which the vendor has been invited.
Hi to all,
Please help me to resolve this issue.i am stuck.
· query to list out all the details of the negotiations the vendor has been invited.
· The vendor responses, awards.
· Purchase orders created against the quotes.
Thanks to all
Monday, March 14, 2011
What do you meant by "triple X" in Networks?
The function of PAD (Packet Assembler Disassembler) is described in a document known as X.3. The standard protocol has been defined between the terminal and the PAD, called X.28; another standard protocol exists between hte PAD and the network, called X.29. Together, these three recommendations are often called "triple X"
Difference between the communication and transmission
Transmission is a physical movement of information and concern issues like bit polarity, synchronisation, clock etc.
Communication means the meaning full exchange of information between two communication media.
what is subnet?
A generic term for section of a large networks usually separated by a bridge or router.
Sunday, March 13, 2011
Saturday, March 12, 2011
Unix Interview Question
Predict the output of the following program code
main()
{
fork(); fork(); fork();
printf("Hello World!");
}
Unix Interview Question
Predict the output of the following program code
main()
{
fork();
printf("Hello World!");
}
Friday, March 11, 2011
FA Depreciation Query
select fb.BOOK_TYPE_CODE
,fa.ASSET_NUMBER
,fa.asset_id
,fdp.period_name
,fat.DESCRIPTION ASSET_DESCRIPTION
,fa.OWNED_LEASED
,fc.SEGMENT1 MAJOR_CATEGORY
,fc.SEGMENT2 MINOR_CATEGORY
,fb.DEPRN_METHOD_CODE
,fc.SEGMENT3 TOWER
,gcc.segment3 PROJECT_CODE
,ppa.name PROJECT_NAME
,fak.segment1 OWNER_OF_ASSET
,pap.FULL_NAME EMPLOYEE_NAME
,pap.EMPLOYEE_NUMBER
-- ,fl.CONCATENATED_SEGMENTS LOCATION
,gcc.segment3 Project
,gcc.segment4 Facility
,gcc.segment5 STP
,gcc.CONCATENATED_SEGMENTS DEPRECIATION_FLEX
,fb.DATE_PLACED_IN_SERVICE
,(fb.LIFE_IN_MONTHS/12) LIFE_IN_YEARS
,fb.LIFE_IN_MONTHS
,gl.CURRENCY_CODE
,ROUND(fb.COST,2) COST
,fds.DEPRN_AMOUNT
,fds.DEPRN_RESERVE ACC_DEPRN ,ROUND(DECODE(fdp.FISCAL_YEAR,fbc.CURRENT_FISCAL_YEAR,fds.YTD_DEPRN,0),2) YTD_DEPRN
from apps.fa_additions_b fa
,apps.fa_categories fc
,apps.fa_locations_kfv fl
,apps.fa_books fb
,apps.pa_projects_all ppa
,apps.per_all_people_f pap
,apps.fa_distribution_history fdh
,apps.gl_code_combinations_kfv gcc
,apps.fa_deprn_periods fdp
,apps.fa_deprn_summary fds
,apps.fa_book_controls fbc
,apps.gl_ledgers gl
,apps.FA_CATEGORY_BOOKS fcb
,apps.gl_code_combinations_kfv gcc1
,apps.FA_ASSET_KEYWORDS fak
,apps.hr_operating_units hou
,apps.fa_additions_tl fat
where fa.ASSET_CATEGORY_ID = fc.CATEGORY_ID
and fa.ASSET_ID = fat.ASSET_ID(+)
and fdh.LOCATION_ID = fl.LOCATION_ID(+)
and fa.ASSET_ID = fb.ASSET_ID
and gcc.segment3 = ppa.segment1(+)
and fa.ASSET_ID = fdh.ASSET_ID(+)
and fdh.assigned_to = pap.PERSON_ID(+)
and fdh.CODE_COMBINATION_ID = gcc.CODE_COMBINATION_ID(+)
and fb.BOOK_TYPE_CODE = fdp.BOOK_TYPE_CODE
and fds.ASSET_ID = fb.ASSET_ID
and fb.BOOK_TYPE_CODE = fbc.BOOK_TYPE_CODE
and fbc.SET_OF_BOOKS_ID = gl.LEDGER_ID
and gl.LEDGER_CATEGORY_CODE = 'PRIMARY'
and fcb.CATEGORY_ID(+) = fc.CATEGORY_ID
and fcb.BOOK_TYPE_CODE = fb.BOOK_TYPE_CODE(+)
and fcb.ASSET_COST_ACCOUNT_CCID = gcc1.CODE_COMBINATION_ID
and fa.ASSET_KEY_CCID = fak.CODE_COMBINATION_ID(+)
and hou.SET_OF_BOOKS_ID = gl.ledger_id
and fdp.PERIOD_COUNTER = DECODE(fbc.INITIAL_PERIOD_COUNTER,fds.PERIOD_COUNTER,fds.PERIOD_COUNTER + 1 ,fds.PERIOD_COUNTER)
and sysdate between nvl(pap.EFFECTIVE_START_DATE(+),sysdate) and nvl(pap.EFFECTIVE_END_DATE(+),sysdate)
and fb.DATE_INEFFECTIVE IS NULL
and fdh.DATE_INEFFECTIVE IS NULL
Thursday, March 10, 2011
Query to find orders on hold in Oracle Apps 11i
SELECT rc.CUSTOMER_NAME, ooha.ORDER_NUMBER, ohsa.HOLD_COMMENT, ohd.NAME, ohd.TYPE_CODE, oola.ORDERED_ITEM,
(oola.ORDERED_QUANTITY * oola.UNIT_SELLING_PRICE) AMOUNT
FROM
OE_ORDER_HEADERS_ALL ooha
,OE_ORDER_HOLDS_ALL oha
,OE_HOLD_SOURCES_ALL ohsa
,OE_HOLD_DEFINITIONS ohd
,OE_ORDER_LINES_ALL oola
,RA_CUSTOMERS rc
WHERE
ooha.HEADER_ID = oola.HEADER_ID
AND ooha.HEADER_ID = oha.HEADER_ID
AND oola.LINE_ID = oha.LINE_ID
AND oha.RELEASED_FLAG='N'
AND oha.HOLD_SOURCE_ID = ohsa.HOLD_SOURCE_ID
AND ohsa.HOLD_ID = ohd.HOLD_ID
AND rc.CUSTOMER_ID = ooha.SOLD_TO_ORG_ID
AND ooha.ORDER_NUMBER= <ORDER_NUMBER>
By: Rads
Wednesday, March 9, 2011
Query for JE Source Cost Management
How to get vendor details for je source cost management in Oracle R12?
Microsoft Interview Question
write a program to print all elements of a binary tree using a breadth First traversal through it.
Tuesday, March 8, 2011
Delivered Quantity is greater than PO Quantity
The delivered quantity is 20 and PO Quantity is 2.
What might be the reason for the user to receive the quantity greater than PO Quantity?
Here,it is mentioned the over receipt tolerance is 10% in Receiving Parameters
What might be the reason for the user to receive the quantity greater than PO Quantity?
Here,it is mentioned the over receipt tolerance is 10% in Receiving Parameters
RTF file Location in Oracle Apps R12
The rtf files loaded through XML Publisher Administrator can be found in $XDO_TOP/patch/115/publisher/templates/US.
Sunday, March 6, 2011
Oracle Apps Inventory Question
How to assign the entire Inventory items to the newly created OU in 11.5.10.2?
Blanket PO Interview Question
How to find the released quantity for a Blanket PO using backend tables?
Oracle Apps Inventory Interview Question
How to move items from one subinventory to another subinventory at one shot?
Thursday, March 3, 2011
Interview Question
A boy, a girl and a dog are standing together on a long, straight road. Simultaneously, they all start walking in the same direction: The boy at 4 mph, the girl at 3 mph, and the dog trots back and forth between them at 10 mph. Assume all reversals of direction instantaneous. In one hour, where is the dog and in which direction is he facing?
Wednesday, March 2, 2011
Subscribe to:
Posts (Atom)