APPS.QA_PLAN_ELEMENT_API dependencies on PO_LINES_VAL_V

Line 2374: FROM po_lines_val_v

2370: RETURN BOOLEAN IS
2371:
2372: CURSOR c IS
2373: SELECT 1
2374: FROM po_lines_val_v
2375: WHERE po_header_id = x_po_header_id
2376: AND line_num = x_po_line_number;
2377:
2378: result BOOLEAN;

Line 2412: FROM po_lines_val_v

2408: SELECT 1
2409: FROM po_shipments_all_v
2410: WHERE po_line_id =
2411: (SELECT po_line_id
2412: FROM po_lines_val_v
2413: WHERE line_num = x_po_line_num
2414: AND po_header_id = x_po_header_id)
2415: AND shipment_num = x_po_shipments;
2416: */

Line 3706: FROM po_lines_val_v

3702: -- After Single Scan LOV
3703: wild := value;
3704:
3705: sql_string := 'SELECT line_num, concatenated_segments
3706: FROM po_lines_val_v
3707: WHERE po_header_id = :1
3708: AND line_num like :2
3709: ORDER BY line_num';
3710:

Line 3745: FROM po_lines_val_v

3741: sql_string := 'SELECT shipment_num, shipment_type
3742: FROM po_shipments_all_v
3743: WHERE po_line_id =
3744: (SELECT po_line_id
3745: FROM po_lines_val_v
3746: WHERE line_num = :1
3747: AND po_header_id = :2)
3748: AND shipment_num like :3';
3749: */