APPS.MTL_MOVEMENT_RPT_PKG dependencies on MTL_MOVEMENT_STATISTICS

Line 305: -- Update mtl_movement_statistics table --

301: end REPORT_DATE_CALC;
302: --
303: -----------------------------------------------------------------------------
304: ------------------------------------------
305: -- Update mtl_movement_statistics table --
306: -- executed in Before Report Trigger --
307: ------------------------------------------
308: --
309: procedure BEFORE_REPORT_UPDATES

Line 339: -- in MTL_MOVEMENT_STATISTICS table --

335: then
336: begin
337: -------------------------------------------------------
338: -- Update of INVOICE_DATE_REFERENCE --
339: -- in MTL_MOVEMENT_STATISTICS table --
340: -- if DOCUMENT_SOURCE_TYPE is not Miscellaneous --
341: -- (Required for Where Clause of select and updates) --
342: -------------------------------------------------------
343: update mtl_movement_statistics mms

Line 343: update mtl_movement_statistics mms

339: -- in MTL_MOVEMENT_STATISTICS table --
340: -- if DOCUMENT_SOURCE_TYPE is not Miscellaneous --
341: -- (Required for Where Clause of select and updates) --
342: -------------------------------------------------------
343: update mtl_movement_statistics mms
344: set invoice_date_reference = (select invoice_date
345: from ap_invoices
346: where invoice_id = mms.invoice_id)
347: where mms.movement_type = P_MOVEMENT_TYPE

Line 353: update mtl_movement_statistics mms

349: and mms.movement_status = 'O'
350: and mms.document_source_type = 'PO'
351: and mms.invoice_id is not null;
352: --
353: update mtl_movement_statistics mms
354: set invoice_date_reference = (select trx_date
355: from ra_customer_trx
356: where customer_trx_id = mms.invoice_id)
357: where mms.movement_type = P_MOVEMENT_TYPE

Line 364: -- Update in MTL_MOVEMENT_STATISTICS table --

360: and mms.document_source_type = 'SO'
361: and mms.invoice_id is not null;
362: --
363: ---------------------------------------------
364: -- Update in MTL_MOVEMENT_STATISTICS table --
365: -- for the movements of the period --
366: ---------------------------------------------
367: update mtl_movement_statistics mms
368: set

Line 367: update mtl_movement_statistics mms

363: ---------------------------------------------
364: -- Update in MTL_MOVEMENT_STATISTICS table --
365: -- for the movements of the period --
366: ---------------------------------------------
367: update mtl_movement_statistics mms
368: set
369: last_update_date = sysdate,
370: last_updated_by = P_USER_ID,
371: last_update_login = P_CONC_LOGIN_ID,

Line 413: update mtl_movement_statistics mms

409: mms.transaction_date between C_START_DATE and C_END_DATE)))))
410: and mms.movement_status = 'O';
411: --
412: -- Currency Conversion
413: update mtl_movement_statistics mms
414: set
415: currency_conversion_rate = MTL_MOVEMENT_RPT_PKG.EXCHANGE_RATE_CALC
416: (C_CONVERSION_OPTION,
417: C_CONVERSION_TYPE,

Line 472: update mtl_movement_statistics mms

468: mms.transaction_date between C_START_DATE and C_END_DATE)))))
469: and mms.movement_status = 'O';
470: --
471: -- If WEIGHT_METHOD is System
472: update mtl_movement_statistics mms
473: set
474: unit_weight = MTL_MOVEMENT_RPT_PKG.UNIT_WEIGHT_CALC
475: (inventory_item_id,
476: organization_id,

Line 528: -- Update mtl_movement_statistics table --

524: end BEFORE_REPORT_UPDATES;
525: --
526: -----------------------------------------------------------------------------
527: ------------------------------------------
528: -- Update mtl_movement_statistics table --
529: -- and mtl_movement_parameters table --
530: -- executed in After Report Trigger --
531: ------------------------------------------
532: --

Line 604: -- Update mtl_movement_statistics table --

600: where entity_org_id = P_LEGAL_ENTITY_ID;
601: end if;
602: --
603: ------------------------------------------
604: -- Update mtl_movement_statistics table --
605: -- for Freeze --
606: ------------------------------------------
607: update mtl_movement_statistics mms
608: set

Line 607: update mtl_movement_statistics mms

603: ------------------------------------------
604: -- Update mtl_movement_statistics table --
605: -- for Freeze --
606: ------------------------------------------
607: update mtl_movement_statistics mms
608: set
609: movement_status = 'F'
610: where
611: mms.movement_type = P_MOVEMENT_TYPE

Line 654: -- Update mtl_movement_statistics table --

650: if P_REPORT_OPTION = 'NO/S'
651: then
652: begin
653: ------------------------------------------
654: -- Update mtl_movement_statistics table --
655: -- for Open --
656: ------------------------------------------
657: update mtl_movement_statistics mms
658: set

Line 657: update mtl_movement_statistics mms

653: ------------------------------------------
654: -- Update mtl_movement_statistics table --
655: -- for Open --
656: ------------------------------------------
657: update mtl_movement_statistics mms
658: set
659: movement_status = 'O',
660: last_update_date = sysdate,
661: last_updated_by = P_USER_ID,

Line 702: update mtl_movement_statistics mms

698: mms.transaction_date between C_START_DATE and C_END_DATE)))))
699: and mms.movement_status = 'F';
700: --
701: -- If DOCUMENT_SOURCE_TYPE is Miscelaneous
702: update mtl_movement_statistics mms
703: set
704: currency_conversion_rate = null,
705: currency_conversion_type = null,
706: currency_conversion_date = null

Line 744: update mtl_movement_statistics mms

740: and mms.movement_status = 'F'
741: and mms.document_source_type <> 'MISC';
742: --
743: -- If WEIGHT_METHOD is not Manual
744: update mtl_movement_statistics mms
745: set
746: unit_weight = null,
747: total_weight = null
748: where