LM_BO008_B1_VW

(SQL View)
 Index Back

For PO Balance Report

For PO Balance Report

SELECT E.OPRID , E.RUN_CNTL_ID , B.LM_ORG_DESCR , B.LM_ORGANIZATION_ID , B.LM_PO_ID , B.LM_PO_PURCHASE_DT , B.LM_AMT , B.CURRENCY_CD , B.LM_EXP_DT , B.LM_BALANCE_AMT , A.NAME , B.LM_PO_NAME , R.LANGUAGE_CD FROM PS_LM_RUNCTL_FI E , PS_LM_PER_NAME_VW A , PS_LM_PO_ORG_SR_VW B , PS_PRCSRUNCNTL R WHERE E.OPRID = R.OPRID AND E.RUN_CNTL_ID = R.RUN_CNTL_ID AND B.LM_OWNER_ID = A.LM_PERSON_ID AND ( B.LM_ORG_TYPE = E.LM_ORG_TYPE_RPT OR E.LM_ORG_TYPE_RPT = 'ALL') AND ( B.LM_ORGANIZATION_ID = E.LM_ORGANIZATION_ID OR 0 = E.LM_ORGANIZATION_ID) AND ( B.LM_PO_NAME = E.LM_PO_NAME OR E.LM_PO_NAME = ' ' OR E.LM_PO_NAME IS NULL) AND ( B.LM_PO_PURCHASE_DT >= E.LM_PO_PURCHASE_DT OR E.LM_PO_PURCHASE_DT IS NULL) AND ( B.LM_EXP_DT >= B.LM_EXP_DT OR E.LM_EXP_DT IS NULL) AND ( A.LM_PERSON_ID = E.LM_PERSON_ID OR E.LM_PERSON_ID = 0)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 LM_ORG_DESCR Character(50) VARCHAR2(50) NOT NULL Customer Description
4 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID
5 LM_PO_ID Number(10,0) DECIMAL(10) NOT NULL Purchase Order Id. Unique key for purchase orders.
6 LM_PO_PURCHASE_DT Date(10) DATE PO Purchase Date
7 LM_AMT Number(23,3) DECIMAL(22,3) NOT NULL Amount available
8 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
9 LM_EXP_DT Date(10) DATE Expiry Date for PO, TUs.
10 LM_BALANCE_AMT Number(22,2) DECIMAL(21,2) NOT NULL Balance Amount available for payment.
11 NAME Character(50) VARCHAR2(50) NOT NULL Name
12 LM_PO_NAME Character(20) VARCHAR2(20) NOT NULL PO Number field in the PO table.
13 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code