eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MRP_SOURCING_API_PK dependencies on MRP_SOURCING_HISTORY

Line 636: delete from mrp_sourcing_history msh

632: -- delete the previous record for the previous date range in the Sourcing rule.
633: -- Here only the previous record is deleted. If a SR is changed for an item, then in the
634: -- form we must clean up unnecassary history
635:
636: delete from mrp_sourcing_history msh
637: where
638: msh.inventory_item_id = arg_item_id
639: and msh.organization_id = arg_org_id
640: and msh.sourcing_rule_id = arg_sourcing_rule_id

Line 653: insert into mrp_sourcing_history

649: -- sourcing_rule_id is there in the table so that if we change the SR, then the history
650: -- is recalculated. It is ok if the assignment changes, since history is related to the SR
651: -- only. that is y assignment set is not a column.
652:
653: insert into mrp_sourcing_history
654: (
655: inventory_item_id,
656: organization_id,
657: sourcing_rule_id,