SSF_BILINEVWLNG

(SQL View)
 Index Back

Rel Lang Billing Item View

SSF_BILINEVWLNG is the language record view related to SSF_BI_LINE_VW

SELECT B.business_unit , B.common_id , B.INVOICE_ID , B.item_nbr , d.language_cd , d.descr FROM PS_BI_BILLING_LINE B , ps_item_sf A , PS_ITEM_LINE_SF c , ps_item_type_lng d , ps_bus_unit_tbl_sf e , PS_SCC_INS_NAME_VW f , PS_BI_BILL_HEADER G WHERE B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.COMMON_ID = C.COMMON_ID AND B.SA_ID_TYPE = C.SA_ID_TYPE AND B.ITEM_NBR = C.ITEM_NBR AND B.ITEM_LINE = C.LINE_SEQ_NBR AND c.business_unit = a.business_unit AND c.common_id = a.common_id AND c.sa_id_type = a.sa_id_type AND c.item_nbr = a.item_nbr AND a.sa_id_type = 'P' AND d.item_type = a.item_type AND e.business_unit = a.business_unit AND a.common_id = f.emplid AND G.BUSINESS_UNIT = B.BUSINESS_UNIT AND G.INVOICE_ID = B.INVOICE_ID AND d.setid= ( SELECT setid FROM ps_set_cntrl_rec WHERE setcntrlvalue=e.institution AND recname='ITEM_TYPE_TBL') AND d.effdt = ( SELECT MAX(effdt) FROM ps_item_type_lng WHERE d.setid = setid AND d.item_type = item_type AND d.language_cd = language_cd AND effdt <= %CurrentDateIn)

  • Related Language Record for SSF_BI_LINE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 INVOICE_ID Character(22) VARCHAR2(22) NOT NULL Invoice Number
    4 ITEM_NBR Character(15) VARCHAR2(15) NOT NULL Item Nbr
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description