RECV_DEL_UP_SCH

(SQL View)
 Index Back

Receipt Update Search

Receipt Update Search

SELECT HDR.BUSINESS_UNIT , HDR.RECEIVER_ID , HDR.BILL_OF_LADING , SHP.BUSINESS_UNIT_PO , SHP.DESCR254_MIXED , SHP.INV_ITEM_ID , HDR.ORIGIN , SHP.PO_ID , HDR.PO_RECEIPT_FLG , HDR.VENDOR_SETID , SHP.SHIPTO_ID , HDR.SHIPMENT_NO , HDR.VENDOR_ID , VND.NAME1 , HDR.RECEIPT_DT , HDR.RECV_STATUS , SHP.REVISION , DST.ATTN_TO , DST.LOCATION , CASE WHEN REQ.REQUESTOR_ID IS NOT NULL AND REQ.REQUESTOR_ID <> ' ' THEN REQ.REQUESTOR_ID ELSE CASE WHEN PO.BUYER_ID IS NOT NULL AND PO.BUYER_ID <> ' ' THEN PO.BUYER_ID ELSE '' END END , PRO.PRO_NUMBER , DST.DELIVERY_CART_ID , DST.DELIVERED_DT FROM %Table(RECV_HDR) HDR , %Table(RECV_LN_SHIP) SHP LEFT OUTER JOIN %Table(RECV_LN_PRO) PRO ON %Join(COMMON_KEYS, RECV_LN_SHIP SHP, RECV_LN_PRO PRO) , %Table(RECV_LN_DISTRIB) DST LEFT OUTER JOIN %Table(REQ_HDR) REQ ON DST.BUSINESS_UNIT_PO = REQ.BUSINESS_UNIT AND DST.REQ_ID = REQ.REQ_ID , %Table(RECV_LN_DISTRIB) DS2 LEFT OUTER JOIN %Table(PO_HDR) PO ON DS2.BUSINESS_UNIT_PO = PO.BUSINESS_UNIT AND DS2.PO_ID = PO.PO_ID , PS_VENDOR VND WHERE %Join(COMMON_KEYS, RECV_HDR HDR, RECV_LN_SHIP SHP) AND %Join(COMMON_KEYS, RECV_LN_SHIP SHP, RECV_LN_DISTRIB DST) AND %Join(COMMON_KEYS, RECV_LN_DISTRIB DST, RECV_LN_DISTRIB DS2) AND HDR.RECV_STATUS NOT IN ('C', 'X') AND HDR.VENDOR_SETID = VND.SETID AND HDR.VENDOR_ID = VND.VENDOR_ID

  • Related Language Record: RECV_PO_SRCH_LN

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

    Default Value: OPR_DEF_TBL_PM.BUSINESS_UNIT_RECV

    Prompt Table: SP_BU_PM_NONVW

    2 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number

    Default Value: NEXT

    3 BILL_OF_LADING Character(30) VARCHAR2(30) NOT NULL Specifies a bill of lading number associated with a Receivables item.
    4 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit

    Prompt Table: SP_BU_PM_NONVW

    5 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
    6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

    Prompt Table: ITM_PURCH_VW

    7 ORIGIN Character(3) VARCHAR2(3) NOT NULL Origin
    8 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order

    Prompt Table: RECV_PO_HDR_VW

    9 PO_RECEIPT_FLG Character(1) VARCHAR2(1) NOT NULL PO Receipt Flag - identifies if the receipt is related to a purchase order
    10 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    11 SHIPTO_ID Character(10) VARCHAR2(10) NOT NULL Ship To Location

    Prompt Table: SHIPTO_TBL

    12 SHIPMENT_NO Character(30) VARCHAR2(30) NOT NULL Shipment Number
    13 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VENDOR_VW

    14 VENDOR_NAME1 Character(40) VARCHAR2(40) NOT NULL Vendor Name1
    15 RECEIPT_DT Date(10) DATE Received Date
    16 RECV_STATUS Character(1) VARCHAR2(1) NOT NULL Receipt Status
    C=Closed Receipt
    H=Hold Receipt
    M=Moved to Destination
    N=PO Not Received
    O=Open
    P=PO Partially Received
    R=Fully Received
    X=Canceled
    17 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label
    18 ATTN_TO Character(30) VARCHAR2(30) NOT NULL Attention

    Prompt Table: RECV_INQ_ATN_VW

    19 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: LOCATION_VW

    20 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id

    Prompt Table: REQUESTOR_VW

    21 PRO_NUMBER Character(40) VARCHAR2(40) NOT NULL Pro Number

    Prompt Table: RECV_INQ_PRO_VW

    22 DELIVERY_CART_ID Character(10) VARCHAR2(10) NOT NULL Container ID

    Prompt Table: DELV_CART_VW

    23 DELIVERED_DT Date(10) DATE Delivered Date