APPS.INV_MGD_MVT_INV_MDTR SQL Statements

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

Line: 81

  SELECT
    inv.transaction_id
  , inv.transaction_type_id
  , inv.transaction_action_id
  , inv.transfer_organization_id
  , inv.transaction_date
  , inv.organization_id
  , inv.transaction_quantity
  , inv.subinventory_code
  , inv.transfer_subinventory
  FROM
    MTL_MATERIAL_TRANSACTIONS inv
  , hr_organization_information hoi
  WHERE inv.organization_id  = hoi.organization_id
  AND   hoi.org_information_context = 'Accounting Information'
  AND   hoi.org_information2 = to_char(p_movement_transaction.entity_org_id) /* bug 7676431: Added to_char */
  AND   inv.transaction_type_id   IN (21,3,12,2)
  AND   inv.transaction_action_id IN (21,3,12,2)
  AND   NVL(inv.mvt_stat_status,'NEW')   = 'NEW'
  AND   inv.transaction_date BETWEEN p_start_date AND p_end_date;

Line: 104

  SELECT
    inv.transaction_id
  , inv.transaction_type_id
  , inv.transaction_action_id
  , inv.transfer_organization_id
  , inv.transaction_date
  , inv.organization_id
  , inv.transaction_quantity
  , inv.subinventory_code
  , inv.transfer_subinventory
  FROM
    MTL_MATERIAL_TRANSACTIONS inv
  , hr_organization_information hoi
  WHERE inv.organization_id  = hoi.organization_id
  AND   hoi.org_information_context = 'Accounting Information'
  AND   hoi.org_information2 = to_char(p_movement_transaction.entity_org_id) /* bug 7676431: Added to_char */
  AND   inv.transaction_id   = p_movement_transaction.mtl_transaction_id
  AND   inv.transaction_type_id   IN (21,3,12,2)
  AND   inv.transaction_action_id IN (21,3,12,2)
  AND   NVL(inv.mvt_stat_status,'NEW')   = 'NEW';

Line: 173

  SELECT
    inv.freight_code
  , inv.transaction_type_id
  , inv.transaction_action_id
  , inv.transaction_id
  , inv.organization_id
  , inv.transfer_organization_id
  , inv.transaction_uom
 -- , inv.transaction_date    timezone support donot populate transaction date again
  , inv.primary_quantity
  , inv.inventory_item_id
  , si.description
  , nvl(cst.item_cost,0)+decode(sign(transaction_quantity),-1,0,
                                nvl(inv.transfer_cost,0))
  FROM
    MTL_MATERIAL_TRANSACTIONS inv
  , MTL_SYSTEM_ITEMS si
  , CST_ITEM_COSTS_FOR_GL_VIEW cst
  WHERE inv.organization_id    = si.organization_id
    AND inv.inventory_item_id  = si.inventory_item_id
    AND inv.organization_id    = cst.organization_id(+)
    AND inv.inventory_item_id  = cst.inventory_item_id(+)
    AND inv.transaction_id     = x_movement_transaction.mtl_transaction_id;

Line: 301

PROCEDURE Update_INV_Transactions
( p_movement_transaction IN
    INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
, x_return_status        OUT NOCOPY VARCHAR2
)
IS
l_procedure_name CONSTANT VARCHAR2(30) := 'Update_INV_Transactions';

Line: 319

  UPDATE MTL_MATERIAL_TRANSACTIONS
  SET mvt_stat_status   = 'PROCESSED'
  ,   movement_id       = p_movement_transaction.movement_id
  WHERE transaction_id  = p_movement_transaction.mtl_transaction_id;

Line: 354

END Update_INV_Transactions;