CA_BI_MGT_AI_V2

(SQL View)
 Index Back

ca_bi_mgt_ai_vw


SELECT DISTINCT A.CONTRACT_NUM , A.BILL_PLAN_ID ,A.DESCR , C.PROJECT_ID , B.CURRENCY_CD , D.BUSINESS_UNIT , D.BUSINESS_UNIT_BI , B.BUSINESS_UNIT_PC , D.BILL_TO_CUST_ID , A.BILL_PLAN_TYPE , A.BP_STATUS , D.CA_RQST_SRC , A.HOLD_FLAG , A.HOLD_DATE , B.CA_FEE_TYPE FROM PS_CA_BILL_PLAN A , PS_CA_DETAIL B , PS_CA_DETAIL_PROJ C , PS_CA_CONTR_HDR D WHERE A.BILL_PLAN_TYPE = '01' AND A.CONTRACT_NUM = D.CONTRACT_NUM AND A.CONTRACT_NUM = B.CONTRACT_NUM AND A.BILL_PLAN_ID = B.BILL_PLAN_ID AND C.CONTRACT_NUM = B.CONTRACT_NUM AND C.CONTRACT_LINE_NUM = B.CONTRACT_LINE_NUM AND A.BILL_PLAN_ID = B.BILL_PLAN_ID AND D.CA_STATUS <> 'CLOSED' AND NOT EXISTS ( SELECT 'X' FROM PS_CA_BI_MGT_AI_V3 V3 WHERE V3.CONTRACT_NUM = A.CONTRACT_NUM AND V3.BILL_PLAN_ID = A.BILL_PLAN_ID AND V3.PROJECT_ID = C.PROJECT_ID AND V3.CURRENCY_CD = B.CURRENCY_CD)

  • Related Language Record: CA_BI_MGMT_LVW2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
    2 BILL_PLAN_ID Character(10) VARCHAR2(10) NOT NULL Billing Plan ID
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
    5 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    6 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    7 BUSINESS_UNIT_BI Character(5) VARCHAR2(5) NOT NULL Billing Business Unit
    8 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit
    9 BILL_TO_CUST_ID Character(15) VARCHAR2(15) NOT NULL Customer
    10 BILL_PLAN_TYPE Character(2) VARCHAR2(2) NOT NULL Billing Method
    01=As Incurred
    02=Installment
    03=Recurring
    04=Milestone
    05=Percent Complete
    06=Immediate
    07=Value Based
    11 BP_STATUS Character(3) VARCHAR2(3) NOT NULL Billing Plan Status
    CAN=Cancelled
    DON=Completed
    PND=Pending
    PRG=In Progress
    RCL=Recycled
    RDY=Ready
    RIP=Reversal In Progress
    RQD=Action Required
    RRP=Recycled
    RVS=Reversed
    12 CA_RQST_SRC Character(3) VARCHAR2(3) NOT NULL Contract Classification
    FED=Federal Reimbursable Agreement
    GEN=Generic Application
    GOV=Government
    INT=Internal
    OND=CRM Field Services On Demand
    STD=Standard
    13 HOLD_FLAG Character(1) VARCHAR2(1) NOT NULL Hold
    N=Hold
    Y=Hold
    14 HOLD_DATE Date(10) DATE Put On Hold Date
    15 CA_FEE_TYPE Character(2) VARCHAR2(2) NOT NULL Cost Plus Fee Type
    01=None
    02=Fixed Fee
    03=Award Fee
    04=Incentive Fee
    05=Other Fee