Search found 10 matches
- Tue Apr 10, 2007 5:46 am
- Forum: General / Others
- Topic: Cursors
- Replies: 1
- Views: 1334
Cursors
Hi all, I am facing one situation regarding PL/SQL I an fetching two dates in a cursor like cursor c1 is select iess.eventdate, ss.insert_date, s.shipment_gid from ie_shipmentstatus, status_history shipment s where iess.i_transaction_no = ss.trancastion.no s.shipment_gid = ss.shipment_gid the output...
- Fri Mar 30, 2007 7:55 am
- Forum: Oracle Databases
- Topic: Order by
- Replies: 1
- Views: 1392
Order by
Hi,
select distinct RTRIM(SUBSTR(to_char(start_time,'dd-month-yyyy'),4),'-2007') a FROM SHIPMENT order by a
The output is coming like
april
august
december
febrauary
january
How to get that in Sequence like
january
febrauary
march
april
Regards
Sateesh
select distinct RTRIM(SUBSTR(to_char(start_time,'dd-month-yyyy'),4),'-2007') a FROM SHIPMENT order by a
The output is coming like
april
august
december
febrauary
january
How to get that in Sequence like
january
febrauary
march
april
Regards
Sateesh
- Wed Aug 09, 2006 8:28 am
- Forum: General / Others
- Topic: Packet writer Failure
- Replies: 1
- Views: 1504
Hi, In my view When u Uninstall Client and Developer the above mentioned error should not Repeat. how it is coming ? may be it's a miracle My suggestion is: Once again u try to uninstall both oracle client as well as Developer and also delete the instance of ORACLE in REGEDIT And then Install the OR...
- Tue Jul 25, 2006 4:15 am
- Forum: General / Others
- Topic: need every first character are upper in query
- Replies: 2
- Views: 2225
- Tue Jul 25, 2006 2:21 am
- Forum: Financials (GL, AP, AR, FA & CM)
- Topic: AP Invoice Interface
- Replies: 1
- Views: 1852
AP Invoice Interface
I am importing Invoice from legaccy system thru ap_invoices_interface and ap_invoice_lines_interface the data is importing properly into the ap_invoices_all and ap_invoice_distribtions_all,but my current requirement is the impoted invoice should be validated and accounted automatically,which columns...
- Wed Jul 19, 2006 3:44 am
- Forum: Purchasing & Inventory
- Topic: Link b/w Customer Part no and Inventory item
- Replies: 0
- Views: 1280
Link b/w Customer Part no and Inventory item
Hi all,
I got a requirement such that
i need to dispaly the customer part no based on the invoice number in Report
can u please tell me the table to link customer_part_no with invoice num in AR
Please do the needful
Satti
I got a requirement such that
i need to dispaly the customer part no based on the invoice number in Report
can u please tell me the table to link customer_part_no with invoice num in AR
Please do the needful
Satti
- Mon May 22, 2006 8:42 am
- Forum: Financials (GL, AP, AR, FA & CM)
- Topic: Functional currency in Invoice
- Replies: 3
- Views: 2846
Functional currency in Invoice
Hi all,
When i am creating Invoice the functional currency is defaulting to USD
i need it to change to INR?how can i proceed
the navigation Path is as follows
Payables Responsibility->Invoices->entry->invoices
Please help me.
Satti
When i am creating Invoice the functional currency is defaulting to USD
i need it to change to INR?how can i proceed
the navigation Path is as follows
Payables Responsibility->Invoices->entry->invoices
Please help me.
Satti
- Fri May 19, 2006 1:28 am
- Forum: Financials (GL, AP, AR, FA & CM)
- Topic: Expense Report
- Replies: 0
- Views: 1438
Expense Report
Hi All,
GL_ACCOUNT is not populating Automatically on the Expense Report Window (lines Section)based on the item and template selected.
The navigation path is as follows
invoices->Entry->Expense Reports
Satti
GL_ACCOUNT is not populating Automatically on the Expense Report Window (lines Section)based on the item and template selected.
The navigation path is as follows
invoices->Entry->Expense Reports
Satti
- Fri May 19, 2006 1:20 am
- Forum: Financials (GL, AP, AR, FA & CM)
- Topic: Attributes in descriptive Flexfiled
- Replies: 1
- Views: 1871
Attributes in descriptive Flexfiled
Hi,
I got One Requirement to attach 20 attributes in a descriptive flexfield, is it possible to attach 20 fields to a descriptive flexfields?
If it is possible, Please specify how?
Satti
I got One Requirement to attach 20 attributes in a descriptive flexfield, is it possible to attach 20 fields to a descriptive flexfields?
If it is possible, Please specify how?
Satti
- Wed May 17, 2006 9:51 am
- Forum: Financials (GL, AP, AR, FA & CM)
- Topic: Attributes in descriptive Flexfiled
- Replies: 2
- Views: 1949
Attributes in descriptive Flexfiled
hi,
At max how many attributes we can attach in a descriptive flexfields?
Can we attach 20 attributes for Descriptive Flexfield?
Satti
At max how many attributes we can attach in a descriptive flexfields?
Can we attach 20 attributes for Descriptive Flexfield?
Satti