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 MRP_ITEM_SOURCING_LEVELS_V

Line 112: from MRP_ITEM_SOURCING_LEVELS_V misl, csp_planning_parameters cpp

108: and nvl(cic.item_cost,0) > 0;
109:
110: cursor c_rep_int_ext(p_organization_id number,p_supplied_item_id number) is
111: select decode(misl.source_type,1,'INTERNAL','EXTERNAL')
112: from MRP_ITEM_SOURCING_LEVELS_V misl, csp_planning_parameters cpp
113: where cpp.organization_id = p_organization_id
114: and misl.organization_id = cpp.organization_id
115: and misl.assignment_set_id =cpp.repair_assignment_set_id
116: and inventory_item_id = p_supplied_item_id

Line 119: MRP_ITEM_SOURCING_LEVELS_V

115: and misl.assignment_set_id =cpp.repair_assignment_set_id
116: and inventory_item_id = p_supplied_item_id
117: and SOURCE_TYPE in (1,3)
118: and sourcing_level = (select min(sourcing_level) from
119: MRP_ITEM_SOURCING_LEVELS_V
120: where organization_id = p_organization_id
121: and assignment_set_id = cpp.repair_assignment_set_id
122: and inventory_item_id = p_supplied_item_id
123: and sourcing_level not in (2,9))

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 493: from MRP_ITEM_SOURCING_LEVELS_V

489: and misl.assignment_set_id =cpp.usable_assignment_set_id
490: and misl.inventory_item_id = cpd.inventory_item_id
491: and misl.SOURCE_TYPE = 1
492: and sourcing_level = (select min(sourcing_level)
493: from MRP_ITEM_SOURCING_LEVELS_V
494: where organization_id = cpd.organization_id
495: and assignment_set_id = cpp.usable_assignment_set_id
496: and inventory_item_id = cpd.inventory_item_id
497: and sourcing_level not in (2,9))) Excess_Lead_Time,

Line 501: from MRP_ITEM_SOURCING_LEVELS_V misl1,

497: and sourcing_level not in (2,9))) Excess_Lead_Time,
498: (select max(nvl(mism.intransit_time, 0) +
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

Line 513: from MRP_ITEM_SOURCING_LEVELS_V

509: and misl1.assignment_set_id =cpp.defective_assignment_set_id
510: and misl1.inventory_item_id = cpd.inventory_item_id
511: and SOURCE_TYPE = 1
512: and sourcing_level = (select min(sourcing_level)
513: from MRP_ITEM_SOURCING_LEVELS_V
514: where organization_id = cpd.organization_id
515: and assignment_set_id = cpp.defective_assignment_set_id
516: and inventory_item_id = cpd.inventory_item_id
517: and sourcing_level not in (2,9))

Line 519: from MRP_ITEM_SOURCING_LEVELS_V misl,

515: and assignment_set_id = cpp.defective_assignment_set_id
516: and inventory_item_id = cpd.inventory_item_id
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

Line 535: from MRP_ITEM_SOURCING_LEVELS_V

531: and misl.assignment_set_id = cpp.repair_assignment_set_id
532: and misl.inventory_item_id = cpd.inventory_item_id
533: and misl.SOURCE_TYPE in ( 1, 3)
534: and sourcing_level = (select min(sourcing_level)
535: from MRP_ITEM_SOURCING_LEVELS_V
536: where organization_id = cpd.organization_id
537: and assignment_set_id = cpp.repair_assignment_set_id
538: and inventory_item_id = cpd.inventory_item_id
539: and sourcing_level not in (2,9))

Line 2514: from MRP_ITEM_SOURCING_LEVELS_V mislv,

2510: sysdate,
2511: fnd_global.user_id,
2512: sysdate,
2513: fnd_global.login_id
2514: from MRP_ITEM_SOURCING_LEVELS_V mislv,
2515: csp_plan_reorders cpr,
2516: csp_plan_details cpd
2517: where mislv.organization_id = l_organization_id
2518: and mislv.assignment_set_id = l_usable_assignment_set_id

Line 2575: from MRP_ITEM_SOURCING_LEVELS_V mislv,

2571: sysdate,
2572: fnd_global.user_id,
2573: sysdate,
2574: fnd_global.login_id
2575: from MRP_ITEM_SOURCING_LEVELS_V mislv,
2576: csp_plan_details cpd
2577: where mislv.organization_id = cpd.organization_id
2578: and mislv.assignment_set_id = l_defective_assignment_set_id
2579: and mislv.inventory_item_id = cpd.inventory_item_id

Line 2619: from MRP_ITEM_SOURCING_LEVELS_V mislv,

2615: sysdate,
2616: fnd_global.user_id,
2617: sysdate,
2618: fnd_global.login_id
2619: from MRP_ITEM_SOURCING_LEVELS_V mislv,
2620: csp_plan_details cpd,
2621: mtl_related_items mri,
2622: mtl_parameters mp
2623: where mislv.organization_id = cpd.organization_id