DBA Data[Home] [Help]

APPS.OE_OE_AVAILABILITY dependencies on QP_PREQ_LINE_ATTRS_TMP

Line 3031: QP_PREQ_LINE_ATTRS_TMP QPLAT

3027: QPLAT.VALIDATED_FLAG,
3028: QPLAT.PRICING_STATUS_CODE,
3029: QPLAT.PRICING_STATUS_TEXT
3030: FROM QP_PREQ_LDETS_TMP QPLD ,
3031: QP_PREQ_LINE_ATTRS_TMP QPLAT
3032: WHERE QPLD.LINE_DETAIL_INDEX = QPLAT.LINE_DETAIL_INDEX
3033: AND QPLD.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
3034: AND QPLAT.ATTRIBUTE_TYPE = 'QUALIFIER';
3035: --AND QPLAT.PRICING_STATUS_CODE = G_STATUS_NEW;

Line 3048: QP_PREQ_LINE_ATTRS_TMP QPLAT_PRICING

3044: QPLAT_PRICING.LINE_DETAIL_INDEX,
3045: QPLAT_PRICING.LINE_INDEX,
3046: QPLAT_PRICING.VALIDATED_FLAG
3047: FROM QP_PREQ_LDETS_TMP QPLD ,
3048: QP_PREQ_LINE_ATTRS_TMP QPLAT_PRICING
3049: WHERE QPLD.LINE_DETAIL_INDEX = QPLAT_PRICING.LINE_DETAIL_INDEX
3050: AND QPLD.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
3051: AND QPLAT_PRICING.ATTRIBUTE_TYPE IN ('PRICING','PRODUCT');
3052: --AND QPLAT_PRICING.PRICING_STATUS_CODE = G_STATUS_NEW;