CM_LC_RECV_VW

(SQL View)
Index Back

Landed Cost Receiver Line View

Receiver Lines for Distinct Business Unit/Receiver ID combinations with corresponding Landed Cost charges - KDN - 04/00 R-DWWC593_801 dmw : for landed cost manual close page - Chg view to use new view RCV_LN_SH_LC_VW instead of RECV_LN_SHIP_LC.

SELECT A.BUSINESS_UNIT , A.RECEIVER_ID , A.RECV_LN_NBR , A.RECV_SHIP_SEQ_NBR , A.MATCH_STATUS_LC , A.INV_ITEM_ID , A.CURRENCY_CD_BASE FROM PS_RECV_LN_SHIP A WHERE EXISTS ( SELECT 'X' FROM PS_RCV_LN_SH_LC_VW B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.RECEIVER_ID = B.RECEIVER_ID AND A.RECV_LN_NBR = B.RECV_LN_NBR AND A.RECV_SHIP_SEQ_NBR = B.RECV_SHIP_SEQ_NBR AND B.LC_COMP_FLAG = 'Y')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
3 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
4 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
5 MATCH_STATUS_LC Number(1,0) SMALLINT NOT NULL 03/14/99 ebn CN#CM800-2.0 : Added for Landed Cost Enhancement
6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
7 CURRENCY_CD_BASE Character(3) VARCHAR2(3) NOT NULL Business Unit Base Currency