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.INV_UI_PROJECT_LOVS dependencies on PJM_PROJECTS_MTLL_V

Line 47: pjm_projects_mtll_v p

43: SELECT DISTINCT p.project_id,
44: p.project_number,
45: p.project_name
46: FROM po_distributions_all pod,
47: pjm_projects_mtll_v p
48: WHERE pod.project_id = p.project_id
49: AND pod.po_header_id = p_po_header_id
50: AND pod.po_line_id = NVL ( p_po_line_id, pod.po_line_id )
51: AND Nvl(pod.po_release_id,-999) = Nvl(p_po_release_id, Nvl(pod.po_release_id, -999))

Line 68: pjm_projects_mtll_v p

64: SELECT DISTINCT p.project_id,
65: p.project_number,
66: p.project_name
67: FROM po_distributions_all pod,
68: pjm_projects_mtll_v p
69: WHERE pod.project_id = p.project_id
70: AND pod.po_header_id = p_po_header_id
71: AND pod.po_line_id = NVL ( p_po_line_id, pod.po_line_id )
72: AND Nvl(pod.po_release_id,-999) = Nvl(p_po_release_id, Nvl(pod.po_release_id, -999))

Line 127: --pjm_projects_mtll_v; instead, use a union to retrieve

123: END IF;
124:
125: --BUG 4599723
126: --For performance reasons, remove the outer join on
127: --pjm_projects_mtll_v; instead, use a union to retrieve
128: --the no projects row. Also, if user did not enter a string
129: --like the no proj string, don't do the union
130: IF (l_no_proj_str IS NOT NULL AND l_no_proj_str NOT LIKE p_project_number) THEN
131: OPEN x_projects FOR

Line 136: pjm_projects_mtll_v p,

132: SELECT DISTINCT p.project_id,
133: p.project_number,
134: p.project_name
135: FROM po_distributions_all pod,
136: pjm_projects_mtll_v p,
137: po_line_locations_all poll
138: WHERE pod.project_id = p.project_id
139: AND pod.po_header_id = p_po_header_id
140: AND pod.po_line_id = NVL ( p_po_line_id, pod.po_line_id )

Line 166: pjm_projects_mtll_v p,

162: SELECT DISTINCT p.project_id,
163: p.project_number,
164: p.project_name
165: FROM po_distributions_all pod,
166: pjm_projects_mtll_v p,
167: po_line_locations_all poll
168: WHERE pod.project_id = p.project_id
169: AND pod.po_header_id = p_po_header_id
170: AND pod.po_line_id = NVL ( p_po_line_id, pod.po_line_id )

Line 237: --pjm_projects_mtll_v; instead, use a union to retrieve

233: -- print_debug('FOR ASN ' || p_shipment_header_id || ' for lpn ' || p_lpn_id || ' Prj: ' || nvl(p_project_number,'@@@@') || ' PoHeader: ' || nvl(p_po_header_id,-9999));
234:
235: --BUG 4599723
236: --For performance reasons, remove the outer join on
237: --pjm_projects_mtll_v; instead, use a union to retrieve
238: --the no projects row. Also, if user did not enter a string
239: --like the no proj string, don't do the union
240: IF (l_no_proj_str IS NOT NULL AND l_no_proj_str NOT LIKE p_project_number) THEN
241: OPEN x_projects FOR

Line 246: pjm_projects_mtll_v p,

242: SELECT DISTINCT p.project_id,
243: p.project_number,
244: p.project_name
245: FROM po_distributions_all pod,
246: pjm_projects_mtll_v p,
247: rcv_shipment_lines rsl
248: WHERE pod.project_id IS NOT NULL
249: AND pod.po_header_id = rsl.po_header_id
250: AND pod.project_id = p.project_id

Line 274: pjm_projects_mtll_v p,

270: SELECT DISTINCT p.project_id,
271: p.project_number,
272: p.project_name
273: FROM po_distributions_all pod,
274: pjm_projects_mtll_v p,
275: rcv_shipment_lines rsl
276: WHERE pod.project_id IS NOT NULL
277: AND pod.po_header_id = rsl.po_header_id
278: AND pod.project_id = p.project_id

Line 344: --pjm_projects_mtll_v; instead, use a union to retrieve

340: END IF;
341:
342: --BUG 4599723
343: --For performance reasons, remove the outer join on
344: --pjm_projects_mtll_v; instead, use a union to retrieve
345: --the no projects row. Also, if user did not enter a string
346: --like the no proj string, don't do the union
347: IF (l_no_proj_str IS NOT NULL AND l_no_proj_str NOT LIKE p_project_number) THEN
348: OPEN x_projects FOR

Line 353: pjm_projects_mtll_v p,

349: SELECT DISTINCT p.project_id,
350: p.project_number,
351: p.project_name
352: FROM po_req_distributions_all prd,
353: pjm_projects_mtll_v p,
354: po_requisition_lines_all prl
355: WHERE prd.project_id IS NOT NULL
356: AND prd.project_id = p.project_id
357: AND prd.requisition_line_id = prl.requisition_line_id

Line 382: pjm_projects_mtll_v p,

378: SELECT DISTINCT p.project_id,
379: p.project_number,
380: p.project_name
381: FROM po_req_distributions_all prd,
382: pjm_projects_mtll_v p,
383: po_requisition_lines_all prl
384: WHERE prd.project_id IS NOT NULL
385: AND prd.project_id = p.project_id
386: AND prd.requisition_line_id = prl.requisition_line_id

Line 450: --pjm_projects_mtll_v; instead, use a union to retrieve

446: print_debug(' l_no_proj_str:' || l_no_proj_str);
447: END IF;
448: --BUG 4599723
449: --For performance reasons, remove the outer join on
450: --pjm_projects_mtll_v; instead, use a union to retrieve
451: --the no projects row. Also, if user did not enter a string
452: --like the no proj string, don't do the union
453: IF (l_no_proj_str IS NOT NULL AND l_no_proj_str NOT LIKE p_project_number) THEN
454: OPEN x_projects FOR

Line 459: pjm_projects_mtll_v p

455: SELECT DISTINCT p.project_id,
456: p.project_number,
457: p.project_name
458: FROM oe_order_lines_all oel,
459: pjm_projects_mtll_v p
460: WHERE oel.project_id IS NOT NULL
461: AND oel.project_id = p.project_id
462: AND oel.header_id = p_order_header_id
463: AND ( p_item_id IS NULL

Line 472: pjm_projects_mtll_v p

468: SELECT DISTINCT p.project_id,
469: p.project_number,
470: p.project_name
471: FROM oe_order_lines_all oel,
472: pjm_projects_mtll_v p
473: WHERE oel.project_id IS NOT NULL
474: AND oel.project_id = p.project_id
475: AND oel.header_id = p_order_header_id
476: AND ( p_item_id IS NULL

Line 503: FROM pjm_projects_mtll_v p

499: OPEN x_projects FOR
500: SELECT p.project_id,
501: NVL ( p.project_number, ' ' ),
502: NVL ( p.project_name, ' ' )
503: FROM pjm_projects_mtll_v p
504: WHERE p.project_number LIKE ( p_restrict_projects )
505: ORDER BY 2;
506: END GET_PROJECTS;
507:

Line 592: -- the call to PJM_PROJECTS_MTLL_V will return data.

588: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
589: BEGIN
590:
591: -- bug 4662395 set the profile mfg_organization_id so
592: -- the call to PJM_PROJECTS_MTLL_V will return data.
593:
594: FND_PROFILE.put('MFG_ORGANIZATION_ID',p_organization_id);
595:
596: IF p_unscheduled_flag = 2 THEN

Line 610: FROM pjm_projects_mtll_v p,

606: OPEN x_projects FOR
607: SELECT DISTINCT p.project_id,
608: NVL ( p.project_number, ' ' ),
609: NVL ( p.project_name, ' ' )
610: FROM pjm_projects_mtll_v p,
611: mtl_cycle_count_entries mcce,
612: mtl_item_locations mil
613: WHERE mil.segment19 = p.project_id
614: AND mcce.locator_id = mil.inventory_location_id

Line 633: FROM pjm_projects_mtll_v p

629: OPEN x_projects FOR
630: SELECT p.project_id,
631: NVL ( p.project_number, ' ' ),
632: NVL ( p.project_name, ' ' )
633: FROM pjm_projects_mtll_v p
634: WHERE p.project_number LIKE ( p_project_number )
635: ORDER BY 2;
636: END IF;
637: END;

Line 651: -- the call to PJM_PROJECTS_MTLL_V will return data.

647: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
648: BEGIN
649:
650: -- bug 4662395 set the profile mfg_organization_id so
651: -- the call to PJM_PROJECTS_MTLL_V will return data.
652:
653: FND_PROFILE.put('MFG_ORGANIZATION_ID',p_organization_id);
654:
655: IF ( p_dynamic_entry_flag = 2 ) THEN

Line 660: FROM pjm_projects_mtll_v p,

656: OPEN x_projects FOR
657: SELECT DISTINCT p.project_id,
658: NVL ( p.project_number, ' ' ),
659: NVL ( p.project_name, ' ' )
660: FROM pjm_projects_mtll_v p,
661: mtl_physical_inventory_tags mpi,
662: mtl_item_locations mil
663: WHERE mil.project_id = p.project_id
664: AND mil.inventory_location_id = mpi.locator_id

Line 675: FROM pjm_projects_mtll_v p

671: OPEN x_projects FOR
672: SELECT p.project_id,
673: NVL ( p.project_number, ' ' ),
674: NVL ( p.project_name, ' ' )
675: FROM pjm_projects_mtll_v p
676: WHERE p.project_number LIKE ( p_project_number )
677: ORDER BY 2;
678: END IF;
679: END;

Line 692: -- the call to PJM_PROJECTS_MTLL_V will return data.

688: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
689: BEGIN
690:
691: -- bug 4662395 set the profile mfg_organization_id so
692: -- the call to PJM_PROJECTS_MTLL_V will return data.
693:
694: FND_PROFILE.put('MFG_ORGANIZATION_ID',p_organization_id);
695:
696: OPEN x_projects FOR

Line 700: FROM pjm_projects_mtll_v p

696: OPEN x_projects FOR
697: SELECT p.project_id,
698: NVL ( p.project_number, ' ' ),
699: NVL ( p.project_name, ' ' )
700: FROM pjm_projects_mtll_v p
701: WHERE p.project_number LIKE ( p_restrict_projects )
702: AND p.project_id IN (
703: SELECT mtrl.project_id
704: FROM mtl_txn_request_lines mtrl