APPS.INV_WORKFLOW SQL Statements

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

Line: 95

    SELECT patch_level
    FROM   fnd_product_installations
    WHERE  application_id = 555;  --GMF product

Line: 136

        SELECT cost_of_sales_account
          INTO v_item_cogs
          FROM mtl_system_items
         WHERE inventory_item_id = ic_item_id
           AND organization_id = ic_to_inv_organization_id;

Line: 164

        SELECT source_document_type_id
          INTO v_doc_type_id
          FROM oe_order_lines_all
         WHERE line_id = TO_NUMBER(ic_order_line_id);

Line: 190

        SELECT mp.ap_accrual_account, mp.process_enabled_flag, prl.requisition_line_id
          INTO v_order_type_cogs, v_process_enabled_flag, v_requisition_line_id
          FROM mtl_parameters mp, po_requisition_lines_all prl, oe_order_lines_all ool
         WHERE ool.line_id = TO_NUMBER(ic_order_line_id)
           AND prl.requisition_line_id = ool.source_document_line_id
           AND mp.organization_id = prl.destination_organization_id;

Line: 222

              SELECT accrual_account_id
                INTO v_order_type_cogs
                FROM po_req_distributions_all
               WHERE requisition_line_id = v_requisition_line_id
                 AND rownum < 2;

Line: 245

          SELECT NVL(cost_of_goods_sold_account, 0)
            INTO v_order_type_cogs
            FROM oe_transaction_types_all
           WHERE transaction_type_id = TO_NUMBER(ic_order_type_id)a
             AND 1 = 1;

Line: 266

          SELECT NVL(cost_of_goods_sold_account, 0)
            INTO v_order_type_cogs
            FROM oe_transaction_types_all
           WHERE transaction_type_id = TO_NUMBER(ic_order_type_id)
             AND 1 = 1;

Line: 285

          SELECT NVL(cost_of_goods_sold_account, 0)
            INTO v_order_type_cogs
            FROM oe_transaction_types_all
           WHERE transaction_type_id = TO_NUMBER(ic_order_type_id)
             AND 1 = 1;

Line: 291

          SELECT org_id, order_source_id
            INTO l_ship_ou_id, l_order_src_id
            FROM oe_order_headers_all
           WHERE header_id = to_number(ic_order_header_id);

Line: 297

              SELECT chart_of_accounts_id
                INTO l_chart_of_accounts_id
                FROM gl_code_combinations
               WHERE code_combination_id = v_order_type_cogs;

Line: 303

               SELECT NVL(freight_code_combination_id, 0)
                 INTO v_order_type_cogs
                 FROM mtl_intercompany_parameters
                WHERE ship_organization_id = l_ship_ou_id
                  AND sell_organization_id = to_number(ic_sell_oper_unit)
                  AND flow_type = 1;

Line: 334

        SELECT cost_of_sales_account
          INTO v_organization_cogs
          FROM mtl_parameters
         WHERE organization_id = ic_to_inv_organization_id;