APPS.QP_LOCK_PRICELIST_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 18

    SELECT  ACCRUAL_QTY
    ,       ACCRUAL_UOM_CODE
    ,       ARITHMETIC_OPERATOR
    ,       ATTRIBUTE1
    ,       ATTRIBUTE10
    ,       ATTRIBUTE11
    ,       ATTRIBUTE12
    ,       ATTRIBUTE13
    ,       ATTRIBUTE14
    ,       ATTRIBUTE15
    ,       ATTRIBUTE2
    ,       ATTRIBUTE3
    ,       ATTRIBUTE4
    ,       ATTRIBUTE5
    ,       ATTRIBUTE6
    ,       ATTRIBUTE7
    ,       ATTRIBUTE8
    ,       ATTRIBUTE9
    ,       AUTOMATIC_FLAG
    ,       BASE_QTY
    ,       BASE_UOM_CODE
    ,       COMMENTS
    ,       CONTEXT
    ,       CREATED_BY
    ,       CREATION_DATE
    ,       EFFECTIVE_PERIOD_UOM
    ,       END_DATE_ACTIVE
    ,       ESTIM_ACCRUAL_RATE
    ,       GENERATE_USING_FORMULA_ID
    ,       INVENTORY_ITEM_ID
    ,       LAST_UPDATED_BY
    ,       LAST_UPDATE_DATE
    ,       LAST_UPDATE_LOGIN
    ,       LIST_HEADER_ID
    ,       LIST_LINE_ID
    ,       LIST_LINE_NO
    ,       LIST_LINE_TYPE_CODE
    ,       LIST_PRICE
    ,       PRODUCT_PRECEDENCE
    ,       MODIFIER_LEVEL_CODE
    ,       NUMBER_EFFECTIVE_PERIODS
    ,       OPERAND
    ,       ORGANIZATION_ID
    ,       OVERRIDE_FLAG
    ,       PERCENT_PRICE
    ,       PRICE_BREAK_TYPE_CODE
    ,       PRICE_BY_FORMULA_ID
    ,       PRIMARY_UOM_FLAG
    ,       PRINT_ON_INVOICE_FLAG
    ,       PROGRAM_APPLICATION_ID
    ,       PROGRAM_ID
    ,       PROGRAM_UPDATE_DATE
    ,       REBATE_TRANSACTION_TYPE_CODE
    ,       RELATED_ITEM_ID
    ,       RELATIONSHIP_TYPE_ID
    ,       REPRICE_FLAG
    ,       REQUEST_ID
    ,       REVISION
    ,       REVISION_DATE
    ,       REVISION_REASON_CODE
    ,       START_DATE_ACTIVE
    ,       SUBSTITUTION_ATTRIBUTE
    ,       SUBSTITUTION_CONTEXT
    ,       SUBSTITUTION_VALUE
    ,       QUALIFICATION_IND
    ,       RECURRING_VALUE -- block pricing
    ,       CUSTOMER_ITEM_ID
    ,       BREAK_UOM_CODE
    ,       BREAK_UOM_CONTEXT
    ,       BREAK_UOM_ATTRIBUTE
    ,       CONTINUOUS_PRICE_BREAK_FLAG
    FROM    QP_LIST_LINES l
    WHERE   l.LIST_HEADER_ID = a_list_header_id
    AND    (l.LIST_LINE_ID = a_list_line_id OR
            EXISTS (SELECT 'x'
                    FROM   QP_RLTD_MODIFIERS
                    WHERE  TO_RLTD_MODIFIER_ID = l.LIST_LINE_ID
                    AND    FROM_RLTD_MODIFIER_ID = a_list_line_id)
           );

Line: 137

      l_PRICE_LIST_LINE_rec.last_updated_by := l_rec.LAST_UPDATED_BY;

Line: 138

      l_PRICE_LIST_LINE_rec.last_update_date := l_rec.LAST_UPDATE_DATE;

Line: 139

      l_PRICE_LIST_LINE_rec.last_update_login := l_rec.LAST_UPDATE_LOGIN;

Line: 162

      l_PRICE_LIST_LINE_rec.program_update_date := l_rec.PROGRAM_UPDATE_DATE;

Line: 186

        SELECT  RLTD_MODIFIER_GRP_NO,
                RLTD_MODIFIER_GRP_TYPE,
                FROM_RLTD_MODIFIER_ID,
                TO_RLTD_MODIFIER_ID,
                RLTD_MODIFIER_ID
        INTO    l_PRICE_LIST_LINE_rec.rltd_modifier_group_no,
                l_PRICE_LIST_LINE_rec.rltd_modifier_grp_type,
                l_PRICE_LIST_LINE_rec.from_rltd_modifier_id,
                l_PRICE_LIST_LINE_rec.to_rltd_modifier_id,
                l_PRICE_LIST_LINE_rec.rltd_modifier_id
        FROM    QP_RLTD_MODIFIERS
        WHERE   TO_RLTD_MODIFIER_ID = l_rec.LIST_LINE_ID;

Line: 355

    SELECT list_header_id
    INTO   l_locked_price_list_id
    FROM   qp_list_headers_b
    WHERE  locked_from_list_header_id = p_source_price_list_id
    AND    source_system_code = l_source_system_code
    AND    rownum = 1; --only one row is expected anyway.

Line: 661

    p_pricing_attr_tbl.delete;

Line: 908

    p_pricing_attr_tbl.delete;