APPS.OKL_AM_OM_REMARKET_WF SQL Statements

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

Line: 21

    OE_STANDARD_WF.OEOL_SELECTOR
           (p_itemtype => itemtype
           ,p_itemkey => itemkey
           ,p_actid => actid
           ,p_funcmode => 'TEST_CTX'
           ,p_result => l_resultout
           );

Line: 31

      OE_STANDARD_WF.OEOL_SELECTOR
           (p_itemtype => itemtype
           ,p_itemkey => itemkey
           ,p_actid => actid
           ,p_funcmode => 'SET_CTX'
           ,p_result => l_resultout
           );

Line: 251

    SELECT line_id, inventory_item_id
    FROM   oe_order_lines_all
    WHERE  header_id = p_id;

Line: 259

    SELECT inventory_item_id
    FROM   oe_order_lines_all
    WHERE  line_id = cp_line_id;

Line: 268

    SELECT ar.id art_id ,l.ordered_quantity ordered_quantity
    FROM   oe_order_headers_all h,
           oe_order_lines_all l,
           mtl_system_items_b i,
           okl_asset_returns_b ar
    WHERE h.header_id = l.header_id
    and l.ship_from_org_id = i.organization_id
    AND l.inventory_item_id = i.inventory_item_id
    AND l.inventory_item_id = ar.imr_id
    AND h.flow_status_code = 'BOOKED'
    AND i.inventory_item_id = p_item_id
    AND l.inventory_item_id = p_item_id;

Line: 283

    SELECT cim.number_of_items quantity, oar.ars_code ars_code
    FROM   okc_k_lines_b kle,
           okl_asset_returns_all_b oar,
           okc_k_lines_b kle2,
           okc_line_styles_b lse,
           okc_k_items cim
    WHERE  oar.kle_id = kle.id
    AND kle.id = kle2.cle_id
    AND kle2.lse_id = lse.id
    AND lse.lty_code = 'ITEM'
    AND kle2.id = cim.cle_id
    AND oar.id = p_id;

Line: 338

                        OKL_ASSET_RETURNS_PUB.update_asset_returns(
                        p_api_version        => p_api_version,
                        p_init_msg_list      => OKL_API.G_FALSE,
                        x_return_status      => x_return_status,
                        x_msg_count          => x_msg_count,
                        x_msg_data           => x_msg_data,
                        p_artv_rec           => lp_artv_rec,
                        x_artv_rec           => lx_artv_rec);

Line: 447

    SELECT line_id, inventory_item_id
    FROM   oe_order_lines_all
    WHERE  header_id = p_id;