DBA Data[Home] [Help]

APPS.INV_UI_PROJECT_LOVS dependencies on OE_ORDER_LINES_ALL

Line 458: FROM oe_order_lines_all oel,

454: OPEN x_projects FOR
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

Line 471: FROM oe_order_lines_all oel,

467: OPEN x_projects FOR
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

Line 483: FROM oe_order_lines_all oel

479: UNION ALL
480: SELECT DISTINCT -9999 project_id,
481: l_no_proj_str project_number,
482: l_no_proj_str project_name
483: FROM oe_order_lines_all oel
484: WHERE oel.project_id IS NULL
485: AND oel.header_id = p_order_header_id
486: AND ( p_item_id IS NULL
487: OR ( oel.inventory_item_id = p_item_id ) )