GP_WC_ITM_LB_VW

(SQL View)
 Index Back

Checklist label for work centr

Checklist label for work centre

SELECT A.PTAI_LIST_ID ,( SELECT MAX(X1.PTAI_SEQ) FROM PS_PTAI_ITEM X1 WHERE X1.PTAI_LIST_ID = A.PTAI_LIST_ID AND X1.PTAI_SUMMARY = 'Y' AND X1.PTAI_SEQ <= A.PTAI_SEQ) , A.PTAI_ITEM_ID ,A.PTAI_LABEL , A.PTAI_SUMMARY FROM PS_PTAI_ITEM A WHERE A.PTAI_SUMMARY = 'N'

  • Related Language Record: GP_WC_VW2_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PTAI_LIST_ID Character(31) VARCHAR2(31) NOT NULL Action Items - Action Item List ID
    2 PTAI_SEQ Number(4,0) SMALLINT NOT NULL Sequence
    3 PTAI_ITEM_ID Character(31) VARCHAR2(31) NOT NULL Action Items - Action Item ID
    4 PTAI_LABEL Character(100) VARCHAR2(100) NOT NULL Action Items - Label
    5 PTAI_SUMMARY Character(1) VARCHAR2(1) NOT NULL Summary
    N=No
    Y=Yes