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.CTO_MSUTIL_PUB dependencies on MRP_SR_SOURCE_ORG

Line 3599: --For this sourcing rule, there would be 4 records in table mrp_sr_source_org for one

3595: --Bugfix 13029577: Adding a distinct. This sql returns same assignment_id multiple
3596: --times if there is a global transfer from sourcing rule from multiple orgs. Ex.
3597: --Let the rule be:
3598: --Transfer from M1:50%, M2:30%, M3:15%, M4:5%
3599: --For this sourcing rule, there would be 4 records in table mrp_sr_source_org for one
3600: --value of sr_receipt_id.
3601: --The result is that the same assignment is attempted multiple times. MRP API
3602: --process_assignment throws ORA-00001: unique constraint (MRP.MRP_SR_ASSIGNMENTS_U2)
3603: --violated error.

Line 3609: mrp_sr_source_org src,

3605: assg.assignment_id,
3606: assg.assignment_type
3607: from
3608: mrp_sr_receipt_org rcv,
3609: mrp_sr_source_org src,
3610: mrp_sr_assignments assg,
3611: mrp_sourcing_rules rule,
3612: po_vendor_sites_all vend
3613: where