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.CSP_PLAN_DETAILS_PKG dependencies on MTL_INTERORG_SHIP_METHODS

Line 483: from MRP_ITEM_SOURCING_LEVELS_V misl, csp_planning_parameters cpp, mtl_interorg_ship_methods mism1

479: select
480: cpd.inventory_item_id,
481: cpd.organization_id,
482: (select max(nvl(mism1.intransit_time, 0))
483: from MRP_ITEM_SOURCING_LEVELS_V misl, csp_planning_parameters cpp, mtl_interorg_ship_methods mism1
484: where mism1.to_organization_id = cpp.organization_id
485: and mism1.from_organization_id = misl.source_organization_id
486: and mism1.default_flag = 1
487: and cpp.organization_id = cpd.organization_id

Line 503: mtl_interorg_ship_methods mism2

499: nvl(msib.repair_leadtime, 0) +
500: (select nvl(max(nvl(mism2.intransit_time, 0)), 0)
501: from MRP_ITEM_SOURCING_LEVELS_V misl1,
502: csp_planning_parameters cpp,
503: mtl_interorg_ship_methods mism2
504: where mism2.to_organization_id = decode(misl.source_type, 1, misl.source_organization_id, 3, hoi.organization_id)
505: and mism2.from_organization_id = misl1.source_organization_id
506: and mism2.default_flag = 1
507: and cpp.organization_id = cpd.organization_id

Line 521: mtl_interorg_ship_methods mism,

517: and sourcing_level not in (2,9))
518: ))
519: from MRP_ITEM_SOURCING_LEVELS_V misl,
520: csp_planning_parameters cpp,
521: mtl_interorg_ship_methods mism,
522: mtl_system_items_b msib,
523: hr_organization_information hoi
524: where msib.inventory_item_id = cpd.inventory_item_id
525: and msib.organization_id = decode(misl.source_type, 1, misl.source_organization_id, 3, hoi.organization_id)