APPS.MTL_MOVEMENT_RPT_PKG dependencies on MTL_MOVEMENT_PARAMETERS

Line 192: mtl_movement_parameters mmp

188: select
189: conversion_rate into l_conversion_rate
190: from
191: mtl_uom_conversions_view muc,
192: mtl_movement_parameters mmp
193: where
194: muc.inventory_item_id = l_inventory_item_id
195: and muc.organization_id = l_organization_id
196: and muc.uom_code = mmp.weight_uom_code

Line 253: mtl_movement_parameters mmp

249: select
250: conversion_rate into l_conversion_rate
251: from
252: mtl_uom_conversions_view muc,
253: mtl_movement_parameters mmp
254: where
255: muc.inventory_item_id = l_inventory_item_id
256: and muc.organization_id = l_organization_id
257: and muc.uom_code = mmp.weight_uom_code

Line 529: -- and mtl_movement_parameters table --

525: --
526: -----------------------------------------------------------------------------
527: ------------------------------------------
528: -- Update mtl_movement_statistics table --
529: -- and mtl_movement_parameters table --
530: -- executed in After Report Trigger --
531: ------------------------------------------
532: --
533: procedure AFTER_REPORT_UPDATES

Line 554: -- Update mtl_movement_parameters table --

550: if P_REPORT_OPTION = 'O/S'
551: then
552: begin
553: ------------------------------------------
554: -- Update mtl_movement_parameters table --
555: ------------------------------------------
556: update mtl_movement_parameters
557: set
558: last_update_date = sysdate,

Line 556: update mtl_movement_parameters

552: begin
553: ------------------------------------------
554: -- Update mtl_movement_parameters table --
555: ------------------------------------------
556: update mtl_movement_parameters
557: set
558: last_update_date = sysdate,
559: last_updated_by = P_USER_ID,
560: last_update_login = P_CONC_LOGIN_ID

Line 566: update mtl_movement_parameters

562: --
563: -- If MOVEMENT_TYPE is Arrival
564: if P_MOVEMENT_TYPE = 'A'
565: then
566: update mtl_movement_parameters
567: set
568: last_arrival_id = P_REPORT_REFERENCE,
569: last_arrival_period = P_PERIOD_NAME
570: where entity_org_id = P_LEGAL_ENTITY_ID;

Line 576: update mtl_movement_parameters

572: --
573: -- If MOVEMENT_TYPE is Arrival Adjustment
574: if P_MOVEMENT_TYPE = 'AA'
575: then
576: update mtl_movement_parameters
577: set
578: last_arrival_adj_id = P_REPORT_REFERENCE,
579: last_arrival_adj_period = P_PERIOD_NAME
580: where entity_org_id = P_LEGAL_ENTITY_ID;

Line 586: update mtl_movement_parameters

582: --
583: -- If MOVEMENT_TYPE is Dispatch
584: if P_MOVEMENT_TYPE = 'D'
585: then
586: update mtl_movement_parameters
587: set
588: last_dispatch_id = P_REPORT_REFERENCE,
589: last_dispatch_period = P_PERIOD_NAME
590: where entity_org_id = P_LEGAL_ENTITY_ID;

Line 596: update mtl_movement_parameters

592: --
593: -- If MOVEMENT_TYPE is Dispatch Adjustment
594: if P_MOVEMENT_TYPE = 'DA'
595: then
596: update mtl_movement_parameters
597: set
598: last_dispatch_adj_id = P_REPORT_REFERENCE,
599: last_dispatch_adj_period = P_PERIOD_NAME
600: where entity_org_id = P_LEGAL_ENTITY_ID;