Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rmwcalum98

    create value set using unique recs from table

    Yes, it is the e-business suite. I pulled the following out of the About screen: RDBMS : 9.2.0.5.0 Oracle Applications : 11.5.9 I can't really get more specific about the app. All I know is when I log in, I get a list of responsibilities. I am choosing the application developer one (the same...
  2. rmwcalum98

    create value set using unique recs from table

    The application is Oracle 11i. I am actually creating a value set to be used to populate a parameter in a concurrent program. When you log into the app, the path is: application developer (provided you have been assigned that responsibility by the sysadmin) -> application -> validation -> set.
  3. rmwcalum98

    create value set using unique recs from table

    turns out that I can only select tables and not views if I choose the table validation type. the list of validation types are independent, dependent, special, table, none, pair, translatable independent, and translatable dependent. I did try special and chose query as the event and typed in the...
  4. rmwcalum98

    create value set using unique recs from table

    thanks, I will create a view.
  5. rmwcalum98

    create value set using unique recs from table

    this is within the application, where I am trying to setup the value set; it does not allow me to specify code; I simply pick the table and the column. I can't write any code except for the where or order_by statement.
  6. rmwcalum98

    create value set using unique recs from table

    I am trying to create a value set in Oracle11i. I am creating an LOV for the value set from a table. For example, the LOV will be populated by: select batch_name from pa_transaction_interface_all; When I go to concurrent programs and try to select a value for the parameter, I get every...
  7. rmwcalum98

    is there such a thing as a cursor in Crystal?

    But ALL items on the order have to be voided for the record to fulfill the report req. So, if an order has 7 items, then SUM has to be 7. A sum of 1-6, while greater than 0, means that not all items have been voided. I thought about doing a group, counting the number of rows for that order and...
  8. rmwcalum98

    is there such a thing as a cursor in Crystal?

    Siggy, Actually, the void column defaults to 0 and changes to 1 if the item is voided. So, your idea of summing up the rows for each order to see if they are greater than 0 won't work. I liked your idea of grouping, though, and I'm seeing if I can take a similar route. Thanks.
  9. rmwcalum98

    is there such a thing as a cursor in Crystal?

    Thank you, synapsevampire. I am new to CR, and you have given me a lot of help. Now, I will try and go use what you have put in your response. :)
  10. rmwcalum98

    is there such a thing as a cursor in Crystal?

    Is there such a thing as a cursor in Crystal? My CR 8.5 reference manual does not make any mention of cursors. It briefly goes over loops, but I am not finding that helpful in my case. The report I'm working on needs to select all orders older than 30 days that either have no items or have all...
  11. rmwcalum98

    Parameters <> Table Data

    I am creating a report in which a parameter will pass a Yes or No value. However, that is not the value in the table. The value to be analyzed is a date. For example, if the parameter Value is Y, then I need to retrieve all records with a Date greater than or equal to the SYSDATE. Somehow this...

Part and Inventory Search

Back
Top