SQL & PL/SQL :: Pending Purchase Requisitions Without PO

Jun 1, 2010

I am tring to create a query about finding our pending purchuase requestions without PO, we have 4 tables, 2 for PRs & 2 for POs, you can not creat a PO without having a PR,the problem that I tried to find out the pending PRs for all projects and PRs but the query is taking so much time and computer is hanging , is their any way to generate it grouped by project number and PR number and include material in each PR, below is description of all tables related:

PRs table:

MASTER:
--------------------
PRNUMBER
TYPE
MADEBY
PROJECTNUM
[code]....

View 1 Replies


ADVERTISEMENT

SQL & PL/SQL :: DBA Pending Transaction In Database

Jun 16, 2011

application was not starting due to some pending transaction in database.Pending transactions were rolled back by DBA team.To avoid such situations what I thought was, having a job that will call a procedure that will monitor table status everyday and will send the mail. Now that job is working fine for no pending transactions in DBA_PENDING_TRANSACTIONS.

But now I am in doubt if someday there are PENDING TRANSACTIONs in the table DBA_PENDING_TRANSACTIONS, will SELECT * FROM DBA_ PENDING_ TRANSACTIONs query will work as normal or this whole process of monitoring table and sending mail will work fine?

View 3 Replies View Related

Server Administration :: New Feature Of 11g Called-Pending Statistics

Mar 31, 2011

What is the scenario, we should use the new feature of 11g called-Pending Statistics.

Eg:-
EXEC DBMS_STATS.set_table_prefs ('SCOTT', 'EMP', 'PUBLISH', 'false');

View 3 Replies View Related

SQL & PL/SQL :: Count Of Date Difference Using Pending State Value In Table Field

Feb 2, 2012

Find the date difference. I need to find that how many days the task is pending, if ACT_NAME field switching from 'SET PENDING%' to 'RESUME PENDING%' by using ACTIONTAKENDATETEXT field in the History table.

Example as needed:
NoPendingDays = 23 (8+15)

I have attached Create table and Insert table values sample as SQL file.

View 10 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved