APPS.CSP_PICK_UTILS dependencies on FND_LOOKUP_VALUES

Line 2555: FROM FND_LOOKUP_VALUES LV

2551: BEGIN
2552:
2553: SELECT meaning
2554: INTO G_STATUS_MEANING
2555: FROM FND_LOOKUP_VALUES LV
2556: WHERE lookup_type = 'SHIPMENT LINE STATUS'
2557: AND lookup_code = l_status
2558: AND LANGUAGE = USERENV('LANG')
2559: AND VIEW_APPLICATION_ID = 201

Line 2568: FROM fnd_lookup_values lv

2564: WHEN NO_DATA_FOUND THEN
2565: l_status := p_flow_status_code;
2566: SELECT meaning
2567: INTO G_STATUS_MEANING
2568: FROM fnd_lookup_values lv
2569: WHERE lookup_type = 'LINE_FLOW_STATUS'
2570: AND lookup_code = p_flow_status_code
2571: AND LANGUAGE = userenv('LANG')
2572: AND VIEW_APPLICATION_ID = 660

Line 2586: FROM fnd_lookup_values lv

2582: l_status := p_flow_status_code;
2583:
2584: SELECT meaning
2585: INTO G_STATUS_MEANING
2586: FROM fnd_lookup_values lv
2587: WHERE lookup_type = 'LINE_FLOW_STATUS'
2588: AND lookup_code = p_flow_status_code
2589: AND LANGUAGE = userenv('LANG')
2590: AND VIEW_APPLICATION_ID = 660

Line 2608: FROM fnd_lookup_values lv

2604: IF l_released_count = l_total_count THEN
2605: l_status := 'PICKED';
2606: SELECT meaning
2607: INTO G_STATUS_MEANING
2608: FROM fnd_lookup_values lv
2609: WHERE lookup_type = 'LINE_FLOW_STATUS'
2610: AND lookup_code = 'PICKED'
2611: AND LANGUAGE = userenv('LANG')
2612: AND VIEW_APPLICATION_ID = 660

Line 2619: FROM fnd_lookup_values lv

2615: ELSIF l_released_count < l_total_count and l_released_count <> 0 THEN
2616: l_status := 'PICKED_PARTIAL';
2617: SELECT meaning
2618: INTO G_STATUS_MEANING
2619: FROM fnd_lookup_values lv
2620: WHERE lookup_type = 'LINE_FLOW_STATUS'
2621: AND lookup_code = 'PICKED_PARTIAL'
2622: AND LANGUAGE = userenv('LANG')
2623: AND VIEW_APPLICATION_ID = 660

Line 2629: FROM fnd_lookup_values lv

2625: lv.view_application_id);
2626: ELSE
2627: SELECT meaning
2628: INTO G_STATUS_MEANING
2629: FROM fnd_lookup_values lv
2630: WHERE lookup_type = 'LINE_FLOW_STATUS'
2631: AND lookup_code = l_status
2632: AND LANGUAGE = userenv('LANG')
2633: AND VIEW_APPLICATION_ID = 660

Line 2735: FROM fnd_lookup_values lv

2731: IS
2732: x_status VARCHAR2(4000);
2733: CURSOR c_default_status(v_lookup_type varchar2,v_lookup_code varchar2) is
2734: SELECT meaning
2735: FROM fnd_lookup_values lv
2736: WHERE lookup_type = v_lookup_type
2737: AND lookup_code = v_lookup_code
2738: And Language = 'US'
2739: And View_Application_Id = 660;

Line 2752: FND_LOOKUP_VALUES fl

2748: SELECT fl.meaning
2749: FROM po_Requisition_lines_all prl,
2750: oe_order_lines_all oola,
2751: rcv_shipment_lines rsl,
2752: FND_LOOKUP_VALUES fl
2753: WHERE prl.requisition_line_id = rsl.requisition_line_id
2754: AND oola.source_document_line_id = prl.requisition_line_id
2755: AND oola.source_document_type_id = 10
2756: AND oola.line_id = v_line_id

Line 2786: FROM fnd_lookup_values lv

2782: END LOOP;
2783: ELSE
2784: SELECT meaning
2785: INTO x_status
2786: FROM fnd_lookup_values lv
2787: WHERE lookup_type = p_lookup_type
2788: AND lookup_code = p_flow_status_code
2789: AND LANGUAGE = userenv('LANG')
2790: AND VIEW_APPLICATION_ID = 660;