[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

strange PS code in SQR (redundant)



Hi all,

A friend of mine is showing me some code (below) and asking what it does,
since the table does not appear to be defined in either Oracle or PS.
Anyone seen anything like this?  What's with the ##PS_INTFC_BI_HT1 table
name?  It exists in the biif0001.sqc bisetup3.sqc programs.

curious clark

BEGIN-SQL ON-ERROR=CANNOT-INSERT

INSERT INTO ##PS_INTFC_BI_HT1
SELECT [$Htmp_Fields]
FROM  PS_INTFC_BI_HTMP
WHERE PROCESS_INSTANCE =  #process_instance
AND   TARGET_INVOICE   = ' '
AND   TRANS_TYPE_BI    <> 'AHDR'

END-SQL

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com