Search This Blog

Wednesday, February 22, 2012

Query to Find Pricing Contexts and Its Attributes

SELECT
  A.PRC_CONTEXT_TYPE,
  A.PRC_CONTEXT_CODE,
  A.SEEDED_FLAG SEEDED_CONTEXT,
  A.ENABLED_FLAG CONTEXT_ENABLED,
  B.SEGMENT_ID,
  B.SEGMENT_CODE CODE,
  B.USER_PRECEDENCE,
  B.SEEDED_FLAG SEEDED_ATTRIBUTE,
  B.SEGMENT_MAPPING_COLUMN COLUMN_MAPPED,
  C.SEGMENT_LEVEL LEVEL_CODE,
  C.SEEDED_SOURCING_METHOD,
  C.USER_SOURCING_METHOD SOURCING_METHOD,
  C.SOURCING_ENABLED SOURCING_ENABLED,
  C.USED_IN_SETUP USED_IN_SETUP,
  C.SOURCING_STATUS SOURCE_STATUS,
  C.LOV_ENABLED LOV_ENABLED,
  C.LIMITS_ENABLED LIMITS_ENABLED,
  B.AVAILABILITY_IN_BASIC AVAIL_IN_BASIC
FROM
  QP_PRC_CONTEXTS_B A,
  QP_SEGMENTS_B B,
  QP_PTE_SEGMENTS C
WHERE
  A.PRC_CONTEXT_TYPE IN ('PRODUCT', 'QUALIFIER', 'PRICING_ATTRIBUTE')
AND B.PRC_CONTEXT_ID  = A.PRC_CONTEXT_ID
AND C.SEGMENT_ID      = B.SEGMENT_ID
AND C.PTE_CODE        = 'ORDFUL'
AND A.PRC_CONTEXT_CODE LIKE &Context
AND A.PRC_CONTEXT_TYPE = 'QUALIFIER'
ORDER BY
  PRC_CONTEXT_TYPE,
  A.PRC_CONTEXT_CODE;

1 comment:

  1. Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please check oracleappstechnical.com

    ReplyDelete