Search results for query: *

Thanks.

OK, copied it over to a new file and got this error... ERROR at line 9: ORA-00904: "GL"."DEBIT_AMOUNT": invalid identifier This deals with the DECODE

dagon, Could you illustrate what you mean. Thanks

Dagon, Added your suggestion(s) and now get this error Line 12 AT"."ENTRY_USER": invalid identifier ?

Yes, I was attempting my first try with an inline view. Thanks for the quick response. Will apply your suggestions and let you know.

The following script tells me invalid table name. I'm confused as this is defined. I'm trying to count all the claims and money by biller and show a total for everything. Here is the code. ------CLRK_DAILY8 set verify off set linesize 80 set pagesize 60 INPUT ACCEPT EDATE ENTRY_DATE PROMPT...

LKBrwnDBA, Your replies to the ansi thread have been deleted. I know no other way to correspond. Could you tell me how ? Thanks

Dagon, We have a working script. I addded your change to the B.Bill_Date and B.Enc_Date and I changed the last 4 lines to read........... HAVING SUM ( DECODE(substr( TRANS_CD,1,1)'U',G.Credit_Amount, 0)) !=0) G Where B.Bill_Date Between Trunc(Sysdate) -232 And Trunc(Sysdate) -120 And G.Cntrl_No...

I get this error "G"."ENC_DATE": invalid identifier

I had tried the above changes but I also had gone to the B alias and added the B.Bill_Date and B.Enc_Date. I thought they had to be part of the first select. Where G.Enc_Date Between Trunc(Sysdate) -210 And Trunc(Sysdate) -120 Should not the G become a B since the ENC_Date is part of the...

The one you submitted on 19 Aug 2008 @9:01 I need to replace those G statements for the Bill_Date and Trans_Date and the G.Entry_Date. The Bill_Date becomes B.Bill_Date and the Trans_Date becomes B.ENC_Date and also Entry_Date becomes B.ENC_Date I made a mistake in the original using the...

SqlPlus 10.0 Oracle 10g

Dagon, Last glitch. I need to exchange two fields. G.Bill_Date,---> becomes b.bill_Date, G.Trans_Date,---> becomes b.Enc_Date, and then the final change is Where G.Entry_Date Between Trunc(Sysdate) -210 And Trunc(Sysdate) -120 G.Entry_Date becomes B.Enc_date When I do these changes then I get...

Thanks

Ok, so how would that be applied to your answer on the 19th Here is what you said on the 19th.................. At the moment I'm probably suggesting something along the lines of: CODE Select To_Char (Sysdate, 'Mm/Dd/Yy Hh24mi') Todays_Date, B.Ins_Co_Name, B.Ins_Co_Address2...

Yes, that is exactly the answer. Thanks

Ok, Is the above code using decode the best way to go about this and how would you add all three columns ? Thanks

Dagon, Your analysis is correct. Trying to add all 3 columns which should equal the original billed amount. It appears that the A08,A09,A10,A20 have something to do with these few accounts. Not every claim has these transactions so the total amount does equal the billed amount when adding all 3...

Dagon, Can you help with one more item for this code ? I'm trying to have the money in the payment, adjustment, and Jag add up to equal the total billed amount in the total column. The problem is under the adjustments there are codes that are used for credit_amount and debit_amount. By using...

I wish to thank everyone on this post for guiding me to the proper conclusion. I have since made a Master Detail report that prints the claim data below an insurance company and then does a page break once the company changes, etc. etc. [2thumbsup] Gator25