FO_CA_DETAIL_VW

(SQL View)
 Index Back

Contract Lines not linked

Show contract lines that are not linked to any PO

SELECT D.CONTRACT_NUM ,D.CONTRACT_LINE_NUM ,D.PRODUCT_ID ,D.DESCR ,D.PRICING_STRUCTURE FROM PS_CA_DETAIL D , PS_RS_SO_HDR O , PS_RS_ASSIGNMENT A WHERE D.CONTRACT_NUM = O.CONTRACT_NUM AND D.CONTRACT_LINE_NUM = A.CONTRACT_LINE_NUM AND O.BUSINESS_UNIT = A.BUSINESS_UNIT AND O.SO_ID = A.SO_ID AND A.AWAITING_PO_FLG = 'Y' AND NOT EXISTS ( SELECT 'X' FROM PS_FO_PO_LINK WHERE PS_FO_PO_LINK.CONTRACT_NUM = D.CONTRACT_NUM AND PS_FO_PO_LINK.CONTRACT_LINE_NUM = D.CONTRACT_LINE_NUM )

  • Related Language Record: FO_CA_DTL_VW_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract

    Prompt Table: CA_BU_SP_NONVW

    2 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num

    Prompt Table: CA_DETAIL

    3 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 PRICING_STRUCTURE Character(4) VARCHAR2(4) NOT NULL Price Type
    AMT=Amount
    PCT=Percent
    RATE=Rate
    RCR=Recurring