LM_ORG_PO_VW (SQL View)	Index Back
ORG/TU view View of TUs within an organization

LM_ORG_PO_VW

(SQL View)

ORG/TU view

View of TUs within an organization

SELECT DISTINCT C.LM_ORGANIZATION_ID , A.LM_PO_ID , A.LM_PO_NAME , A.LM_CHARTFLD_TYPE , A.LM_CHARTFLD_VAL FROM PS_LM_ENRMT_PO_TBL A , PS_LM_MOP_OWNR_TBL B ,PS_LM_ORGANIZATION C WHERE A.LM_PO_ID = B.LM_MOP_ID AND B.LM_MOP_OWNER_ID = C.LM_ORGANIZATION_ID AND B.LM_MOP_TYPE = 'PO' AND B.LM_MOP_OWNER_TYPE ='ORG'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 LM_ORGANIZATION_ID Number(15,0) DECIMAL(15) NOT NULL Organization ID

2 LM_PO_ID Number(10,0) DECIMAL(10) NOT NULL Purchase Order Id. Unique key for purchase orders.

3 LM_PO_NAME Character(20) VARCHAR2(20) NOT NULL PO Number field in the PO table.

4 LM_CHARTFLD_TYPE Character(18) VARCHAR2(18) NOT NULL ChartField Type...One of 16 ChartFields.

5 LM_CHARTFLD_VAL Character(20) VARCHAR2(20) NOT NULL ChartField Value...Depending on ChartField Type, it would store one of the 16 Chartfield values supported.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	LM_ORGANIZATION_ID	Number(15,0)	DECIMAL(15) NOT NULL	Organization ID
2	LM_PO_ID	Number(10,0)	DECIMAL(10) NOT NULL	Purchase Order Id. Unique key for purchase orders.
3	LM_PO_NAME	Character(20)	VARCHAR2(20) NOT NULL	PO Number field in the PO table.
4	LM_CHARTFLD_TYPE	Character(18)	VARCHAR2(18) NOT NULL	ChartField Type...One of 16 ChartFields.
5	LM_CHARTFLD_VAL	Character(20)	VARCHAR2(20) NOT NULL	ChartField Value...Depending on ChartField Type, it would store one of the 16 Chartfield values supported.