DBA Data[Home] [Help]

APPS.OE_OE_AVAILABILITY dependencies on QP_PREQ_LINE_ATTRS_TMP

Line 3026: QP_PREQ_LINE_ATTRS_TMP QPLAT

3022: QPLAT.VALIDATED_FLAG,
3023: QPLAT.PRICING_STATUS_CODE,
3024: QPLAT.PRICING_STATUS_TEXT
3025: FROM QP_PREQ_LDETS_TMP QPLD ,
3026: QP_PREQ_LINE_ATTRS_TMP QPLAT
3027: WHERE QPLD.LINE_DETAIL_INDEX = QPLAT.LINE_DETAIL_INDEX
3028: AND QPLD.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
3029: AND QPLAT.ATTRIBUTE_TYPE = 'QUALIFIER';
3030: --AND QPLAT.PRICING_STATUS_CODE = G_STATUS_NEW;

Line 3043: QP_PREQ_LINE_ATTRS_TMP QPLAT_PRICING

3039: QPLAT_PRICING.LINE_DETAIL_INDEX,
3040: QPLAT_PRICING.LINE_INDEX,
3041: QPLAT_PRICING.VALIDATED_FLAG
3042: FROM QP_PREQ_LDETS_TMP QPLD ,
3043: QP_PREQ_LINE_ATTRS_TMP QPLAT_PRICING
3044: WHERE QPLD.LINE_DETAIL_INDEX = QPLAT_PRICING.LINE_DETAIL_INDEX
3045: AND QPLD.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW
3046: AND QPLAT_PRICING.ATTRIBUTE_TYPE IN ('PRICING','PRODUCT');
3047: --AND QPLAT_PRICING.PRICING_STATUS_CODE = G_STATUS_NEW;