SAC_RCV_SHID_V4

(SQL View)
Index Back

SELECT BUSINESS_UNIT , RECEIVER_ID , SHIPTO_ID FROM PS_RECV_HDR A WHERE EXISTS ( SELECT 'X' FROM PS_SAC_ERP_RCT_STS B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SHIPTO_ID = B.SHIPTO_ID AND A.RECEIVER_ID = B.RECEIVER_ID AND B.SAC_SYNC_STS = 'E' AND A.LAST_DTTM_UPDATE = B.LAST_DTTM_UPDATE)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_PM_NONVW

2 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
3 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location