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_PART_SEARCH_PVT dependencies on CSP_OPEN_CLOSED_V

Line 646: csp_open_closed_v cocv,

642: sysdate)),2,'OPEN','CLOSED')
643: from
644: csp_required_parts_temp crpt,
645: csp_planning_parameters cpp,
646: csp_open_closed_v cocv,
647: hz_locations hl
648: where cpp.stocking_site_type = 'UNMANNED'
649: and nvl(cpp.stocking_site_excl,'N') = 'N'
650: and decode(p_search_params.distance,null,-1,

Line 743: csp_open_closed_v cocv,

739: sysdate)),2,'OPEN','CLOSED')
740: from
741: csp_required_parts_temp crpt,
742: csp_planning_parameters cpp,
743: csp_open_closed_v cocv,
744: hz_locations hl
745: where cpp.stocking_site_type = 'MANNED'
746: and cpp.organization_id = cr.organization_id
747: and nvl(cpp.stocking_site_excl,'N') = 'N'

Line 838: csp_open_closed_v cocv,

834: sysdate)),2,'OPEN','CLOSED')
835: from
836: csp_required_parts_temp crpt,
837: csp_planning_parameters cpp,
838: csp_open_closed_v cocv,
839: hz_locations hl
840: where cpp.organization_id = p_search_params.source_organization_id
841: and nvl(cpp.stocking_site_excl,'N') = 'N'
842: and hl.location_id (+) = cpp.hz_location_id