DBA Data[Home] [Help]

APPS.OKS_IMPORT_VALIDATE dependencies on FND_USER

Line 5647: ,FND_USER USR

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 (+)

Line 5760: ,FND_USER USR

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'