Supply Chain Management - PSFT (MOSC)

MOSC Banner

Need help with Table and join details for Datetime and User details for PO, REQ, INV Approval.

Need help with Table and join details for Datetime and User details for PO, REQ, INV Approval.


I have the below draft query but its tough to join these with PO, REQ, INV tables


select

S."THREAD ID"

,S."STEP INSTANCE"

,S."PROCESS ID"

,S."DEFINITION ID"

,U."USER"

,U."STEP STATUS"

,U.DATETIME

,W."EVENT NAME"

from EOAW_STEPINST S

INNER JOIN EOAW_USERINST U

ON S."STEP INSTANCE" = U."STEP INSTANCE"

INNER JOIN EOAW_WL W

on S."THREAD ID" = W."THREAD ID"



I have below table details but not clear on the joins:

PYMNT_VCHR_XREF

REQ_PO_INQ_VW 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center