i want to find days between two dates
example
p_from_date = '2009/01/01 HH24:MI:SS'
p_to_date = '2009/12/09 HH24:MI:SS'
How i find exact days between these two dates.
Search found 31 matches
- Mon Mar 02, 2009 5:37 am
- Forum: Oracle Forms & Reports
- Topic: How to find days between two dates
- Replies: 1
- Views: 2110
- Thu May 15, 2008 9:22 am
- Forum: Oracle Forms & Reports
- Topic: How to call report from from in Developer Suit 10G
- Replies: 0
- Views: 1297
How to call report from from in Developer Suit 10G
Respected All, How to do call this report in Developer Suite 10g.This is built in 6i. I want to do this in Developer Suite 10g; declare d_where varchar2(5000); pl_id paramlist; MX integer; begin GO_BLOCK('EMP'); First_Record; If Not (:System.Last_Record = 'TRUE' And :SYSTEM.CURSOR_VALUE IS NULL) The...
- Sat Mar 29, 2008 2:13 am
- Forum: Order Management
- Topic: Technical Reference Document on OM and Purchasing
- Replies: 5
- Views: 2294
- Fri Mar 28, 2008 6:29 am
- Forum: Reports (Only Oracle Apps Reports)
- Topic: Giving Access to All Users of AP
- Replies: 2
- Views: 2012
Giving Access to All Users of AP
I have developed a new report and i want to give access to a single user
Can i have to create new responsibility and assign that report to it, or some other way
Thanks
Can i have to create new responsibility and assign that report to it, or some other way
Thanks
- Fri Mar 28, 2008 6:04 am
- Forum: Order Management
- Topic: Giving Access to All Users of AP
- Replies: 1
- Views: 1161
Giving Access to All Users of AP
I have developed a new report and i want to give access to all users of AP to use this report.
How can i do that?
How can i do that?
- Fri Mar 28, 2008 6:00 am
- Forum: Order Management
- Topic: Technical Reference Document on OM and Purchasing
- Replies: 5
- Views: 2294
- Fri Mar 28, 2008 3:36 am
- Forum: Order Management
- Topic: Technical Reference Document on OM and Purchasing
- Replies: 5
- Views: 2294
Technical Reference Document on OM and Purchasing
Dear All,
I am new in Oracle Apps. I am doing hard work to learn. Please give some link of Technical Reference Document or Book on Order Management or Purchasing Module.I would be very thankful to you
I am new in Oracle Apps. I am doing hard work to learn. Please give some link of Technical Reference Document or Book on Order Management or Purchasing Module.I would be very thankful to you
- Thu Jun 07, 2007 3:40 am
- Forum: Oracle Forms & Reports
- Topic: Relationship Between Master and Detail Forms
- Replies: 7
- Views: 2976
- Wed Jun 06, 2007 9:10 am
- Forum: Oracle Forms & Reports
- Topic: Relationship Between Master and Detail Forms
- Replies: 7
- Views: 2976
Please check it out.I am doing like that i have master form name DTEST that contains Dept Table Columns. Second form is DTEST1 that contains Emp Table Columns and is in tabular form.I have a button on DTEST form and when_button_pressed trigger i have written this code Declare CURSOR C IS SELECT * FR...
- Wed Jun 06, 2007 1:48 am
- Forum: Oracle Forms & Reports
- Topic: Relationship Between Master and Detail Forms
- Replies: 7
- Views: 2976
- Mon Jun 04, 2007 5:10 am
- Forum: Oracle Forms & Reports
- Topic: Relationship Between Master and Detail Forms
- Replies: 7
- Views: 2976
My requirement is that Master form is based on Dept Table and Detail form is based on Emp Table.I have two seperate forms one for Master and other for Detail.When i execute query on Master form suppose on executing query deptno 10 is displayed .When i click button to call Detail Form information sho...
- Mon Jun 04, 2007 3:46 am
- Forum: Oracle Forms & Reports
- Topic: Relationship Between Master and Detail Forms
- Replies: 7
- Views: 2976
Relationship Between Master and Detail Forms
I have created two forms one is master and other is detail .I have called detail form from master from .I want to create relationship between both forms.
Please make me solution.
Please make me solution.
- Sat Jun 02, 2007 7:56 am
- Forum: Oracle Forms & Reports
- Topic: Configuring Application Server 6
- Replies: 7
- Views: 2280
- Sat Jun 02, 2007 4:55 am
- Forum: Oracle Forms & Reports
- Topic: Configuring Application Server 6
- Replies: 7
- Views: 2280
- Fri Jun 01, 2007 1:48 am
- Forum: Oracle Forms & Reports
- Topic: Configuring Application Server 6
- Replies: 7
- Views: 2280