PRODCTLG_IN_VW

(SQL View)
 Index Back

Prod Catlg inclusive prodgrps


SELECT C.SETID , C.CUST_ID , PGLN.SETID , PGLN.PRODUCT_ID , PI.DESCR , PCT.SETID , PCT.CATALOG_NBR , PGT.SETID , PGT.PRODUCT_GROUP FROM PS_PROD_ITEM PI , PS_PROD_PGRP_LNK PGLN , PS_PROD_GROUP_TBL PGT , PS_PRODCTLG_PGRP PGC , PS_PRODCTLG_TBL PCT , PS_PRODCTLG_CUST C WHERE PCT.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC SC WHERE SC.SETCNTRLVALUE = C.SETID AND SC.RECNAME = 'PRODCTLG_TBL') AND PCT.CATALOG_NBR = C.CATALOG_NBR AND PCT.EFF_STATUS = 'A' AND %EffdtCheck(PRODCTLG_TBL PCT2, PCT, %CurrentDateIn) AND PCT.INCL_EXCL_TYPE = 'I' AND PGC.SETID = PCT.SETID AND PGC.CATALOG_NBR = C.CATALOG_NBR AND PGC.EFFDT = PCT.EFFDT AND PGT.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE SETCNTRLVALUE = PGC.SETID AND RECNAME = 'PRODGP_CTLG_VW') AND PGT.PRODUCT_GROUP = PGC.PRODUCT_GROUP AND PGT.PROD_GRP_TYPE = 'CTLG' AND PGT.EFF_STATUS = 'A' AND %EffdtCheck(PROD_GROUP_TBL PGT2, PGT, %CurrentDateIn) AND PGLN.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC SC WHERE SC.SETCNTRLVALUE = PGT.SETID AND SC.RECNAME = 'PROD_CTLGGP_VW') AND PGLN.PROD_GRP_TYPE = 'CTLG' AND PGLN.PRODUCT_GROUP = PGT.PRODUCT_GROUP AND PI.SETID = PGLN.SETID AND PI.PRODUCT_ID = PGLN.PRODUCT_ID

  • Related Language Record: PRODCTLG_INVLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 CUST_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
    3 SETID_PRODUCT Character(5) VARCHAR2(5) NOT NULL Product SetID
    4 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 SETID_CATALOG Character(5) VARCHAR2(5) NOT NULL Catalog SetID
    7 CATALOG_NBR Character(18) VARCHAR2(18) NOT NULL Catalog Number
    8 SETID_PROD_GRP Character(5) VARCHAR2(5) NOT NULL Product Group SetID
    9 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL Product Group