APPS.PO_WF_PO_CHARGE_ACC SQL Statements

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

Line: 41

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

Line: 131

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_debug_stmt);

Line: 167

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_debug_stmt);

Line: 178

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_debug_stmt);

Line: 222

Adding the organization_id condition to the select below.
*/
    select expense_account into x_account
    from mtl_secondary_inventories
    where secondary_inventory_name = x_dest_sub_inv
    and organization_id = x_dest_org_id;

Line: 236

      select EXPENSE_ACCOUNT into x_account
      from MTL_SYSTEM_ITEMS
      where organization_id = x_dest_org_id
      and inventory_item_id = x_item_id;

Line: 249

    select expense_account into x_account
    from mtl_parameters
    where organization_id = x_dest_org_id;

Line: 274

      select material_account into x_account
      from mtl_parameters
      where organization_id = x_dest_org_id;

Line: 288

      select expense_account into x_account
      from mtl_secondary_inventories
      where secondary_inventory_name = x_dest_sub_inv
      and   organization_id        = x_dest_org_id;

Line: 301

        select expense_account into x_account
        from mtl_parameters
        where organization_id = x_dest_org_id;

Line: 316

      select material_account into x_account
      from mtl_secondary_inventories
      where secondary_inventory_name = x_dest_sub_inv
      and   organization_id        = x_dest_org_id;

Line: 327

        select material_account into x_account
        from mtl_parameters
        where organization_id = x_dest_org_id;

Line: 397

  select inventory_asset_flag into x_asset_item_flag
  from mtl_system_items
  where organization_id = x_dest_org_id
  and inventory_item_id = x_item_id;

Line: 419

       PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
         'PO_WF_PO_CHARGE_ACC.check_inv_item_type EXCEPTION at '||x_progress
          ||': '||SQLERRM);

Line: 441

  select asset_inventory into x_asset_inventory
  from mtl_secondary_inventories
  where secondary_inventory_name = x_dest_sub_inv
  and   organization_id        = x_dest_org_id;

Line: 490

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

Line: 552

    select EXPENSE_ACCOUNT into x_expense_acc
    from MTL_SYSTEM_ITEMS
    where organization_id = x_dest_org_id
    and inventory_item_id = x_item_id;

Line: 578

      PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
             'PO_WF_PO_CHARGE_ACC.expense result='||result);

Line: 597

    PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
             'PO_WF_PO_CHARGE_ACC.expense x_expense_acc='||x_expense_acc);

Line: 632

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

Line: 701

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

Line: 753

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

Line: 769

                        SELECT outside_processing_account
                        INTO x_wip_job_account
                        FROM WIP_DISCRETE_JOBS
                        WHERE ORGANIZATION_ID = x_destination_organization_id
                        AND  WIP_ENTITY_ID = NVL(x_wip_entity_id,-99)
                        AND   OUTSIDE_PROCESSING_ACCOUNT <> -1;

Line: 825

                        SELECT OVERHEAD_ACCOUNT INTO x_wip_job_account
                        FROM WIP_DISCRETE_JOBS
                        WHERE ORGANIZATION_ID = x_destination_organization_id
                        AND  (WIP_ENTITY_ID = NVL(x_wip_entity_id,-99)
      AND   OVERHEAD_ACCOUNT <> -1
      AND   NVL(x_wip_entity_type,'2') in ('1', '3', '4', '5'));

Line: 840

                        SELECT outside_processing_account INTO x_wip_job_account
                        FROM WIP_DISCRETE_JOBS
                        WHERE ORGANIZATION_ID = x_destination_organization_id
                        AND  (WIP_ENTITY_ID = NVL(x_wip_entity_id,-99)
      AND   OUTSIDE_PROCESSING_ACCOUNT <> -1
      AND   NVL(x_wip_entity_type,'2') in ('1', '3', '4', '5'));

Line: 855

                        SELECT RESOURCE_ACCOUNT INTO x_wip_job_account
                        FROM WIP_DISCRETE_JOBS
                        WHERE ORGANIZATION_ID = x_destination_organization_id
                        AND  (WIP_ENTITY_ID     = NVL(x_wip_entity_id,-99)
      AND   RESOURCE_ACCOUNT <> -1
      AND   NVL(x_wip_entity_type,'2') in ('1', '3', '4', '5'));

Line: 870

                        SELECT MATERIAL_OVERHEAD_ACCOUNT INTO x_wip_job_account
                        FROM WIP_DISCRETE_JOBS
                        WHERE ORGANIZATION_ID = x_destination_organization_id
                        AND  (WIP_ENTITY_ID = NVL(x_wip_entity_id,-99)
      AND   MATERIAL_OVERHEAD_ACCOUNT <> -1
      AND   NVL(x_wip_entity_type,'2') in ('1', '3', '4', '5'));

Line: 885

                        SELECT MATERIAL_ACCOUNT INTO x_wip_job_account
                        FROM WIP_DISCRETE_JOBS
                        WHERE ORGANIZATION_ID = x_destination_organization_id
                        AND  (WIP_ENTITY_ID = NVL(x_wip_entity_id,-99)
      AND   MATERIAL_ACCOUNT <> -1
      AND   NVL(x_wip_entity_type,'2') in ('1', '3', '4', '5'));

Line: 899

                    SELECT FLEX_VALUE INTO x_wip_job_account
                    FROM FND_FLEX_VALUES_VL
                    WHERE FLEX_VALUE = x_destination_organization_id
                    AND (FLEX_VALUE_SET_ID = 102256);

Line: 912

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

Line: 932

       /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, 'EXCEPTION IN PO_WF_PO_CHARGE_ACC.JOB_WIP');

Line: 960

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

Line: 1010

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

Line: 1017

                        SELECT OVERHEAD_ACCOUNT INTO x_wip_schedule_account
                        FROM WIP_REPETITIVE_SCHEDULES
                        WHERE ORGANIZATION_ID = x_destination_organization_id
                        AND  (WIP_ENTITY_ID = NVL(x_wip_entity_id,-99)
      AND   '2' = NVL(x_wip_entity_type,'1')
      AND   REPETITIVE_SCHEDULE_ID = NVL(x_wip_repetitive_schedule_id,-99)
      AND   OVERHEAD_ACCOUNT <> -1);

Line: 1034

                        SELECT OUTSIDE_PROCESSING_ACCOUNT INTO x_wip_schedule_account
                        FROM WIP_REPETITIVE_SCHEDULES
                        WHERE ORGANIZATION_ID = TO_NUMBER(x_destination_organization_id)
                        AND  (WIP_ENTITY_ID = NVL(x_wip_entity_id,-99)
      AND   '2' = NVL(x_wip_entity_type,'1')
      AND   REPETITIVE_SCHEDULE_ID = NVL(x_wip_repetitive_schedule_id,-99)
      AND   OUTSIDE_PROCESSING_ACCOUNT <> -1);

Line: 1050

                        SELECT RESOURCE_ACCOUNT INTO x_wip_schedule_account
                        FROM WIP_REPETITIVE_SCHEDULES
                        WHERE ORGANIZATION_ID = x_destination_organization_id
                        AND  (WIP_ENTITY_ID = NVL(x_wip_entity_id,-99)
      AND   '2'           = NVL(x_wip_entity_type,'1')
      AND   REPETITIVE_SCHEDULE_ID = NVL(x_wip_repetitive_schedule_id,-99)
      AND  RESOURCE_ACCOUNT <> -1) ;

Line: 1067

                        SELECT MATERIAL_OVERHEAD_ACCOUNT INTO x_wip_schedule_account
                        FROM WIP_REPETITIVE_SCHEDULES
                        WHERE ORGANIZATION_ID = TO_NUMBER(x_destination_organization_id)
                        AND  (WIP_ENTITY_ID = NVL(x_wip_entity_id,-99)
      AND   '2'           = NVL(x_wip_entity_type,'1')
      AND   REPETITIVE_SCHEDULE_ID = NVL(x_wip_repetitive_schedule_id,-99)
      AND   MATERIAL_OVERHEAD_ACCOUNT <> -1);

Line: 1084

                        SELECT MATERIAL_ACCOUNT INTO x_wip_schedule_account
                        FROM WIP_REPETITIVE_SCHEDULES
                        WHERE ORGANIZATION_ID = x_destination_organization_id
                        AND  (WIP_ENTITY_ID = NVL(x_wip_entity_id,-99)
      AND   '2'           = NVL(x_wip_entity_type,'2')
      AND   REPETITIVE_SCHEDULE_ID = NVL(x_wip_repetitive_schedule_id,-99)
      AND   MATERIAL_ACCOUNT <> -1);

Line: 1099

                    SELECT FLEX_VALUE INTO x_wip_schedule_account
                    FROM FND_FLEX_VALUES_VL
                    WHERE FLEX_VALUE = x_destination_organization_id
                    AND (FLEX_VALUE_SET_ID = 102256);

Line: 1111

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

Line: 1131

       /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, 'EXCEPTION IN PO_WF_PO_CHARGE_ACC.SCHEDULE');

Line: 1162

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

Line: 1200

    PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'po_encumbrance_flag='||po_encumbrance_flag||', x_destination_type='||x_destination_type||', l_is_financing_flag='||l_is_financing_flag||', l_is_advance_flag='||l_is_advance_flag);

Line: 1213

    PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'org_id from PO_MOAC='||PO_MOAC_UTILS_PVT.get_current_org_id||', org_id from PO_GA_PVT='||PO_GA_PVT.get_current_org );

Line: 1215

    SELECT  nvl(fsp.purch_encumbrance_flag,'N'),
            nvl(fsp.req_encumbrance_flag,'N')
    INTO    l_purch_encumbrance_flag,
            l_req_encumbrance_flag
    FROM    financials_system_parameters fsp,
            gl_sets_of_books sob,
            po_system_parameters psp,
	  rcv_parameters  rcv
    WHERE   fsp.set_of_books_id = sob.set_of_books_id
    AND     rcv.organization_id (+) = fsp.inventory_organization_id;

Line: 1226

    PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'PO_CORE_S: l_purch_encumbrance_flag='||l_purch_encumbrance_flag||', l_req_encumbrance_flag='||l_req_encumbrance_flag);

Line: 1228

    SELECT purch_encumbrance_flag,
           req_encumbrance_flag
    INTO l_purch_encumbrance_flag,
         l_req_encumbrance_flag
    FROM FINANCIALS_SYSTEM_PARAMETERS; -- view

Line: 1234

    PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'View: l_purch_encumbrance_flag='||l_purch_encumbrance_flag||', l_req_encumbrance_flag='||l_req_encumbrance_flag);

Line: 1236

    SELECT purch_encumbrance_flag,
           req_encumbrance_flag
    INTO l_purch_encumbrance_flag,
         l_req_encumbrance_flag
    FROM FINANCIALS_SYSTEM_PARAMS_ALL -- table
    WHERE org_id = PO_MOAC_UTILS_PVT.get_current_org_id;

Line: 1243

    PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'Table: MOAC: l_purch_encumbrance_flag='||l_purch_encumbrance_flag||', l_req_encumbrance_flag='||l_req_encumbrance_flag);

Line: 1245

    SELECT purch_encumbrance_flag,
           req_encumbrance_flag
    INTO l_purch_encumbrance_flag,
         l_req_encumbrance_flag
    FROM FINANCIALS_SYSTEM_PARAMS_ALL -- table
    WHERE org_id = PO_GA_PVT.get_current_org;

Line: 1252

    PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'Table: PO_GA_PVT: l_purch_encumbrance_flag='||l_purch_encumbrance_flag||', l_req_encumbrance_flag='||l_req_encumbrance_flag);

Line: 1265

    PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'After: l_is_financing_flag='||l_is_financing_flag||', l_is_advance_flag='||l_is_advance_flag);

Line: 1286

     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

Line: 1422

    PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
             'PO_WF_PO_CHARGE_ACC.is_dest_accounts_flow_type result='||result);

Line: 1483

    PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
           'PO_WF_PO_CHARGE_ACC.is_SPS_distribution result='||result);

Line: 1525

  SELECT outside_operation_flag  -- it is a NOT NULL column
  INTO is_shopfloor_enabled_item
  FROM MTL_SYSTEM_ITEMS
  WHERE inventory_item_id = p_item_id AND
        organization_id = p_inv_org_id;

Line: 1574

  SELECT cost_of_sales_account
  INTO l_COGS_account_id
  FROM MTL_PARAMETERS
  WHERE ORGANIZATION_ID = p_inv_org_id;

Line: 1621

  SELECT expense_account
  INTO l_item_expense_account_id
  FROM MTL_SYSTEM_ITEMS
  WHERE organization_id = p_inv_org_id AND
        inventory_item_id = p_item_id;

Line: 1666

  SELECT expense_account
  INTO l_org_expense_account_id
  FROM MTL_PARAMETERS
  WHERE organization_id = p_inv_org_id;

Line: 1710

  SELECT material_account
  INTO l_org_material_account_id
  FROM MTL_PARAMETERS
  WHERE organization_id = p_inv_org_id;

Line: 1766

      SELECT operating_unit
      INTO l_temp_ou_id
      FROM org_organization_definitions
      WHERE organization_id = p_logical_inv_org_id;

Line: 1777

        PO_WF_DEBUG_PKG.insert_debug(p_itemtype, p_itemkey,
                                     'LINV does not belong to POU');

Line: 1783

        PO_WF_DEBUG_PKG.insert_debug(p_itemtype, p_itemkey,
                                     'Exception while sanity checking LINV');

Line: 1927

    PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
           'PO_WF_PO_CHARGE_ACC.get_SPS_charge_account result='||result);

Line: 1929

    PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
         'PO_WF_PO_CHARGE_ACC.get_SPS_charge_account l_SPS_charge_account_id='||
         l_SPS_charge_account_id);

Line: 1936

      PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
        'PO_WF_PO_CHARGE_ACC.get_SPS_charge_account EXCEPTION at '|| l_progress);

Line: 2004

      PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
        'PO_WF_PO_CHARGE_ACC.is_dest_charge_acc_null '||
        'Copying DestChargeAccId to TEMP_ACCOUNT_ID '||
        '(current val = ' || l_temp_acc_id || ') ' ||
        'dest_charge_account_id='||l_dest_charge_account_id);

Line: 2023

    PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
        'PO_WF_PO_CHARGE_ACC.is_dest_charge_acc_null result='||result||
        ' l_dest_charge_account_id='||l_dest_charge_account_id);

Line: 2115

    PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
           'PO_WF_PO_CHARGE_ACC.are_COAs_same result='||result);

Line: 2166

     PO_WF_DEBUG_PKG.insert_debug(itemtype,
                                  itemkey,
                                 'PO_WF_PO_CHARGE_ACC.set_null_resp_id: Setting the Responsibility to NULL ');

Line: 2216

     PO_WF_DEBUG_PKG.insert_debug(itemtype,
                                  itemkey,
                                 'PO_WF_PO_CHARGE_ACC.reset_resp_id: Setting the Responsibility back to:' || l_resp_id);

Line: 2299

    PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
        'PO_WF_PO_CHARGE_ACC.validate_combination: l_flex_status='
        ||l_flex_status);

Line: 2358

      PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
          'PO_WF_PO_CHARGE_ACC.validate_combination: l_is_combination_valid is false');