Get po_header_id first and run each query and then analyze the data.
For better understanding this is splited into 5 major stages.
Stage 1: PO Creation
select po_header_id from po_headers_all where segment1 =;
select * from po_headers_all where po_header_id =;
select * from po_lines_all where po_header_id =;
select * from po_line_locations_all where po_header_id =;
select * from po_distributions_all where po_header_id =;
SELECT * FROM po_releases_all WHERE po_header_id =;
Stage 2: Once PO is received, data is moved to respective receving tables and inventory tables
select * from rcv_shipment_headers where shipment_header_id in
(select shipment_header_id from rcv_shipment_lineswhere po_header_id =);
select * from rcv_shipment_lines where po_header_id =;
select * from rcv_transactions where po_header_id =;
SELECT * FROM rcv_Accounting_Events WHERE rcv_transaction_id IN
(select transaction_id from rcv_transactionswhere po_header_id =);
select * from rcv_receiving_sub_ledger where rcv_transaction_id IN
(select transaction_id from rcv_transactions where po_header_id =);
select * from rcv_sub_ledger_detailswhere rcv_transaction_id IN
(select transaction_id from rcv_transactions where po_header_id =);
select * from mtl_material_transactions where transaction_source_id =;
select * from mtl_transaction_accounts where transaction_id IN
(select transaction_id from mtl_material_transactions where transaction_source_id =);
Stage 3: Invoicing details
select * from ap_invoice_distributions_all where po_distribution_id in
( select po_distribution_id from po_distributions_all where po_header_id =);
select * from ap_invoices_all where invoice_id in
(select invoice_id from ap_invoice_distributions_all where po_distribution_id in( select po_distribution_id from po_distributions_all where po_header_id =));
Stage 4 : Mostly there is tie up with Project related PO
select * from pa_expenditure_items_all peia where peia.orig_transaction_reference IN
(select to_char(transaction_id) from mtl_material_transactions where transaction_source_id = );
Stage 5 : General Ledger
Prompt 17. GL_BC_PACKETS ..This is for encumbrances
SELECT * FROM gl_bc_packets WHERE reference2 IN (’‘);
select * from gl_interface gli where user_je_source_name =’Purchasing’
and gl_sl_link_table =’RSL’ and reference21=’PO’ and exists
(select 1 from rcv_receiving_sub_ledger rrsl where gli.reference22 =RRSL.reference2 and GLI.reference23 =RRSL.reference3AND GLI.reference24 =RRSL.reference4AND RRSL.rcv_transaction_id in(select transaction_id from rcv_transactionswhere po_header_id ));
SELECT *FROM gl_import_references GLIR WHERE reference_1=’PO’ AND gl_sl_link_table =’RSL’AND EXISTS
( SELECT 1 FROM rcv_receiving_sub_ledger RRSLWHERE GLIR.reference_2 =RRSL.reference2AND GLIR.reference_3 =RRSL.reference3 AND GLIR.reference_4 =RRSL.reference4AND RRSL.rcv_transaction_id in
(select transaction_id from rcv_transactions where po_header_id =))
Login to Application Server on Unix Box for Compiling Forms
f60gen module=CUSTOM.pll userid=apps/(appspwd) module_type=LIBRARY batch=NO compile_all=special output_file=$AU_TOP/resource/CUSTOM.plx
f60gen module=XXPOCF.fmb userid=apps/(appspwd) module_type=form batch=no compile_all=special output_file=$XXPO_TOP/forms/US/XXPOCF.fmx
$ORACLE_HOME/bin/frmcmp_batch module_type=LIBRARY module=$AU_TOP/resource/CUSTOM.pll userid=apps/(appspwd)output_file=$AU_TOP/resource/CUSTOM.plx compile_all=special
$ORACLE_HOME/bin/frmcmp_batch module=$XXFND_TOP/forms/US/XXFND_FHLOG.fmb userid=apps/(appspwd) output_file=$XXFND_TOP/forms/US/XXFND_FHLOG.fmx module_type=form compile_all=special
16th March –Migration Scenarios for Oracle E-Business Suite
Oracle E-Business Suite (EBS) is a complex application with many different permutations for this family of products. EBS deployments generally require a unique plan for each environment in order to properly migrate the data, application customizations, and product specific functionality to the target platform. I am going to talk about following migration approaches in details. Tru64/AlphaServer(EBS 11i) to HP-UX/Integrity(EBS R12) HP-UX/PA-RISC(EBS 11i) to HP-UX/Integrity(EBS R12) SUN Solaris/SPARC(EBS 11i) to HP-UX/Integrity and Linux/ProLiant(EBS 11i) – Split Configuration.
For more webcast and AIOUG Events —
|11-AUG-2010||9:00 AM||All About Dead Locks||Arup Nanda||Members|
|13-OCT-2010||5:00 PM||RMAN: Backup and Recovery – The Most Essential but The Most Ignored||Asif Momen||Members|
|17-NOV-2010||5:00 PM||Extreme Performance with EXADATA||Satyendra Kumar||Members|
|12-JAN-2011||9:00 AM||11gR2 New Features in RAC – Part I – Whats news in Clusterware!!||Murali Vallath||Members|
|February||TechNight @ Chennai||Free||Free Event|
|09-FEB-2011||9:00 AM||Oracle Performance Tuning||Kapil Goyal||Members|
|16-MAR-2011||5:00 PM||Migration Scenarios for Oracle E-Business Suite||PS Janakiram||Free Event|
|13-APR-2011||5:00 PM||Oracle Scheduler and the Database Resource Manager||Bala Kumar||Free Event|
|11-MAY-2011||5:00 PM||Oracle Application(EBS) Upgrade Best Practices||Mithun Ashok||Free Event|
|June||TechDay @ TBD||Free||Free Event|
Life is an Oracle…
Make your life as deep as a Database.
Be always as unique as a Primary Key.
Be productive as an Index.
Take others’ good habits as a Foreign Key.
Share your joys with others as a Cluster.
Always keep note of your doings as good as a Data Dictionary.
Grant some privileges to others as a Role.
Secure the things as a DBA.
Do the things in order as a Rowid.
Follow your resolution as strict as a Sequence.
Light other’s life as a Trigger.
Be prepared for the worst as an Exception.
Always be fruitful as a Function.
Forgive others as a Rollback Transaction.
Be thankful to God as a Commit Transaction.
Always help others like Checkpoint.
Choose the best path like an Optimizer.
Project yourself the best like a View.
DO ALL THESE, YOUR PLACE WILL BECOME ORACLE
The target audience will be primarily Joomla! Content Management System developers, designers, administrators and users, Business owners & technologists as well as Joomla end users this means that anyone can come to Joomla Day and participate.
Delegates will come from a range of public and private sectors, both national and international, in various markets, actively seeking information about Joomla! and other areas of web-based technology.
Event Details– Date : 12th & 13th March, 2011. Saturday, Sunday.
MCCIA Trade Tower,
5th floor, International Conventional Center,
Senapati Bapat Road,
Registration – FREE — http://ticketing.ayojak.com/event/joomla-day-india-2011
Courtesy to – HBR Blog Full article – http://blogs.hbr.org/schwartz/2011/03/30-things-we-need-and-30-we-do.html
Do you have the feeling, as I do, that in the tsunami of everyday life, we’re getting too much of stuff we don’t need, and not enough of what we do? Herewith my first set of suggestions about how to redress the imbalance:
|WE NEED LESS:||WE NEED MORE:|
|Shallow billionaires||Passionate teachers|
|Multitasking||Control of our attention|
|Super sizes||Smaller portions|
|Private jets||High-speed trains|
|Constructive criticism||Thank-you notes|
|Righteousness||Doing the right thing|
|Long hours||Longer sleep|