1 Reply Latest reply on Jan 12, 2018 9:52 AM by Sanjay Desai EBS

    Product Type

    user557016

      Purchasing and Accounts Payable

      Were can I configure product type?  The values that are associated to product type are currently GOODS and SERVICES.  Is this a lookup?  I am looking to add another product type.

        • 1. Re: Product Type
          Sanjay Desai EBS

          You can add the PO line type by following navigation.

           

          PO Resp > Setup > Purchasing > Line Type

           

          You can get the line type data using below query.

           

             SELECT LT.LINE_TYPE,

                    LT.DESCRIPTION,

                    LT.LINE_TYPE_ID,

                    LC.DISPLAYED_FIELD,

                    LT.ORDER_TYPE_LOOKUP_CODE,

                    LT.CATEGORY_ID,

                    LT.UNIT_OF_MEASURE,

                    LT.UNIT_PRICE,

                    LT.OUTSIDE_OPERATION_FLAG,

                    LT.RECEIVING_FLAG,

                    LT.PURCHASE_BASIS,

                    LC1.DISPLAYED_FIELD PURCHASE_BASIS_DSP,

                    LT.MATCHING_BASIS

               FROM PO_LINE_TYPES LT, PO_LOOKUP_CODES LC, PO_LOOKUP_CODES LC1

              WHERE     SYSDATE < NVL (LT.INACTIVE_DATE, SYSDATE + 1)

                    AND LC.LOOKUP_CODE = LT.ORDER_TYPE_LOOKUP_CODE

                    AND LC.LOOKUP_TYPE = 'ORDER TYPE'

                    AND LT.PURCHASE_BASIS = LC1.LOOKUP_CODE

                    AND LC1.LOOKUP_TYPE = 'PURCHASE BASIS';