5643: FROM OKS_NOTES_INTERFACE ONI
5644: ,OKS_INT_HEADER_STG_TEMP OHSTG
5645: ,FND_LOOKUPS NTSTATUS
5646: ,FND_LOOKUPS NTTYPE
5647: ,FND_USER USR
5648:
5649: WHERE ONI.HEADER_INTERFACE_ID = OHSTG.HEADER_INTERFACE_ID
5650: AND ONI.LINE_INTERFACE_ID IS NULL
5651: AND ONI.NOTE_STATUS =NTSTATUS.LOOKUP_CODE (+)
5756: FROM OKS_NOTES_INTERFACE ONI
5757: ,OKS_INT_LINE_STG_TEMP OLSTG
5758: ,FND_LOOKUPS NTSTATUS
5759: ,FND_LOOKUPS NTTYPE
5760: ,FND_USER USR
5761:
5762: WHERE ONI.LINE_INTERFACE_ID = OLSTG.LINE_INTERFACE_ID
5763: AND ONI.NOTE_STATUS =NTSTATUS.LOOKUP_CODE (+)
5764: AND NTSTATUS.LOOKUP_TYPE (+) ='JTF_NOTE_STATUS'